Configure the Running Order for Queries and Rules

If a control acts as a trigger sourceClosed A field that is used in conjunction with a trigger event to interactively run an action, rule, or data service. For example, a button that runs a query when clicked, a prompt that runs a query when submitted, or a form that runs a query when loaded. for more than one data source or more than one rule and the order in which they are run is important, then you must configure values for priorityClosed The order in which actions, rules, or data services that have otherwise identical triggers are run. Priority values are compared only if the actions have the same trigger source, trigger event, and trigger key (if any). The type of trigger source is irrelevant. Among actions, rules, or data services with otherwise identical triggers, the trigger source with the lowest value for priority is run first. for these triggers. In that situation, you can assign different values for the trigger Priority for these otherwise identical triggers, and the data source, form rule, or business rule with the lower value for Priority is run first. For data sources, whether the type of data source differs is not relevant.

Note: For information about how to select data source queries, form rules, and business rules to be run when a control is used, see Select Data Source Queries and Rules to Run.

Note: Trigger Priority values for data sources are not compared with Priority values for form rules and business rules. Regardless of their Priority values, all data sources are run before any form rules or business rules are run.

To configure the order in which data source queries are run relative to each other and the order in which rules are run relative to each other, do the following:

  1. In a form, select View > Actions. The list of actions or rules is displayed.
  2. Select the row of the action you want to configure the running order for and click Edit.
  3. In the dialog box, enter a value for Priority for the data source. The data source with the lower value for Priority is run first.

    Tip: Trigger priorities are compared only if the triggers have the same trigger source, trigger event, and trigger key (if any). For example, if a data source has both a button and a prompt that act as triggers, their Priority values are not compared to each other.

  4. Click OK.
  5. Repeat for each data source for which a trigger is listed.