This action executes a query against the input tables and produces as output the rows and columns of the original that match the query. The advantage to using this action is it can work on the data without making an extra temporary table. However, the syntax used for this action is different than the other actions, and it is very difficult to do any aggregate functions or grouping.

  • 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, so 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 ${table} token to represent the input table.

    Example: select * from ${table} where code = 02 and value like %per%

    Tip: To learn the SQL syntax used by this action, see http://josql.sf.net