There are many setup windows contained within the Query Manager (most of which were seen in the walkthrough). This next section will go over each of these setup windows in detail.
Run Query Window
After selecting a Query from the Query List Manger (Figure 13-4), the following window will appear, allowing you to edit and/or run the selected Query.
Figure 13-5
- Edit Record Filter – Allows you to view and/or edit the record filters (Figure 13-6).
- Edit Output Fields – Displays the currently selected output fields (Figure 13-7).
- Pick Output Type – Allows you to change the output type (Figure 13-8).
- Edit Sort Order – Allows you to edit the sort order (Figure 13-9).
- Browse Query Results –With this option checked, MicroBiz will display a preview window (similar to browsing the DBF with FoxPro) before the selected Output Type.
- The selected Output Type report will be displayed after you close the preview.
- Hide Duplicate Records – If enabled, duplicated results will not be displayed on your report.
- Run Query – Runs the Query with the selected settings.
- Help – Displays the Query Help window.
- Done – Closes the Run Query window.
Edit Record Filter
Record Filters determine the results of your Query, based on the settings made here. You can keep things simple as a single filter, or string together multiple filters for more advanced searching.
Figure 13-6
- Filter List – Displays the filters currently in use.
- Add –Allows you to add a new filter.
- Multiple filters can be strung together with AND (both conditions must be true) or OR (either condition may be true) functions.
- Edit – Allows you to change the selected filter.
- Switch – Allows you to switch between AND/OR functions.
- Move –Allows you to change the order of filters.
- This is used when grouping filters with brackets.
- Bracket –Used for grouping filters.
- In Figure 13-6, the first two filters are grouped together with an AND function and the there is a third filter grouped to these with an OR function. This means that search results will be displayed if both of the first two conditions are met (the "AND" function), OR if the third condition is met.
- Delete – Removes the currently selected filter.
- Cancel – Closes the Edit Record Filter window without saving your changes.
- Done – Saves your changes and closes the Edit Record Filter window.
- Help – Displays the Query Manager Help window.
Edit Output Fields
This window is where you select the types of data that will appear on your report.
Figure 13-7
- Fields to pick from –Displays all of the currently available fields in the Data Dictionary that are not yet included.
- Double-click on a field to add it to the list on the right.
- Fields to include in Query –Displays all of the currently included fields to be displayed in your Query Report.
- Double-click on a field to remove it from this list.
- You can change the order of the fields by "dragging" the button to the left of each field up or down with your mouse.
- Pick All – Marks all available fields to be included.
- Unpick All – Removes all included fields.
- Group – Allows you to set grouping wherein you can count records, add search results together, etc.
- Done – Saves your changes and closes the Edit Output Fields window.
- Cancel – Closes the Edit Output Fields window without saving your changes.
- Help – Displays the Query Manager Help window.
Pick Output Type
This screen is where you select the the type of report to use.
Figure 13-8
- Report –These output types are customizable and can be sent to the screen, to the printer or saved to a file.
- The options can be configured after clicking Run Query at the Run Query window.
- The "Browse records only" option is used if you do not want an additional report (no output type).
- Data Table –These output types are used for creating new DBFs based on Query results.
- The file name must be specified in the lower-right hand corner.
- ASCII Text File –These output types are used for generating .txt files of various types.
- The file name must be specified in the lower-right hand corner.
- Worksheet –These output types are used for creating Query results in proprietary formats, such as MS Excel worksheets.
- The file name must be specified in the lower-right hand corner.
- File Name –Allows you to specify the name of the output file selected.
- This is used for the "Data Table", "ASCII Text File" and "Worksheet" output types only.
- It is recommended to use your "Local Files Path" (typically C:\BIZWIN) for saving these files.
- It is recommended to leave the beginning of the file name as "QMF_", and only modify the remaining text. For example, "C:\BIZWIN\QMF_SALE" is a good name for a sales report.
- Done – Saves your changes and closes the Edit Output Type window.
- Cancel – Closes the Edit Output Type window without saving your changes.
Edit Sort Order
This window allows you to decide the order in which your data is presented. Note that some output types have a separate setting for this (such as the Report Form layout).
Figure 13-9
- Fields to pick from –Displays all of the currently available fields in the Data Dictionary that are not yet used to determine the sort order.
- Double-click on a field to add it to the list on the right.
- Fields to sort records by –Displays the currently configured sort order.
- Double-click on a field to remove it from this list.
- You can change the order of the fields by "dragging" the button to the left of each field up or down with your mouse.
- Pick All – Marks all available fields to be included.
- Unpick All – Removes all included fields.
- Sort – Changes the sort order of the currently selected field (up or down).
- Done – Saves your changes and closes the Edit Sort Order window.
- Cancel – Closes the Edit Sort Order window without saving your changes.
- Help – Displays the Query Manager Help window.