MicrOpay IQ is a reporting tool that retrieves data from the currently selected company database using queries, called IQ Queries. When the IQ Query is run, the results are displayed in a separate grid window. The grid data can then be saved for use in other applications or displayed on a chart.
Very simple queries do not require selection criteria, so there is no reason to enter parameters for the data retrieval. More complex queries or those that may return a large range of data have pre-defined parameters that allow you to filter the data so only relevant records are returned.
MicrOpay IQ Queries retrieve a large volume of information from pre-defined data tables. Often, this will provide more information than required, so IQ queries can be customised to return only relevant data fields. This is done by selecting an existing IQ query and adapting it to suit your reporting requirements.
Run an IQ Query without Parameters
Go to Common, IQ grid, and highlight the IQ Query to run.
Select Show from the toolbar or by clicking the right mouse button on the highlighted IQ Query.
Run an IQ Query with Parameters
The parameters in an IQ Query are determined by the SQL Statement, which retrieves data based on criteria entered at the time of running the IQ Query.
Go to Common, IQ grid, and highlight the IQ Query to run.
Select Show from the toolbar or by clicking the right mouse button on the highlighted IQ Query. This will open the Modify Enquiry Parameters Values window.
Enter the Parameter value(s) in the Value field(s).
Click OK to run the IQ Query.
When the IQ Query is run, the results will show in a separate grid window.
Once displayed in the grid, information may be exported.