3.7.3 The Conditions Area
This area lists the conditions you have created for your query. To see how the conditions you have specified will work, try to step through them using "dummy" data on paper, rather than using a "try running and see" approach.
Showing Conditions in Descriptive Text
Search conditions are normally listed with the descriptive names of the fields as these provide a more readable format.
If you would rather see the field's object name, disable this option.
Grouping Search Conditions
Some conditions need to be processed as a group to achieve the required result.
For example, if you define these conditions to select all employees who have worked more than 60 hours or less than 23 hours in a specific week:
Time Equal To Week 46
AND Total Hours Greater Than 60
OR Less Than 23
The employees who have worked more than 60 hours in week 46 and the employees who have worked less than 23 hours in any week would be selected.
However, if you specify that these conditions are grouped, you achieve the required result:
Time Equal To Week 46
AND (Total Hours Greater Than 60
OR Less Than 23)
Specifying Grouped Conditions
1. Hold down the key and highlight the conditions to be grouped in the Conditions list.
2. Select the Group button.
3. LANSA Client will immediately place brackets around the grouped conditions. They will also be indented, to show you that they belong to the same group.
Naturally, you can only group conditions together if they are listed sequentially in the Conditions list.
To ungroup conditions, simply select the conditions you want to ungroup and select the Ungroup button. LANSA Client will immediately re-assign the brackets and remove the grouping indentation.
Note on File Joins: When your query contains fields from multiple files, the join conditions LANSA Client will be using are displayed in this area in upper case.
LANSA Client handles the join conditions between the files for you, so you do not need to understand the file names displayed.
You cannot modify or delete any of the joined files listed.
Further Information