Why:

This facility allows Fusion users to submit queries that have already been created in a predefined Library.

It can be used for queries that do not require run-time parameters to be input. Queries that require run-time parameters, such as a date range, need to be run from a ‘green-on-black’ command line.

 

Where:

This is accessed via the Fusion Workbench - General menu – Reports – Dealer Queries option.

 

How to Perform Dealer Queries:

When you access the option you are presented with a list of queries that have been created in one or more libraries.

Those libraries are listed in the parameter QRY001. Each entry in this parameter needs to be 10 characters in length, so if you use library QGPL then it needs to be followed by 6 blank characters before the next library entry.

You can submit one query to run in batch, or you can run several by holding the CTRL key and selecting multiple queries.