Use the Display Conditions and Display Relations tabs in the Conditions and Relations step to define the conditions and relations for retrieving data. Both conditions and relations are based on the database structure and logic.
Define the priority sequence of the conditions. Click these columns to select the appropriate bracket type. |
Click this column to select the table for which you want to set conditions. |
Press Tab to select the required field from the selected table, for which you want to set conditions. |
Click this column to choose the required condition: Equal, Greater than, Smaller than, Not equal, Contains, and so on. The following terms also appear on the list:
Example If no value was entered in the Customer/Supplier Ref. No. field in a marketing document, the value of that field is NULL. End of the example. |
Click this column to select an additional table. This enables you to:
|
The following alternatives can be defined in this column:
|
This column enables you to define complex conditions, by defining the relationship between two or more conditions that you define.
|
Applies the defined relation between the tables that appear in the row. When this checkbox is selected, SAP Business One adds another condition. This means that the records you want to retrieve must comply with the conditions defined on the Define Conditions tab and with the added condition. |
Select the checkbox All to display data from the table that appears in the To Table section of the query results. |
Select the checkbox All to display data from the table that appears in the From Table section of the query results. |