> ## 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#a3e520fc39946bbe0b1dc663689870c0a">GetRecordsRequest.options</a>. <a href="#details">More...</a></p>

    <table className="memberdecls">
      <tr className="heading">
        <td colSpan="2">
          <h2 className="groupheader">
            <div id="pub-static-attribs" />

            Static Public Attributes
          </h2>
        </td>
      </tr>

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

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

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

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

      <tr className="memdesc:a4c2bc06d5c1248fd64c876bec775eb9d">
        <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:a4c2bc06d5c1248fd64c876bec775eb9d">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

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

      <tr className="memdesc:a509446a4d6cf928f879273b815e28f29">
        <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:a509446a4d6cf928f879273b815e28f29">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

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

      <tr className="memdesc:afaabb852b5ec2fda5fd8c66eb7a0ae2c">
        <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:afaabb852b5ec2fda5fd8c66eb7a0ae2c">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

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

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

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

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

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

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

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

      <tr className="memdesc:a402903a2a6b1033fda983433504cf9bf">
        <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:a402903a2a6b1033fda983433504cf9bf">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

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

      <tr className="memdesc:a4bd4f019dc18212bfcb33ccf2a486f65">
        <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:a4bd4f019dc18212bfcb33ccf2a486f65">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>
    </table>

    <div id="details" />

    <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#a3e520fc39946bbe0b1dc663689870c0a">GetRecordsRequest.options</a>. </p>
      <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/GetRecords.cs#L53">53</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/GetRecords.cs">GetRecords.cs</a>.</p>
    </div>

    <h2 className="groupheader">Member Data Documentation</h2>

    <div id="a402903a2a6b1033fda983433504cf9bf" />

    <h2 className="memtitle"><span className="permalink"><a href="#a402903a2a6b1033fda983433504cf9bf">◆ </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="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/GetRecords.cs#L116">116</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/GetRecords.cs">GetRecords.cs</a>.</p>
      </div>
    </div>

    <div id="a4bd4f019dc18212bfcb33ccf2a486f65" />

    <h2 className="memtitle"><span className="permalink"><a href="#a4bd4f019dc18212bfcb33ccf2a486f65">◆ </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="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/GetRecords.cs#L120">120</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/GetRecords.cs">GetRecords.cs</a>.</p>
      </div>
    </div>

    <div id="a94b65a3dfe98281f0e1229588b2a1756" />

    <h2 className="memtitle"><span className="permalink"><a href="#a94b65a3dfe98281f0e1229588b2a1756">◆ </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="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/GetRecords.cs#L56">56</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/GetRecords.cs">GetRecords.cs</a>.</p>
      </div>
    </div>

    <div id="afaabb852b5ec2fda5fd8c66eb7a0ae2c" />

    <h2 className="memtitle"><span className="permalink"><a href="#afaabb852b5ec2fda5fd8c66eb7a0ae2c">◆ </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="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/GetRecords.cs#L85">85</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/GetRecords.cs">GetRecords.cs</a>.</p>
      </div>
    </div>

    <div id="a4c2bc06d5c1248fd64c876bec775eb9d" />

    <h2 className="memtitle"><span className="permalink"><a href="#a4c2bc06d5c1248fd64c876bec775eb9d">◆ </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="#a509446a4d6cf928f879273b815e28f29">TRUE</a> </li>
          <li> <a className="el" href="#afaabb852b5ec2fda5fd8c66eb7a0ae2c">FALSE</a> </li>
        </ul>

        <p>The default value is <a className="el" href="#a509446a4d6cf928f879273b815e28f29">TRUE</a>.</p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/GetRecords.cs#L77">77</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/GetRecords.cs">GetRecords.cs</a>.</p>
      </div>
    </div>

    <div id="a9099227461efce6c583551240e6e70e9" />

    <h2 className="memtitle"><span className="permalink"><a href="#a9099227461efce6c583551240e6e70e9">◆ </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="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/GetRecords.cs#L90">90</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/GetRecords.cs">GetRecords.cs</a>.</p>
      </div>
    </div>

    <div id="abc1b5b65499a79fde0a3eaaef4f76b0b" />

    <h2 className="memtitle"><span className="permalink"><a href="#abc1b5b65499a79fde0a3eaaef4f76b0b">◆ </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="#a402903a2a6b1033fda983433504cf9bf">ASCENDING</a> </li>
          <li> <a className="el" href="#a4bd4f019dc18212bfcb33ccf2a486f65">DESCENDING</a> </li>
        </ul>

        <p>The default value is <a className="el" href="#a402903a2a6b1033fda983433504cf9bf">ASCENDING</a>.</p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/GetRecords.cs#L112">112</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/GetRecords.cs">GetRecords.cs</a>.</p>
      </div>
    </div>

    <div id="a509446a4d6cf928f879273b815e28f29" />

    <h2 className="memtitle"><span className="permalink"><a href="#a509446a4d6cf928f879273b815e28f29">◆ </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="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/GetRecords.cs#L81">81</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/GetRecords.cs">GetRecords.cs</a>.</p>
      </div>
    </div>

    <hr />

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

    <ul>
      <li>Kinetica/Protocol/<a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/GetRecords.cs">GetRecords.cs</a></li>
    </ul>
  </div>
</div>


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.