> ## 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-javadoc">
  <ul className="member-list">
    <li>
      <div className="section detail" id="createTriggerByRange(com.gpudb.protocol.CreateTriggerByRangeRequest)">
        <h3>createTriggerByRange</h3>
        <div className="member-signature"><span className="modifiers">public</span> <span className="return-type"><a href="/content/api/java/com/gpudb/protocol/CreateTriggerByRangeResponse" title="class in com.gpudb.protocol">CreateTriggerByRangeResponse</a></span> <span className="element-name">createTriggerByRange</span><wbr /><span className="parameters">(<a href="/content/api/java/com/gpudb/protocol/CreateTriggerByRangeRequest" title="class in com.gpudb.protocol">CreateTriggerByRangeRequest</a> request)</span> throws <span className="exceptions"><a href="/content/api/java/com/gpudb/GPUdbException" title="class in com.gpudb">GPUdbException</a></span></div>

        <div className="block">
          Sets up a simple range trigger for a column\_name for one or more tables. Once the trigger has been activated, any record added to the listed tables(s) via <a href="#insertRecords(com.gpudb.protocol.InsertRecordsRequest)"><code>insertRecords</code></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 href="#showSystemStatus(com.gpudb.protocol.ShowSystemStatusRequest)"><code>showSystemStatus</code></a>) for any listening client to collect. Active triggers can be cancelled by using the <a href="#clearTrigger(com.gpudb.protocol.ClearTriggerRequest)"><code>clearTrigger</code></a> endpoint or by clearing all relevant tables.
          <p> The output returns the trigger handle as well as indicating success or failure of the trigger activation.</p>
        </div>

        <div className="dl notes">
          <div className="dt">Parameters:</div>
          <div className="dd"><code>request</code> - <a href="/content/api/java/com/gpudb/protocol/CreateTriggerByRangeRequest" title="class in com.gpudb.protocol"><code>Request</code></a> object containing the parameters for the operation.</div>
          <div className="dt">Returns:</div>
          <div className="dd"><a href="/content/api/java/com/gpudb/protocol/CreateTriggerByRangeResponse" title="class in com.gpudb.protocol"><code>Response</code></a> object containing the results of the operation.</div>
          <div className="dt">Throws:</div>
          <div className="dd"><code><a href="/content/api/java/com/gpudb/GPUdbException" title="class in com.gpudb">GPUdbException</a></code> - if an error occurs during the operation.</div>
        </div>
      </div>
    </li>

    <li>
      <div className="section detail" id="createTriggerByRange(java.lang.String,java.util.List,java.lang.String,double,double,java.util.Map)">
        <h3>createTriggerByRange</h3>
        <div className="member-signature"><span className="modifiers">public</span> <span className="return-type"><a href="/content/api/java/com/gpudb/protocol/CreateTriggerByRangeResponse" title="class in com.gpudb.protocol">CreateTriggerByRangeResponse</a></span> <span className="element-name">createTriggerByRange</span><wbr /><span className="parameters">(<a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a> requestId, <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/util/List.html" title="class or interface in java.util" className="external-link">List</a>\<<a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a>> tableNames, <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a> columnName, double min, double max, <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/util/Map.html" title="class or interface in java.util" className="external-link">Map</a>\<<a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a>,<wbr /><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a>> options)</span> throws <span className="exceptions"><a href="/content/api/java/com/gpudb/GPUdbException" title="class in com.gpudb">GPUdbException</a></span></div>

        <div className="block">
          Sets up a simple range trigger for a column\_name for one or more tables. Once the trigger has been activated, any record added to the listed tables(s) via <a href="#insertRecords(java.lang.String,java.util.List,java.util.Map)"><code>insertRecords</code></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 href="#showSystemStatus(java.util.Map)"><code>showSystemStatus</code></a>) for any listening client to collect. Active triggers can be cancelled by using the <a href="#clearTrigger(java.lang.String,java.util.Map)"><code>clearTrigger</code></a> endpoint or by clearing all relevant tables.
          <p> The output returns the trigger handle as well as indicating success or failure of the trigger activation.</p>
        </div>

        <div className="dl notes">
          <div className="dt">Parameters:</div>
          <div className="dd"><code>requestId</code> - User-created ID for the trigger. The ID can be alphanumeric, contain symbols, and must contain at least one character.</div>
          <div className="dd"><code>tableNames</code> - 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>.</div>
          <div className="dd"><code>columnName</code> - Name of a numeric column\_name on which the trigger is activated.</div>
          <div className="dd"><code>min</code> - The lower bound (inclusive) for the trigger range.</div>
          <div className="dd"><code>max</code> - The upper bound (inclusive) for the trigger range.</div>
          <div className="dd"><code>options</code> - Optional parameters. The default value is an empty <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/util/Map.html" title="class or interface in java.util" className="external-link"><code>Map</code></a>.</div>
          <div className="dt">Returns:</div>
          <div className="dd"><a href="/content/api/java/com/gpudb/protocol/CreateTriggerByRangeResponse" title="class in com.gpudb.protocol"><code>Response</code></a> object containing the results of the operation.</div>
          <div className="dt">Throws:</div>
          <div className="dd"><code><a href="/content/api/java/com/gpudb/GPUdbException" title="class in com.gpudb">GPUdbException</a></code> - if an error occurs during the operation.</div>
        </div>
      </div>
    </li>
  </ul>
</div>