Query Manager

This program lets you create your own Sort Options and Filter Options for use in Queries.

It is launched from Simple Accounting Security Extensions.

If you find that you need a particular field for use in a Query, but that field is not present in your list of options when creating a Query, Query Manager lets you add it.

Editing Queries Directly

Alternatively, if you are expert at manipulating the Queries themselves, you can directly edit a Query without using the Filter and Sort Options. This can be used to create Queries which are either more complex or more efficient than is possible with the Query Window.

For example, the Query Window allow for seven Filter Options, but you may run into a situation where your report requires more than seven Filter Options. In that case, you could create the Query as usual and then edit the Query directly, adding the extra clauses to the Filter Expression manually.

SUPER ADVANCED STUFF

You may also wish to edit Queries to increase efficiency. Anyone who has worked with Simple Accounting will tell you that some Queries run much faster than others. The reason for this is that there is, as the expression goes, ‘more than one way to skin a cat.’ The Query Window allows you to always create a Query which works, but it does not always guarantee the fastest executing Query.

For example, there are certain Queries, such as the Sales Order Line Item History Report, which can be made up to one hundred times (you read that right) faster by a little hand editing. Normally, this is something that we will do for you, for example, to create a one-time edit to a Query which you will frequently use and which must run as quickly as possible. But if you decided that you wanted to look ‘under the hood’ and learn how to take advantage of the ‘magic’, this is the place to do it.