Related Topics:

Report Templates

Import/Export Templates

Query Templates

Xfmea gives you the ability to save queries as templates that can be re-used at a later time. This can save a great deal of time if you have particular queries that you run repeatedly. Saved query templates are also available in the Available Reports area of the Reports window and can be included in generated reports.

If a standard database (*.rsrp) is open when you save a query, it will be stored in the Standard templates file (*.xrt8) that is active for your computer, and it will be available for use in other databases. If an enterprise database (SQL Server or Oracle) is open, the query will be stored within the enterprise database itself.

This topic explains how to manage query templates, including:

Adding and Editing Templates via the Query Template Window

The Query Template window allows you to add a new query template or edit an existing one. It is accessed by clicking the Add button or the Edit button on the Query Templates tab of the Templates Manager. This window works in the same way as the Query utility, with the following exceptions:

After you enter a name and description for the new template, click OK to save it.

Saving New Templates via the Query Utility

To save a query, once you have configured all of the desired options on the Criteria and Headers Customization tabs of the Query utility, click the Save Query icon.

The Save Query window will appear. Provide a name for the query and, if desired, a description and then click OK to save the query. The saved query includes all of the settings specified on the Criteria and Headers Customization tabs. It does not include the query results or settings made in the Limit by Specified Items area.

To run a query that you have previously saved, click the Open Saved Query icon.

The Select Existing Query window will appear, as shown next.

Choose the type of query that you want to open from the drop-down list at the top of the window. By default, the query type that was selected in the Query utility will be selected. The table will display all saved queries of that type. To open a query, you can double-click it or select it and click OK. The Select Existing Query window will close and the settings on the Criteria and Headers Customization tabs of the Query utility will change to reflect the settings used in the saved query. It is important to understand the following:

In such cases, for any properties that are available in both the saved query and the current Query utility settings, the saved query’s settings will be used.

 

© 1992-2013. ReliaSoft Corporation. ALL RIGHTS RESERVED.