Performing Queries on Collections

---

When you select a collection in the Properties list, the first 200 objects display in the Value list. A button labelled Run query on collection name (where collection name is the name of the collection you have selected) displays at the base of the Value list. Click this button to display a query form that enables you to enter your query, and run it.

Run the Inspection Tool from the General Ledger Module Control toolbar. Click Run query on allGLJournals.

Put query results into this data bucket

This determines which data bucket the query results will be put into.

and query on class

This is a dropdown selection where the user specifies the class to be queried. If the class has subclasses, the user may also select a specific subclass here. For example, if you select the GLJournal class then only objects in this class will pass to the query.

And/Or

These options determine whether the search is an AND search or an OR search, where more than one query line is entered.

Query lines

Each query can consist of up to six lines. To add additional query lines click the More button. To remove query lines, click the Less button.

The query lines section has three parts - property, query type, and value. A value is not visible if no property is selected.

You can select a property that is on a path, for example: myGLAccount.accountNo.

The options for the query type depend on which type of property you have selected. Here are the query types based on property type:

Query and Close buttons

Click Query to run the query. A progress bar displays the query progress.

Click Close to close the query form.

---