The Query Wizard provides a quick and easy way to filter data either for display on browse screens or to filter reports. Most browse screens now include a Quick Filter button. This is great for when you want to search a single field for a specific value. Just like when you have created a query using the Query option, the Reset button will remove the filter created by the Quick Filter button.
Let's go through the steps of creating a query.
You will first need to choose the field you to want to search. In this example I am going to query on the Request Status field.
Next you will need to choose an operator to use. This version adds some new operators, such as the Between and Not Between. This is especially helpful for data searching. Also, new operators for the date type fields allow you to search for a month number (12- December, 11 - November and so on).
I will choose the Not Equal To operator.
After choosing a field and an operator you next choose the value to search. In most cases this will be a constant however, you can also compare one field to another. An example would be to find records where the Complete Date is equal to the Due Date field. In this case, I want to find requests where the Status is Not Equal to New, so I type in the value New.
Finally, give you query a meaningful name. Click OK and the data is filtered as specified.
