The Query Central group item link stores all saved queries in a central area, giving you easy access from almost any group item. The saved queries are displayed by Module and organized by Table and User. From Query Central you can do the following:
Query Central also hides many of the more complicated areas of the query tool, so you cannot add or edit queries in Query Central. Go to the group item Query page to create a query that can be stored here.
Use the Module drop-down list to select any module in netFORUM.
Use the Table drop-down list to view a list of all tables on which the queries have been saved. Select a table to display the queries in that table only.
Use the User drop-down list to view a list of all users who have saved a query. Select a user to display only the queries saved by that user.
The Delivery Method drop-down list defaults to Run Immediately. If you select Schedule in the Delivery Method drop-down list, the Add - Query Export Task page displays after the Available data elements... page. Use the Add - Query Export Task page to set up the export and scheduling options. The send time automatically defaults to two minutes after your computer time. The default accounts for any discrepancies between your computer time and the server time.
Use the Available data elements... page to edit the columns, or data, that displays in the result. The default selections come from the original query.
From the Query Central group item link, you have the option to run a one time or periodic query immediately or on a schedule.
The main Query Central page can display all available queries simultaneously. However, selecting from the available options narrows your results and minimizes your search time.
To run a query immediately, use the following steps:
Scheduled Queries allow you to schedule a one-time or periodic query over a date range, so you can get the results quickly and efficiently.
To schedule a query, use the following steps:
If the original query had the Ask at Run-Time check box selected. The Ask at Run-Time Values page displays.
Field | Required | Description |
---|---|---|
file name | Required | Enter the name of the export file. |
delimiter | Required | Enter the character you would like to use to define separate columns in the exported results file. |
separator | Optional | Enter the character you would like to use to define separate field values in the exported results file. |
exclude guid? | Optional | Click this check box to export the results of the query without the guid. |
Field | Required | Description |
---|---|---|
run task datetime | Required | This field defaults to two minutes after your computer time. The default accounts for any discrepancies between your computer time and the server time. To change the default, click anywhere in the field to see a calendar and time picker. Select the date and time you would like to run this Query. OR Click the Now link to run the Query immediately. |
execute after task | Optional | TBD |
notify template | Optional | Select an email template for the notification emails. |
notify email | Optional | Enter the email address that will receive notifications about this scheduled query. |
notify conditions | Optional | Gives you the following conditions to meet before netFORUM sends a notification email: on start? on success? on completion with errors? on failure? |
recurrence | Required | Select one of the following options from the drop-down list:
|