Using Munis Version 11.2 Page 23
List expressions are formatted by inserting a vertical bar (|) between each item. Range
expressions are formatted by inserting a colon (:) or two periods (..) between two values, or by
using greater than (>), less than (<), equal to (=), or a combination of these symbols (for
example =>10 returns all values equal to or greater than 10).
The Load tab stores queries for specific programs so that you can use them again. For
screens that allow for multiple Finds, use concise descriptions for saved queries in order to
make it clear which queries are appropriate for each Find. When you save a query, click
Accept on the ribbon prior to executing the query, then type a description of the query in the
prompt that the program displays. By default, saved queries are available to all users. If the
Make Public check box is not selected on the Save As screen, then only the user who created
the query may access it.
To create a query:
1. Click Search on the ribbon.
2. Click Query Builder on the ribbon.
The program opens the Query Wizard program with the Fields tab displaying the fields and
the type of fields in the active program.
3. Type an expression directly into the Expression column or click the Format option to open
the Edit Assistant, Dropdown Assistant, or Date Assistant tab.
Query Wizard opens the appropriate assistant for the type of field that you are querying.
4. Build an expression:
List expression.
Add items to include in your list expression.
Range expression.
Select the low value and high value for the range.
Click the Switch option to change between the range expression and the list expression.
5. Click Format again.
The list or range expression you created appears in the Fields tab.
6. Click Execute to display the new active set of records created by the query.
To save a query for use at a later time, click Save As from the Fields tab or one of the
Assistant tabs. Once you have created a query, you can view or select them using the Load
tab.
To remove an item from the Select List of Items on the Dropdown Assistant tab, double-click
the item or press Enter to remove the item from the list.
Note: When you save a query, the program checks the entered description to see if it matches
one that you have already entered. (This check is not case-sensitive.) If the descriptions are
the same, you can save the new query in place of the old one. You cannot save a public or
private query with a description that another user has already used for a public query.