Sample Queries

Most application forms have query forms associated with them. These query forms can be used to perform complicated and sophisticated queries of the data in a collection and then to return to the parent form only the data you want.

Performing these queries can be something of an art. To help give you an idea of what you can do with query forms, we offer these sample queries:

• Sample wildcard query: You can use a wildcard character as part of the query criteria, to broaden a search base.
• Sample Range Query: You can set a range on criteria such as dates, part numbers, names, and so on, to limit the number of returns.
• Sample Null Query: You can use the word "null" as a search term, when you need to find out which records are currently blank for a particular value.
• Sample Query Using the Current Date: You can use special keywords to limit results returned. One such keyword is CURDATE, which returns only data for the current date. You can also specify ranges of dates relative to the current date, such as data from the 30 days previous to the current date.
• Sample Query Using a Question Mark: You can create a saved filter that uses a question mark for the value of a particular criterion. Later, when you use the saved filter, the system prompts for a value for the question mark.