Skip to Content

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:

  1. An event occurs.

  2. The event triggers an action that has been associated with it.

  3. 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.