> ## Documentation Index
> Fetch the complete documentation index at: https://docs.kinetica.com/llms.txt
> Use this file to discover all available pages before exploring further.

# kinetica.GetRecordsRequest.Options

> kinetica.GetRecordsRequest.Options — Kinetica C# API

<div className="kinetica-doxygen">
  <div className="contents">
    <p>A set of string constants for the parameter <a className="el" href="/content/api/cs/classkinetica_1_1GetRecordsRequest#aec68cbdd6e83f86016fa46dfbb0415ff">GetRecordsRequest.options</a>. <a href="#details">More...</a></p>

    <table className="memberdecls">
      <tr className="heading">
        <td colSpan="2">
          <h2 className="groupheader"> Static Public Attributes</h2>
        </td>
      </tr>

      <tr className="memitem:a8d1a2af28d6f5e016ebb68bc42585d3a" id="r_a8d1a2af28d6f5e016ebb68bc42585d3a">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a8d1a2af28d6f5e016ebb68bc42585d3a">EXPRESSION</a> = "expression"</td>
      </tr>

      <tr className="memdesc:a8d1a2af28d6f5e016ebb68bc42585d3a">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Filter expression to apply to the table. <br /></td>
      </tr>

      <tr className="separator:a8d1a2af28d6f5e016ebb68bc42585d3a">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:ae2a5c4326efe3c79efe8180dbf7bc7c2" id="r_ae2a5c4326efe3c79efe8180dbf7bc7c2">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#ae2a5c4326efe3c79efe8180dbf7bc7c2">FAST\_INDEX\_LOOKUP</a> = "fast\_index\_lookup"</td>
      </tr>

      <tr className="memdesc:ae2a5c4326efe3c79efe8180dbf7bc7c2">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Indicates if indexes should be used to perform the lookup for a given expression if possible. <br /></td>
      </tr>

      <tr className="separator:ae2a5c4326efe3c79efe8180dbf7bc7c2">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:a805b20aaee72a5d9cc1f3d86a9636298" id="r_a805b20aaee72a5d9cc1f3d86a9636298">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a805b20aaee72a5d9cc1f3d86a9636298">TRUE</a> = "true"</td>
      </tr>

      <tr className="memdesc:a805b20aaee72a5d9cc1f3d86a9636298">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">A boolean constant for the <a className="el" href="/content/api/cs/structkinetica_1_1GetRecordsRequest_1_1Options" title="A set of string constants for the parameter GetRecordsRequest.options.">GetRecordsRequest.Options</a> options. <br /></td>
      </tr>

      <tr className="separator:a805b20aaee72a5d9cc1f3d86a9636298">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:a32f9ae20dc72d8514104ac792e881680" id="r_a32f9ae20dc72d8514104ac792e881680">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a32f9ae20dc72d8514104ac792e881680">FALSE</a> = "false"</td>
      </tr>

      <tr className="memdesc:a32f9ae20dc72d8514104ac792e881680">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">A boolean constant for the <a className="el" href="/content/api/cs/structkinetica_1_1GetRecordsRequest_1_1Options" title="A set of string constants for the parameter GetRecordsRequest.options.">GetRecordsRequest.Options</a> options. <br /></td>
      </tr>

      <tr className="separator:a32f9ae20dc72d8514104ac792e881680">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:a7b3f35dfdb3579331fbe5f9584b41474" id="r_a7b3f35dfdb3579331fbe5f9584b41474">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a7b3f35dfdb3579331fbe5f9584b41474">SORT\_BY</a> = "sort\_by"</td>
      </tr>

      <tr className="memdesc:a7b3f35dfdb3579331fbe5f9584b41474">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Column that the data should be sorted by. <br /></td>
      </tr>

      <tr className="separator:a7b3f35dfdb3579331fbe5f9584b41474">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:ab7b7c4972cd209fba5139d2e73fabec0" id="r_ab7b7c4972cd209fba5139d2e73fabec0">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#ab7b7c4972cd209fba5139d2e73fabec0">SORT\_ORDER</a> = "sort\_order"</td>
      </tr>

      <tr className="memdesc:ab7b7c4972cd209fba5139d2e73fabec0">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">String indicating how the returned values should be sorted. <br /></td>
      </tr>

      <tr className="separator:ab7b7c4972cd209fba5139d2e73fabec0">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:a1c95f577c254978acdf4f82947c20697" id="r_a1c95f577c254978acdf4f82947c20697">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a1c95f577c254978acdf4f82947c20697">ASCENDING</a> = "ascending"</td>
      </tr>

      <tr className="memdesc:a1c95f577c254978acdf4f82947c20697">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">A constant for the <a className="el" href="/content/api/cs/structkinetica_1_1GetRecordsRequest_1_1Options" title="A set of string constants for the parameter GetRecordsRequest.options.">GetRecordsRequest.Options</a> options. <br /></td>
      </tr>

      <tr className="separator:a1c95f577c254978acdf4f82947c20697">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:a741e9dfdb528f0a420d3e5825b5d5a92" id="r_a741e9dfdb528f0a420d3e5825b5d5a92">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a741e9dfdb528f0a420d3e5825b5d5a92">DESCENDING</a> = "descending"</td>
      </tr>

      <tr className="memdesc:a741e9dfdb528f0a420d3e5825b5d5a92">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">A constant for the <a className="el" href="/content/api/cs/structkinetica_1_1GetRecordsRequest_1_1Options" title="A set of string constants for the parameter GetRecordsRequest.options.">GetRecordsRequest.Options</a> options. <br /></td>
      </tr>

      <tr className="separator:a741e9dfdb528f0a420d3e5825b5d5a92">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>
    </table>

    <h2 className="groupheader">Detailed Description</h2>

    <div className="textblock">
      <p>A set of string constants for the parameter <a className="el" href="/content/api/cs/classkinetica_1_1GetRecordsRequest#aec68cbdd6e83f86016fa46dfbb0415ff">GetRecordsRequest.options</a>. </p>
      <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2GetRecords_8cs_source#l00053">53</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2GetRecords_8cs_source">GetRecords.cs</a>.</p>
    </div>

    <h2 className="groupheader">Member Data Documentation</h2>
    <h2 className="memtitle"><span className="permalink"><a href="#a1c95f577c254978acdf4f82947c20697">◆ </a></span>ASCENDING</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.GetRecordsRequest.Options.ASCENDING = "ascending"</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel static">static</span></span> </td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>A constant for the <a className="el" href="/content/api/cs/structkinetica_1_1GetRecordsRequest_1_1Options" title="A set of string constants for the parameter GetRecordsRequest.options.">GetRecordsRequest.Options</a> options. </p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2GetRecords_8cs_source#l00116">116</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2GetRecords_8cs_source">GetRecords.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a741e9dfdb528f0a420d3e5825b5d5a92">◆ </a></span>DESCENDING</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.GetRecordsRequest.Options.DESCENDING = "descending"</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel static">static</span></span> </td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>A constant for the <a className="el" href="/content/api/cs/structkinetica_1_1GetRecordsRequest_1_1Options" title="A set of string constants for the parameter GetRecordsRequest.options.">GetRecordsRequest.Options</a> options. </p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2GetRecords_8cs_source#l00120">120</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2GetRecords_8cs_source">GetRecords.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a8d1a2af28d6f5e016ebb68bc42585d3a">◆ </a></span>EXPRESSION</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.GetRecordsRequest.Options.EXPRESSION = "expression"</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel static">static</span></span> </td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>Filter expression to apply to the table. </p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2GetRecords_8cs_source#l00056">56</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2GetRecords_8cs_source">GetRecords.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a32f9ae20dc72d8514104ac792e881680">◆ </a></span>FALSE</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.GetRecordsRequest.Options.FALSE = "false"</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel static">static</span></span> </td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>A boolean constant for the <a className="el" href="/content/api/cs/structkinetica_1_1GetRecordsRequest_1_1Options" title="A set of string constants for the parameter GetRecordsRequest.options.">GetRecordsRequest.Options</a> options. </p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2GetRecords_8cs_source#l00085">85</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2GetRecords_8cs_source">GetRecords.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#ae2a5c4326efe3c79efe8180dbf7bc7c2">◆ </a></span>FAST\_INDEX\_LOOKUP</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.GetRecordsRequest.Options.FAST\_INDEX\_LOOKUP = "fast\_index\_lookup"</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel static">static</span></span> </td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>Indicates if indexes should be used to perform the lookup for a given expression if possible. </p>
        <p>Only applicable if there is no sorting, the expression contains only equivalence comparisons based on existing tables indexes and the range of requested values is from \[0 to END\_OF\_SET]. Supported values:</p>

        <ul>
          <li> <a className="el" href="#a805b20aaee72a5d9cc1f3d86a9636298">TRUE</a> </li>
          <li> <a className="el" href="#a32f9ae20dc72d8514104ac792e881680">FALSE</a> </li>
        </ul>

        <p>The default value is <a className="el" href="#a805b20aaee72a5d9cc1f3d86a9636298">TRUE</a>.</p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2GetRecords_8cs_source#l00077">77</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2GetRecords_8cs_source">GetRecords.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a7b3f35dfdb3579331fbe5f9584b41474">◆ </a></span>SORT\_BY</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.GetRecordsRequest.Options.SORT\_BY = "sort\_by"</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel static">static</span></span> </td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>Column that the data should be sorted by. </p>
        <p>Empty by default (i.e. no sorting is applied). </p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2GetRecords_8cs_source#l00090">90</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2GetRecords_8cs_source">GetRecords.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#ab7b7c4972cd209fba5139d2e73fabec0">◆ </a></span>SORT\_ORDER</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.GetRecordsRequest.Options.SORT\_ORDER = "sort\_order"</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel static">static</span></span> </td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>String indicating how the returned values should be sorted. </p>

        <ul>
          <li>ascending or descending. </li>
        </ul>

        <p>If sort\_order is provided, sort\_by has to be provided. Supported values:</p>

        <ul>
          <li> <a className="el" href="#a1c95f577c254978acdf4f82947c20697">ASCENDING</a> </li>
          <li> <a className="el" href="#a741e9dfdb528f0a420d3e5825b5d5a92">DESCENDING</a> </li>
        </ul>

        <p>The default value is <a className="el" href="#a1c95f577c254978acdf4f82947c20697">ASCENDING</a>.</p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2GetRecords_8cs_source#l00112">112</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2GetRecords_8cs_source">GetRecords.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a805b20aaee72a5d9cc1f3d86a9636298">◆ </a></span>TRUE</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.GetRecordsRequest.Options.TRUE = "true"</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel static">static</span></span> </td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>A boolean constant for the <a className="el" href="/content/api/cs/structkinetica_1_1GetRecordsRequest_1_1Options" title="A set of string constants for the parameter GetRecordsRequest.options.">GetRecordsRequest.Options</a> options. </p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2GetRecords_8cs_source#l00081">81</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2GetRecords_8cs_source">GetRecords.cs</a>.</p>
      </div>
    </div>

    <hr />

    The documentation for this struct was generated from the following files:

    <ul>
      <li>\_build/public-os\_ubuntu24.04-arch\_amd64-cc\_gcc\_13.3.0/install/Kinetica/Protocol/<a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2GetRecords_8cs_source">GetRecords.cs</a></li>
      <li>Kinetica/Protocol/<a className="el" href="/content/api/cs/Kinetica_2Protocol_2GetRecords_8cs_source">GetRecords.cs</a></li>
    </ul>
  </div>
</div>