Conditions

This tab allows you to add a condition to the Data Model where the View is extracted.

Scenario

You receive invoices every day, but only want to receive the ones from the previous day. Based on that principle, you set up the Distribution to generate a report only if that data exists. In this example, you would select an Invoice By Customer view and apply a filter from the Web Views tab to display only the data from the day before. Then you would add the following condition:

  1. Click Add Condition.
  2. Click to enter your SQL condition into the Restriction Builder and click on Save.
  3. Click Confirm to finish.
Important

Conditions apply at the Data Model level and not at the View level.

The condition does not filter the view but rather, it checks if the condition exists.

Note  

The conditions defined in the Conditions tab must be applicable to all views that are involved in a job. If you have multiple conditions applied to multiple views, the job will not be performed if even one of your conditions cannot be applied to one of the selected views.

That means that if you want to create a job involving multiple views with incompatible conditions, you must create a separate job for each group of compatible views and conditions.