Manage query templates

  1. In the navigation pane, select Integration Designer > Manage Templates.
  2. Specify this information:
    Task type
    Select Query as the task type.
    Templates
    Select a template from the list.
    • To copy the selected template, click Copy and specify a template name.
    • To delete the selected template, click Delete.
    • To create a new template, click New and specify a template name.
    Resource type
    Select any of these resource types from the list:
    • Entity

      This resource type performs query tasks from a database.

    • M3WS

      This resource type performs a query tasks from M3 Web Service.

    Multiple results
    Select to enable your query to return multiple records.
    Is Polling
    Select to enable polling support. If selected, the query continually performs the task until specified conditions occur.
    Polling Timeout
    Specify a polling timeout in milliseconds. The default timeout is 60000 milliseconds.
    Polling Interval
    Specify the polling interval in milliseconds. The default interval, if not specified, is 5000 milliseconds.

    Polling Interval will allow the system to poll the record for a certain interval before requesting it again, rather than a successive request of polls which affects the performance.

  3. Based on the selected resource type, specify this information:
    • Entity resource type:
      Entity Alias
      Select an entity alias from the list.

      You can add entity aliases in the Database Entities module.

      See Identifying supported database tables.

      Note: Entity aliases depend on the selected connection string.
      Entity
      Select an entity from the list.
      Note: The list of entities are based on the specified connection string and entity alias.
    • M3WS resource type:
      Program
      Select a program from the list.
      Note: The list contains the available and supported MI programs. To add an MI program, specify an MI program name and click Add.
      Transaction
      Select a transaction from the list.
      Note: The list contains all available transactions for the selected MI program.
  4. On the Parameters tab, specify this information or update the existing parameters:
    Name
    Specify a parameter name.
    Column Name
    Select a column name from the list.
    Note: This column is available only if you select Entity as the resource type.
    Field Name
    Select a field name from the list.
    Note: This column is available only if you select M3WS as the resource type.
    Default Value
    Specify a default value.
  5. On the Conditions table, specify this information or update the existing conditions:
    Field Name
    Specify a field name.
    Condition Type
    Select a condition type from the list.
    Condition Value
    Specify a condition value.
    Use as Variable
    Select if you want to use the field name as variable to be used when mapping flows. This field is automatically checked if the Condition Value contains the Field Name preceded with a hash.
  6. Select a sorting option in the Sort Info section and specify a field where the sorting will apply. To disable sorting, leave this field blank.
  7. Click Save.
    Note: To see the integration flows that uses the selected integration template, click the Where Used tab.