Rules in Jitterbit App Builder
Overview
A business rule (a rule) is a piece of business logic that defines how your application interacts with its data. Rules are essentially mvSQL queries that you create in the business layer.
You can use rules for a variety of tasks: to read data from tables (a business object rule); to create, update, or delete data (using a CRUD rule); to validate data (using a validation rule); to set default values (using a default rule); and many other things, depending on the rule's purpose.
There is a close relationship between rules and events: events trigger actions, and actions can execute rules. You can use this Event > Action > Rule sequence to maintain the integrity of and consistency between your app's data sources:
-
An event occurs.
-
The event triggers an action that has been associated with it.
-
The action executes. If the action is of type Rule, it runs the specific business rule defined for it.
For example, you could configure an insert event on a Customers table that activates when a user clicks a Save button, triggering an action that executes a validation rule. The validation rule would then check the data before it is inserted into the database.
To manage rules, edit your app, then select App Workbench > Rules.