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