Query – Filter Data:
The query enables you to find records that meet a certain condition (criteria). Each window that displays a tabular list of records can be used in a query. For example: you want to see all accounts that are located in the city of Washington or account that have a trip count of 500 or more. When you click on the Query button, LimoWiz shows the query window. This window has five major components:
| 1. | Field list: These are the fields you base your search (query) on. Double click select the field. |
| 2. | Conditional Operators: For example, Equals, Contains, Greater Than etc. Click on the button that you desire, like Contains. |
| 3. | Value: value of the field. |
| 4. | Boolean Operators: AND, OR. These are used to combine conditions. For example CITY = ‘ABC TOWN’ AND LASTNAME = “MARKS” |
| 5. | Query Text Box: |
| 6. | Click on Execute Filter Expression. , when you are done with entering the query condition, If the condition is invalid, a warning is displayed. You have unlimited undo levels to correct mistakes. |
Query Sample:
Open driver list, right click mouse on list and select Query from pop menu.
You select the field name from drop down list. The fields are filled automatically based on the database used. Then select your comparison option:
Then you type the value in the Value field.
Note: Dates must be entered as MM/DD/YYYY or local date format for country of origin.
Logical fields must by entered as: Y or N which mean YES and NO respectively.
| 1. | Select the CITY field. |
| 2. | Select Contains option from the Comparison drop down list. |
| 3. | Enter: VILLE |
Click Execute Filter Expression.
LimoWiz will if any records match your query:
