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

# createTriggerByRange

<div className="kinetica-doxygen">
  <div id="aa6cc5e9a5eb5f54fb39d95ed86139cf3" />

  <h2 className="memtitle"><span className="permalink"><a href="#aa6cc5e9a5eb5f54fb39d95ed86139cf3">◆ </a></span>createTriggerByRange() <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"><a className="el" href="/content/api/cs/classkinetica_1_1CreateTriggerByRangeResponse">CreateTriggerByRangeResponse</a> kinetica.Kinetica.createTriggerByRange </td>
                <td>(</td>
                <td className="paramtype"><a className="el" href="/content/api/cs/classkinetica_1_1CreateTriggerByRangeRequest">CreateTriggerByRangeRequest</a></td>
                <td className="paramname"><span className="paramname"><span className="em">request\_</span></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>Sets up a simple range trigger for a column\_name for one or more tables. </p>
      <p>Once the trigger has been activated, any record added to the listed tables(s) via <a className="el" href="">insertRecords</a> with the chosen column\_name's value falling within the specified range will trip the trigger. All such records will be queued at the trigger port (by default '9001' but able to be retrieved via <a className="el" href="#a5388cd1d43fea381c678c42773d1904d">showSystemStatus</a>) for any listening client to collect. Active triggers can be cancelled by using the <a className="el" href="#a25879715a3c5a7b18e6a5423b13b2d06">clearTrigger</a> endpoint or by clearing all relevant tables.</p>
      <p>The output returns the trigger handle as well as indicating success or failure of the trigger activation.</p>

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

        <div className="dd">
          <table className="params">
            <tr>
              <td className="paramname">request\_</td>
              <td>Request object containing the parameters for the operation.</td>
            </tr>
          </table>
        </div>
      </div>

      <div className="dl section return">
        <div className="dt">Returns</div>
        <div className="dd">Response object containing the result of the operation. </div>
      </div>

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

  <div id="af1e8dac7da666fbe3f7fbbccc77376b9" />

  <h2 className="memtitle"><span className="permalink"><a href="#af1e8dac7da666fbe3f7fbbccc77376b9">◆ </a></span>createTriggerByRange() <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"><a className="el" href="/content/api/cs/classkinetica_1_1CreateTriggerByRangeResponse">CreateTriggerByRangeResponse</a> kinetica.Kinetica.createTriggerByRange </td>
                <td>(</td>
                <td className="paramtype">string</td>
                <td className="paramname"><span className="paramname"><span className="em">request\_id</span></span>, </td>
              </tr>

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

                <td />

                <td className="paramtype">IList\< string ></td>
                <td className="paramname"><span className="paramname"><span className="em">table\_names</span></span>, </td>
              </tr>

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

                <td />

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

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

                <td />

                <td className="paramtype">double</td>
                <td className="paramname"><span className="paramname"><span className="em">min</span></span>, </td>
              </tr>

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

                <td />

                <td className="paramtype">double</td>
                <td className="paramname"><span className="paramname"><span className="em">max</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>Sets up a simple range trigger for a column\_name for one or more tables. </p>
      <p>Once the trigger has been activated, any record added to the listed tables(s) via <a className="el" href="">insertRecords</a> with the chosen column\_name's value falling within the specified range will trip the trigger. All such records will be queued at the trigger port (by default '9001' but able to be retrieved via <a className="el" href="#a5388cd1d43fea381c678c42773d1904d">showSystemStatus</a>) for any listening client to collect. Active triggers can be cancelled by using the <a className="el" href="#a25879715a3c5a7b18e6a5423b13b2d06">clearTrigger</a> endpoint or by clearing all relevant tables.</p>
      <p>The output returns the trigger handle as well as indicating success or failure of the trigger activation.</p>

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

        <div className="dd">
          <table className="params">
            <tr>
              <td className="paramname">request\_id</td>
              <td>User-created ID for the trigger. The ID can be alphanumeric, contain symbols, and must contain at least one character. </td>
            </tr>

            <tr>
              <td className="paramname">table\_names</td>
              <td>Tables on which the trigger will be active, each in \[schema\_name.]table\_name format, using standard <a href="/content/concepts/tables/#table-name-resolution" target="_top">name resolution rules</a>.</td>
            </tr>

            <tr>
              <td className="paramname">column\_name</td>
              <td>Name of a numeric column\_name on which the trigger is activated.</td>
            </tr>

            <tr>
              <td className="paramname">min</td>
              <td>The lower bound (inclusive) for the trigger range. </td>
            </tr>

            <tr>
              <td className="paramname">max</td>
              <td>The upper bound (inclusive) for the trigger range. </td>
            </tr>

            <tr>
              <td className="paramname">options</td>
              <td>Optional parameters. The default value is an empty Dictionary.</td>
            </tr>
          </table>
        </div>
      </div>

      <div className="dl section return">
        <div className="dt">Returns</div>
        <div className="dd">Response object containing the result of the operation. </div>
      </div>

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

  <div id="a0c245d21cb21909edeb84f5d024cd05c" />

  <h2 className="memtitle"><span className="permalink"><a href="#a0c245d21cb21909edeb84f5d024cd05c">◆ </a></span>CreateTriggerByRangeAsync() <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">async System.Threading.Tasks.Task\< <a className="el" href="/content/api/cs/classkinetica_1_1CreateTriggerByRangeResponse">CreateTriggerByRangeResponse</a> > kinetica.Kinetica.CreateTriggerByRangeAsync </td>
                <td>(</td>
                <td className="paramtype"><a className="el" href="/content/api/cs/classkinetica_1_1CreateTriggerByRangeRequest">CreateTriggerByRangeRequest</a></td>
                <td className="paramname"><span className="paramname"><span className="em">request\_</span></span>, </td>
              </tr>

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

                <td />

                <td className="paramtype">System.Threading.CancellationToken</td>
                <td className="paramname"><span className="paramname"><span className="em">cancellationToken</span></span><span className="paramdefsep"> = </span><span className="paramdefval">default</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>Sets up a simple range trigger for a column\_name for one or more tables. </p>
      <p>(async) </p>
      <p>Once the trigger has been activated, any record added to the listed tables(s) via <a className="el" href="">insertRecords</a> with the chosen column\_name's value falling within the specified range will trip the trigger. All such records will be queued at the trigger port (by default '9001' but able to be retrieved via <a className="el" href="#a5388cd1d43fea381c678c42773d1904d">showSystemStatus</a>) for any listening client to collect. Active triggers can be cancelled by using the <a className="el" href="#a25879715a3c5a7b18e6a5423b13b2d06">clearTrigger</a> endpoint or by clearing all relevant tables.</p>
      <p>The output returns the trigger handle as well as indicating success or failure of the trigger activation.</p>

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

        <div className="dd">
          <table className="params">
            <tr>
              <td className="paramname">request\_</td>
              <td>Request object containing the parameters for the operation.</td>
            </tr>

            <tr>
              <td className="paramname">cancellationToken</td>
              <td>Cancellation token to cancel the operation.</td>
            </tr>
          </table>
        </div>
      </div>

      <div className="dl section return">
        <div className="dt">Returns</div>
        <div className="dd">Task that returns the response object containing the result of the operation.</div>
      </div>

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

  <div id="afd0a825692d7ee62b789f814ac695fb0" />

  <h2 className="memtitle"><span className="permalink"><a href="#afd0a825692d7ee62b789f814ac695fb0">◆ </a></span>CreateTriggerByRangeAsync() <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">async System.Threading.Tasks.Task\< <a className="el" href="/content/api/cs/classkinetica_1_1CreateTriggerByRangeResponse">CreateTriggerByRangeResponse</a> > kinetica.Kinetica.CreateTriggerByRangeAsync </td>
                <td>(</td>
                <td className="paramtype">string</td>
                <td className="paramname"><span className="paramname"><span className="em">request\_id</span></span>, </td>
              </tr>

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

                <td />

                <td className="paramtype">IList\< string ></td>
                <td className="paramname"><span className="paramname"><span className="em">table\_names</span></span>, </td>
              </tr>

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

                <td />

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

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

                <td />

                <td className="paramtype">double</td>
                <td className="paramname"><span className="paramname"><span className="em">min</span></span>, </td>
              </tr>

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

                <td />

                <td className="paramtype">double</td>
                <td className="paramname"><span className="paramname"><span className="em">max</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>

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

                <td />

                <td className="paramtype">System.Threading.CancellationToken</td>
                <td className="paramname"><span className="paramname"><span className="em">cancellationToken</span></span><span className="paramdefsep"> = </span><span className="paramdefval">default</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>Sets up a simple range trigger for a column\_name for one or more tables. </p>
      <p>(async) </p>
      <p>Once the trigger has been activated, any record added to the listed tables(s) via <a className="el" href="">insertRecords</a> with the chosen column\_name's value falling within the specified range will trip the trigger. All such records will be queued at the trigger port (by default '9001' but able to be retrieved via <a className="el" href="#a5388cd1d43fea381c678c42773d1904d">showSystemStatus</a>) for any listening client to collect. Active triggers can be cancelled by using the <a className="el" href="#a25879715a3c5a7b18e6a5423b13b2d06">clearTrigger</a> endpoint or by clearing all relevant tables.</p>
      <p>The output returns the trigger handle as well as indicating success or failure of the trigger activation.</p>

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

        <div className="dd">
          <table className="params">
            <tr>
              <td className="paramname">request\_id</td>
              <td>User-created ID for the trigger. The ID can be alphanumeric, contain symbols, and must contain at least one character. </td>
            </tr>

            <tr>
              <td className="paramname">table\_names</td>
              <td>Tables on which the trigger will be active, each in \[schema\_name.]table\_name format, using standard <a href="/content/concepts/tables/#table-name-resolution" target="_top">name resolution rules</a>.</td>
            </tr>

            <tr>
              <td className="paramname">column\_name</td>
              <td>Name of a numeric column\_name on which the trigger is activated.</td>
            </tr>

            <tr>
              <td className="paramname">min</td>
              <td>The lower bound (inclusive) for the trigger range. </td>
            </tr>

            <tr>
              <td className="paramname">max</td>
              <td>The upper bound (inclusive) for the trigger range. </td>
            </tr>

            <tr>
              <td className="paramname">options</td>
              <td>Optional parameters. The default value is an empty Dictionary.</td>
            </tr>

            <tr>
              <td className="paramname">cancellationToken</td>
              <td>Cancellation token to cancel the operation.</td>
            </tr>
          </table>
        </div>
      </div>

      <div className="dl section return">
        <div className="dt">Returns</div>
        <div className="dd">Task that returns the response object containing the result of the operation.</div>
      </div>

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