Query Tables HSQL

This action executes a query against the input table and produces the matching rows and columns of the original table as the output.
This action works well for filtering rows. The inputs are queries by select from t1, t2, etc. This action uses more standard SQL syntax but requires more memory and a little more time to create a temporary table.

Caution

This action is not memory efficient because it makes a copy of the data, and the database is written in Java. This action uses twice the memory of unioning the tables.

  • Field

    Description
  • Label

    A label to identify the action. This label appears under the Action name inside the Action box. If this field is left blank, the default value is “Untitled.”
  • Description

    A brief explanation of what this action does inside the sequence. This description appears as a tooltip when your cursor hovers over the Action box.
  • Fail Message

    A message that identifies potential issues that could happen with this action. This fail message will appear if the action fails when you try generating the sequence. If this field is left blank, the default error message built into the action appears.
  • Key Multiple

    This allows for the processing of multiple keys at the same time. You will need to construct your query such that it will handle multiple key values.

    Example: where a ${key:=} will automatically use an “in” clause to handle multiple keys. Specifying a value of 1 will execute the query for each key.

  • Query
    The query should run against the input table. Use the t1 .. tn to represent the input tables.

    Example: select * from t1 where code = 02 and value like %per%

    Tip: To learn the SQL syntax used by this action, see http://hsqldb.org

  • Pattern
    The pattern to search for in the column. Values that match this pattern will be included or excluded from the result based on the state of the Include check box.