> ## 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.FilterByListRequest

> kinetica.FilterByListRequest — Kinetica C# API

<div className="kinetica-doxygen">
  <div className="contents">
    <p>A set of parameters for <a className="el" href="/content/api/cs/classkinetica_1_1Kinetica/filterbylist#ac7cae8ee0faadb97af0a052b2c0bbe44">Kinetica.filterByList</a>. <a href="#details">More...</a></p>

    <table className="memberdecls">
      <tr className="heading">
        <td colSpan="2">
          <h2 className="groupheader">
            <div id="nested-classes" />

            Classes
          </h2>
        </td>
      </tr>

      <tr className="memitem:">
        <td className="memItemLeft" align="right" valign="top">struct  </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="/content/api/cs/structkinetica_1_1FilterByListRequest_1_1Options">Options</a></td>
      </tr>

      <tr className="memdesc:">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">A set of string constants for the parameter <a className="el" href="#ae5909c3c890b1e737ccbbdd283a7b6d9" title="Optional parameters.">FilterByListRequest.options</a>. <a href="/content/api/cs/structkinetica_1_1FilterByListRequest_1_1Options#details">More...</a><br /></td>
      </tr>

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

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

            Public Member Functions
          </h2>
        </td>
      </tr>

      <tr className="memitem:a38a91ff0a6bc2d42f769ef8c2dfb66f4" id="r_a38a91ff0a6bc2d42f769ef8c2dfb66f4">
        <td className="memItemLeft" align="right" valign="top"> </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a38a91ff0a6bc2d42f769ef8c2dfb66f4">FilterByListRequest</a> ()</td>
      </tr>

      <tr className="memdesc:a38a91ff0a6bc2d42f769ef8c2dfb66f4">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Constructs a <a className="el" href="/content/api/cs/classkinetica_1_1FilterByListRequest" title="A set of parameters for Kinetica.filterByList.">FilterByListRequest</a> object with default parameters. <br /></td>
      </tr>

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

      <tr className="memitem:a7a4ac654a1d345b57130419b083c1b58" id="r_a7a4ac654a1d345b57130419b083c1b58">
        <td className="memItemLeft" align="right" valign="top"> </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a7a4ac654a1d345b57130419b083c1b58">FilterByListRequest</a> (string <a className="el" href="#a9f79829faa74f8636ed6f952fc2e9460">table\_name</a>, string <a className="el" href="#abdd7a07474b7f9dc969fa4a72b8d4eb8">view\_name</a>, IDictionary\< string, IList\< string > > <a className="el" href="#a2457f7a591d1adc8473c9a9b6ff97ffc">column\_values\_map</a>, IDictionary\< string, string > <a className="el" href="#ae5909c3c890b1e737ccbbdd283a7b6d9">options</a>=null)</td>
      </tr>

      <tr className="memdesc:a7a4ac654a1d345b57130419b083c1b58">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Constructs a <a className="el" href="/content/api/cs/classkinetica_1_1FilterByListRequest" title="A set of parameters for Kinetica.filterByList.">FilterByListRequest</a> object with the specified parameters. <br /></td>
      </tr>

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

      <tr className="inherit_header pub_methods_classkinetica_1_1KineticaData">
        <td colSpan="2"> Public Member Functions inherited from <a className="el" href="/content/api/cs/classkinetica_1_1KineticaData">kinetica.KineticaData</a></td>
      </tr>

      <tr className="memitem:a6a494237f126f79a7f478b7614323482 inherit pub_methods_classkinetica_1_1KineticaData" id="r_a6a494237f126f79a7f478b7614323482">
        <td className="memItemLeft" align="right" valign="top"> </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="/content/api/cs/classkinetica_1_1KineticaData#a6a494237f126f79a7f478b7614323482">KineticaData</a> (<a className="el" href="/content/api/cs/classkinetica_1_1KineticaType">KineticaType</a> type)</td>
      </tr>

      <tr className="memdesc:a6a494237f126f79a7f478b7614323482 inherit pub_methods_classkinetica_1_1KineticaData">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Constructor from <a className="el" href="/content/api/cs/classkinetica_1_1Kinetica" title="API to talk to Kinetica Database.">Kinetica</a> Type. <br /></td>
      </tr>

      <tr className="separator:a6a494237f126f79a7f478b7614323482 inherit pub_methods_classkinetica_1_1KineticaData">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:ac8cbdce08f2dd7d0d02bf0f279d79b79 inherit pub_methods_classkinetica_1_1KineticaData" id="r_ac8cbdce08f2dd7d0d02bf0f279d79b79">
        <td className="memItemLeft" align="right" valign="top"> </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="/content/api/cs/classkinetica_1_1KineticaData#ac8cbdce08f2dd7d0d02bf0f279d79b79">KineticaData</a> (System.Type type=null)</td>
      </tr>

      <tr className="memdesc:ac8cbdce08f2dd7d0d02bf0f279d79b79 inherit pub_methods_classkinetica_1_1KineticaData">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Default constructor, with optional System.Type. <br /></td>
      </tr>

      <tr className="separator:ac8cbdce08f2dd7d0d02bf0f279d79b79 inherit pub_methods_classkinetica_1_1KineticaData">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:a8fceb0fc6b641ef28b7548bc2820e48f inherit pub_methods_classkinetica_1_1KineticaData" id="r_a8fceb0fc6b641ef28b7548bc2820e48f">
        <td className="memItemLeft" align="right" valign="top">object </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="/content/api/cs/classkinetica_1_1KineticaData#a8fceb0fc6b641ef28b7548bc2820e48f">Get</a> (int fieldPos)</td>
      </tr>

      <tr className="memdesc:a8fceb0fc6b641ef28b7548bc2820e48f inherit pub_methods_classkinetica_1_1KineticaData">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Retrieve a specific property from this object. <br /></td>
      </tr>

      <tr className="separator:a8fceb0fc6b641ef28b7548bc2820e48f inherit pub_methods_classkinetica_1_1KineticaData">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:ad02b0bac0aa3f8a64b0ec46a94bd06f0 inherit pub_methods_classkinetica_1_1KineticaData" id="r_ad02b0bac0aa3f8a64b0ec46a94bd06f0">
        <td className="memItemLeft" align="right" valign="top">void </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="/content/api/cs/classkinetica_1_1KineticaData#ad02b0bac0aa3f8a64b0ec46a94bd06f0">Put</a> (int fieldPos, object fieldValue)</td>
      </tr>

      <tr className="memdesc:ad02b0bac0aa3f8a64b0ec46a94bd06f0 inherit pub_methods_classkinetica_1_1KineticaData">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Write a specific property to this object. <br /></td>
      </tr>

      <tr className="separator:ad02b0bac0aa3f8a64b0ec46a94bd06f0 inherit pub_methods_classkinetica_1_1KineticaData">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>
    </table>

    <table className="memberdecls">
      <tr className="heading">
        <td colSpan="2">
          <h2 className="groupheader">
            <div id="properties" />

            Properties
          </h2>
        </td>
      </tr>

      <tr className="memitem:a9f79829faa74f8636ed6f952fc2e9460" id="r_a9f79829faa74f8636ed6f952fc2e9460">
        <td className="memItemLeft" align="right" valign="top">string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a9f79829faa74f8636ed6f952fc2e9460">table\_name</a><code> \[get, set]</code></td>
      </tr>

      <tr className="memdesc:a9f79829faa74f8636ed6f952fc2e9460">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Name of the table to filter, in \[schema\_name. <br /></td>
      </tr>

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

      <tr className="memitem:abdd7a07474b7f9dc969fa4a72b8d4eb8" id="r_abdd7a07474b7f9dc969fa4a72b8d4eb8">
        <td className="memItemLeft" align="right" valign="top">string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#abdd7a07474b7f9dc969fa4a72b8d4eb8">view\_name</a> = ""<code> \[get, set]</code></td>
      </tr>

      <tr className="memdesc:abdd7a07474b7f9dc969fa4a72b8d4eb8">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">If provided, then this will be the name of the view containing the results, in \[schema\_name. <br /></td>
      </tr>

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

      <tr className="memitem:a2457f7a591d1adc8473c9a9b6ff97ffc" id="r_a2457f7a591d1adc8473c9a9b6ff97ffc">
        <td className="memItemLeft" align="right" valign="top">IDictionary\< string, IList\< string > > </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a2457f7a591d1adc8473c9a9b6ff97ffc">column\_values\_map</a> = new Dictionary\<string, IList\<string>>()<code> \[get, set]</code></td>
      </tr>

      <tr className="memdesc:a2457f7a591d1adc8473c9a9b6ff97ffc">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">List of values for the corresponding column in the table. <br /></td>
      </tr>

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

      <tr className="memitem:ae5909c3c890b1e737ccbbdd283a7b6d9" id="r_ae5909c3c890b1e737ccbbdd283a7b6d9">
        <td className="memItemLeft" align="right" valign="top">IDictionary\< string, string > </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#ae5909c3c890b1e737ccbbdd283a7b6d9">options</a> = new Dictionary\<string, string>()<code> \[get, set]</code></td>
      </tr>

      <tr className="memdesc:ae5909c3c890b1e737ccbbdd283a7b6d9">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Optional parameters. <br /></td>
      </tr>

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

      <tr className="inherit_header properties_classkinetica_1_1KineticaData">
        <td colSpan="2"> Properties inherited from <a className="el" href="/content/api/cs/classkinetica_1_1KineticaData">kinetica.KineticaData</a></td>
      </tr>

      <tr className="memitem:ae35f20177341ed020cb1c92195621499 inherit properties_classkinetica_1_1KineticaData" id="r_ae35f20177341ed020cb1c92195621499">
        <td className="memItemLeft" align="right" valign="top">Schema </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="/content/api/cs/classkinetica_1_1KineticaData#ae35f20177341ed020cb1c92195621499">Schema</a><code> \[get]</code></td>
      </tr>

      <tr className="memdesc:ae35f20177341ed020cb1c92195621499 inherit properties_classkinetica_1_1KineticaData">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Avro Schema for this class. <br /></td>
      </tr>

      <tr className="separator:ae35f20177341ed020cb1c92195621499 inherit properties_classkinetica_1_1KineticaData">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>
    </table>

    <table className="memberdecls">
      <tr className="heading">
        <td colSpan="2">
          <h2 className="groupheader">
            <div id="inherited" />

            Additional Inherited Members
          </h2>
        </td>
      </tr>

      <tr className="inherit_header pub_static_methods_classkinetica_1_1KineticaData">
        <td colSpan="2"> Static Public Member Functions inherited from <a className="el" href="/content/api/cs/classkinetica_1_1KineticaData">kinetica.KineticaData</a></td>
      </tr>

      <tr className="memitem:a9474d49c9399dbe86f31a3ba07ff4691 inherit pub_static_methods_classkinetica_1_1KineticaData" id="r_a9474d49c9399dbe86f31a3ba07ff4691">
        <td className="memItemLeft" align="right" valign="top">static ? RecordSchema </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="/content/api/cs/classkinetica_1_1KineticaData#a9474d49c9399dbe86f31a3ba07ff4691">SchemaFromType</a> (System.Type t, <a className="el" href="/content/api/cs/classkinetica_1_1KineticaType">KineticaType</a>? ktype=null)</td>
      </tr>

      <tr className="memdesc:a9474d49c9399dbe86f31a3ba07ff4691 inherit pub_static_methods_classkinetica_1_1KineticaData">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Create an Avro Schema from a System.Type and a <a className="el" href="/content/api/cs/classkinetica_1_1KineticaType" title="Describes a Kinetica record type — its columns, properties, and Avro schema — and can create the type...">KineticaType</a>. <br /></td>
      </tr>

      <tr className="separator:a9474d49c9399dbe86f31a3ba07ff4691 inherit pub_static_methods_classkinetica_1_1KineticaData">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>
    </table>

    <div id="details" />

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

    <div className="textblock">
      <p>A set of parameters for <a className="el" href="/content/api/cs/classkinetica_1_1Kinetica/filterbylist#ac7cae8ee0faadb97af0a052b2c0bbe44">Kinetica.filterByList</a>. </p>
      <p>Calculates which records from a table have values in the given list for the corresponding column. The operation is synchronous, meaning that a response will not be returned until all the objects are fully available. The response payload provides the count of the resulting set. A new resultant set (view) which satisfies the input filter specification is also created if a <a className="el" href="#abdd7a07474b7f9dc969fa4a72b8d4eb8" title="If provided, then this will be the name of the view containing the results, in [schema_name.">FilterByListRequest.view\_name</a> is passed in as part of the request.</p>
      <p>For example, if a type definition has the columns 'x' and 'y', then a filter by list query with the column map {"{"}"x":\["10.1", "2.3"], "y":\["0.0", "-31.5", "42.0"]{"}"} will return the count of all data points whose x and y values match both in the respective x- and y-lists, e.g., "x = 10.1 and y = 0.0", "x = 2.3 and y = -31.5", etc. However, a record with "x = 10.1 and y = -31.5" or "x = 2.3 and y = 0.0" would not be returned because the values in the given lists do not correspond.</p>
      <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/FilterByList.cs#L29">29</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/FilterByList.cs">FilterByList.cs</a>.</p>
    </div>

    <h2 className="groupheader">Constructor & Destructor Documentation</h2>

    <div id="a38a91ff0a6bc2d42f769ef8c2dfb66f4" />

    <h2 className="memtitle"><span className="permalink"><a href="#a38a91ff0a6bc2d42f769ef8c2dfb66f4">◆ </a></span>FilterByListRequest() <span className="overload">\[1/2]</span></h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">kinetica.FilterByListRequest.FilterByListRequest </td>
                  <td>(</td>

                  <td className="paramname">
                    <span className="paramname">
                      <span className="em" />
                    </span>
                  </td>

                  <td>)</td>

                  <td />
                </tr>
              </table>
            </td>

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

      <div className="memdoc">
        <p>Constructs a <a className="el" href="/content/api/cs/classkinetica_1_1FilterByListRequest" title="A set of parameters for Kinetica.filterByList.">FilterByListRequest</a> object with default parameters. </p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/FilterByList.cs#L210">210</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/FilterByList.cs">FilterByList.cs</a>.</p>
      </div>
    </div>

    <div id="a7a4ac654a1d345b57130419b083c1b58" />

    <h2 className="memtitle"><span className="permalink"><a href="#a7a4ac654a1d345b57130419b083c1b58">◆ </a></span>FilterByListRequest() <span className="overload">\[2/2]</span></h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">kinetica.FilterByListRequest.FilterByListRequest </td>
                  <td>(</td>
                  <td className="paramtype">string</td>
                  <td className="paramname"><span className="paramname"><span className="em">table\_name</span></span>, </td>
                </tr>

                <tr>
                  <td className="paramkey" />

                  <td />

                  <td className="paramtype">string</td>
                  <td className="paramname"><span className="paramname"><span className="em">view\_name</span></span>, </td>
                </tr>

                <tr>
                  <td className="paramkey" />

                  <td />

                  <td className="paramtype">IDictionary\< string, IList\< string > ></td>
                  <td className="paramname"><span className="paramname"><span className="em">column\_values\_map</span></span>, </td>
                </tr>

                <tr>
                  <td className="paramkey" />

                  <td />

                  <td className="paramtype">IDictionary\< string, string ></td>
                  <td className="paramname"><span className="paramname"><span className="em">options</span></span><span className="paramdefsep"> = </span><span className="paramdefval">null</span> )</td>
                </tr>
              </table>
            </td>

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

      <div className="memdoc">
        <p>Constructs a <a className="el" href="/content/api/cs/classkinetica_1_1FilterByListRequest" title="A set of parameters for Kinetica.filterByList.">FilterByListRequest</a> object with the specified parameters. </p>

        <div className="dl params">
          <div className="dt">Parameters</div>

          <div className="dd">
            <table className="params">
              <tr>
                <td className="paramname">table\_name</td>
                <td>Name of the table to filter, in \[schema\_name.]table\_name format, using standard <a href="/content/concepts/tables/#table-name-resolution" target="_top">name resolution rules</a>. This may be the name of a table or a view (when chaining queries).</td>
              </tr>

              <tr>
                <td className="paramname">view\_name</td>
                <td>If provided, then this will be the name of the view containing the results, in \[schema\_name.]view\_name format, using standard <a href="/content/concepts/tables/#table-name-resolution" target="_top">name resolution rules</a> and meeting <a href="/content/concepts/tables/#table-naming-criteria" target="_top">table naming criteria</a>. Must not be an already existing table or view. The default value is ''.</td>
              </tr>

              <tr>
                <td className="paramname">column\_values\_map</td>
                <td>List of values for the corresponding column in the table.</td>
              </tr>

              <tr>
                <td className="paramname">options</td>

                <td>
                  Optional parameters.

                  <ul>
                    <li>
                      <a className="el" href="/content/api/cs/structkinetica_1_1FilterByListRequest_1_1Options#afbc751f89f8b6e46f25b4b748a8891e3">CREATE\_TEMP\_TABLE</a>: If <a className="el" href="/content/api/cs/structkinetica_1_1FilterByListRequest_1_1Options#ac268d723cbfcd057e255127f797553ae">TRUE</a>, a unique temporary table name will be generated in the sys\_temp schema and used in place of <span className="em">view\_name</span> . This is always allowed even if the caller does not have permission to create tables. The generated name is returned in <a className="el" href="/content/api/cs/structkinetica_1_1FilterByListResponse_1_1Info#a2722a55d7a147988de926e4dc47c581b">QUALIFIED\_VIEW\_NAME</a>. Supported values:

                      <ul>
                        <li> <a className="el" href="/content/api/cs/structkinetica_1_1FilterByListRequest_1_1Options#ac268d723cbfcd057e255127f797553ae">TRUE</a> </li>
                        <li> <a className="el" href="/content/api/cs/structkinetica_1_1FilterByListRequest_1_1Options#acd8171e9fa5a1ded4a21625b6b94e7f8">FALSE</a> </li>
                      </ul>

                      The default value is <a className="el" href="/content/api/cs/structkinetica_1_1FilterByListRequest_1_1Options#acd8171e9fa5a1ded4a21625b6b94e7f8">FALSE</a>.
                    </li>

                    <li> <a className="el" href="/content/api/cs/structkinetica_1_1FilterByListRequest_1_1Options#a53708df0a56237ea7fcefc941a475342">COLLECTION\_NAME</a>: \[DEPRECATED–please specify the containing schema for the view as part of <span className="em">view\_name</span> and use <a className="el" href="/content/api/cs/classkinetica_1_1Kinetica/createschema#ac754b44062e7b90b8afa50ddfa8ccbf2">Kinetica.createSchema</a> to create the schema if non-existent] Name of a schema for the newly created view. If the schema provided is non-existent, it will be automatically created. </li>

                    <li>
                      <a className="el" href="/content/api/cs/structkinetica_1_1FilterByListRequest_1_1Options#a1b7b977aaa2c6d2714beebe792cba5d0">FILTER\_MODE</a>: String indicating the filter mode, either 'in\_list' or 'not\_in\_list'. Supported values:

                      <ul>
                        <li> <a className="el" href="/content/api/cs/structkinetica_1_1FilterByListRequest_1_1Options#a96db399c9998f1f84d4aec8d3a978dfb">IN\_LIST</a>: The filter will match all items that are in the provided list(s). </li>
                        <li> <a className="el" href="/content/api/cs/structkinetica_1_1FilterByListRequest_1_1Options#af0198ae6fd8cae851276dab9e69051dd">NOT\_IN\_LIST</a>: The filter will match all items that are not in the provided list(s). </li>
                      </ul>

                      The default value is <a className="el" href="/content/api/cs/structkinetica_1_1FilterByListRequest_1_1Options#a96db399c9998f1f84d4aec8d3a978dfb">IN\_LIST</a>.
                    </li>
                  </ul>

                  The default value is an empty Dictionary.
                </td>
              </tr>
            </table>
          </div>
        </div>

        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/FilterByList.cs#L300">300</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/FilterByList.cs">FilterByList.cs</a>.</p>
      </div>
    </div>

    <h2 className="groupheader">Property Documentation</h2>

    <div id="a2457f7a591d1adc8473c9a9b6ff97ffc" />

    <h2 className="memtitle"><span className="permalink"><a href="#a2457f7a591d1adc8473c9a9b6ff97ffc">◆ </a></span>column\_values\_map</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">IDictionary\<string, IList\<string> > kinetica.FilterByListRequest.column\_values\_map = new Dictionary\<string, IList\<string>>()</td>
                </tr>
              </table>
            </td>

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

      <div className="memdoc">
        <p>List of values for the corresponding column in the table. </p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/FilterByList.cs#L132">132</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/FilterByList.cs">FilterByList.cs</a>.</p>
      </div>
    </div>

    <div id="ae5909c3c890b1e737ccbbdd283a7b6d9" />

    <h2 className="memtitle"><span className="permalink"><a href="#ae5909c3c890b1e737ccbbdd283a7b6d9">◆ </a></span>options</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">IDictionary\<string, string> kinetica.FilterByListRequest.options = new Dictionary\<string, string>()</td>
                </tr>
              </table>
            </td>

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

      <div className="memdoc">
        <p>Optional parameters. </p>

        <ul>
          <li>
            <a className="el" href="/content/api/cs/structkinetica_1_1FilterByListRequest_1_1Options#afbc751f89f8b6e46f25b4b748a8891e3">CREATE\_TEMP\_TABLE</a>: If <a className="el" href="/content/api/cs/structkinetica_1_1FilterByListRequest_1_1Options#ac268d723cbfcd057e255127f797553ae">TRUE</a>, a unique temporary table name will be generated in the sys\_temp schema and used in place of <a className="el" href="#abdd7a07474b7f9dc969fa4a72b8d4eb8" title="If provided, then this will be the name of the view containing the results, in [schema_name.">FilterByListRequest.view\_name</a>. This is always allowed even if the caller does not have permission to create tables. The generated name is returned in <a className="el" href="/content/api/cs/structkinetica_1_1FilterByListResponse_1_1Info#a2722a55d7a147988de926e4dc47c581b">QUALIFIED\_VIEW\_NAME</a>. Supported values:

            <ul>
              <li> <a className="el" href="/content/api/cs/structkinetica_1_1FilterByListRequest_1_1Options#ac268d723cbfcd057e255127f797553ae">TRUE</a> </li>
              <li> <a className="el" href="/content/api/cs/structkinetica_1_1FilterByListRequest_1_1Options#acd8171e9fa5a1ded4a21625b6b94e7f8">FALSE</a> </li>
            </ul>

            The default value is <a className="el" href="/content/api/cs/structkinetica_1_1FilterByListRequest_1_1Options#acd8171e9fa5a1ded4a21625b6b94e7f8">FALSE</a>.
          </li>

          <li> <a className="el" href="/content/api/cs/structkinetica_1_1FilterByListRequest_1_1Options#a53708df0a56237ea7fcefc941a475342">COLLECTION\_NAME</a>: \[DEPRECATED–please specify the containing schema for the view as part of <a className="el" href="#abdd7a07474b7f9dc969fa4a72b8d4eb8" title="If provided, then this will be the name of the view containing the results, in [schema_name.">FilterByListRequest.view\_name</a> and use <a className="el" href="/content/api/cs/classkinetica_1_1Kinetica/createschema#ac754b44062e7b90b8afa50ddfa8ccbf2">Kinetica.createSchema</a> to create the schema if non-existent] Name of a schema for the newly created view. If the schema provided is non-existent, it will be automatically created. </li>

          <li>
            <a className="el" href="/content/api/cs/structkinetica_1_1FilterByListRequest_1_1Options#a1b7b977aaa2c6d2714beebe792cba5d0">FILTER\_MODE</a>: String indicating the filter mode, either 'in\_list' or 'not\_in\_list'. Supported values:

            <ul>
              <li> <a className="el" href="/content/api/cs/structkinetica_1_1FilterByListRequest_1_1Options#a96db399c9998f1f84d4aec8d3a978dfb">IN\_LIST</a>: The filter will match all items that are in the provided list(s). </li>
              <li> <a className="el" href="/content/api/cs/structkinetica_1_1FilterByListRequest_1_1Options#af0198ae6fd8cae851276dab9e69051dd">NOT\_IN\_LIST</a>: The filter will match all items that are not in the provided list(s). </li>
            </ul>

            The default value is <a className="el" href="/content/api/cs/structkinetica_1_1FilterByListRequest_1_1Options#a96db399c9998f1f84d4aec8d3a978dfb">IN\_LIST</a>.
          </li>
        </ul>

        <p>The default value is an empty Dictionary.</p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/FilterByList.cs#L206">206</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/FilterByList.cs">FilterByList.cs</a>.</p>
      </div>
    </div>

    <div id="a9f79829faa74f8636ed6f952fc2e9460" />

    <h2 className="memtitle"><span className="permalink"><a href="#a9f79829faa74f8636ed6f952fc2e9460">◆ </a></span>table\_name</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">string kinetica.FilterByListRequest.table\_name</td>
                </tr>
              </table>
            </td>

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

      <div className="memdoc">
        <p>Name of the table to filter, in \[schema\_name. </p>
        <p>]table\_name format, using standard <a href="/content/concepts/tables/#table-name-resolution" target="_top">name resolution rules</a>. </p>
        <p>This may be the name of a table or a view (when chaining queries).</p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/FilterByList.cs#L118">118</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/FilterByList.cs">FilterByList.cs</a>.</p>
      </div>
    </div>

    <div id="abdd7a07474b7f9dc969fa4a72b8d4eb8" />

    <h2 className="memtitle"><span className="permalink"><a href="#abdd7a07474b7f9dc969fa4a72b8d4eb8">◆ </a></span>view\_name</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">string kinetica.FilterByListRequest.view\_name = ""</td>
                </tr>
              </table>
            </td>

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

      <div className="memdoc">
        <p>If provided, then this will be the name of the view containing the results, in \[schema\_name. </p>
        <p>]view\_name format, using standard <a href="/content/concepts/tables/#table-name-resolution" target="_top">name resolution rules</a> and meeting <a href="/content/concepts/tables/#table-naming-criteria" target="_top">table naming criteria</a>. </p>
        <p>Must not be an already existing table or view. The default value is ''.</p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/FilterByList.cs#L128">128</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/FilterByList.cs">FilterByList.cs</a>.</p>
      </div>
    </div>

    <hr />

    The documentation for this class 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/FilterByList.cs">FilterByList.cs</a></li>
    </ul>
  </div>
</div>


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