Query management

You can add fields to user reports in the Report module. Before these fields can be used in a  report, they must be added to the query. You can then generate a TTX file from this query. (see for more information about generating TTX files) The field definition list of the report can be modified based on this file.

Then you can Reports - adding fields the desired fields in the report. Read more about placing fields in the report. After placing the fields you can open the report again from Asset Strategy Optimization. The added fields will now be visible.

Before new fields become available for a report, the query must be modified. You can do this using the Query Management window. You can create and edit user queries via the Query Management window. Open the window as follows:

1. Open the menu User Reports > Query Management

   

   The User queries window appears.

   

2. On the left pane of the window, you will see the fields as retrieved by the database query. These are divided FM-Library, FMECA-Systems,Simulation Models, and RCA.

3. After selecting a query type on the left pane, all query-definitions defined for that type will become visible on the right side of the windows. The following options are now available:

   • New

   Select this button to create a new user query. This opens the following screen:

   

   On selecting Next you will see a screen which is identical to the one below (see Add fields), the actions are also identical.

   After adding fields, click Next again

   In a third screen, give the new query a name and description, then Click Next to generate the Query. It will be saved in the location defined in the Options settings.

   • Add fields

   This button will open the screen below, and lets you add fields to the selected, existing, user queries.
   
   On the left side you see the fields as retrieved by the database query

   Select the desired fields from the field selection list on the left

   Click >> to include these fields in the list with fields to be added

   Select Next

   

   • Gen. TTX file

   TTX files can be used to design new Crystal Reports based on user queries. As the TTX files are only used for designing the Crystal Reports, it is possible that the TTX file is no longer present. This button will generate a new TTX file based on the user query. The location of the TTX file is displayed at the bottom of the window next to "Path".

   Note A TTX file must be Link a TTX File to a Report to a report in Crystal Reports, to make sure that the fields can be found in the field definition table

   • Delete

   Select this button to delete a redundant or erroneous query file

   • Report management

   Select this button to open the Reports management window

   • Update

   Select this button to refresh the fields listed at the bottom of the screen.

4. Click Exit to close the query management screen.

   No selection fields? As mentioned earlier, a list with selection fields will be displayed on the left side in the above illustration. If these fields do yet not exist in the current query, they can be added to the query. If no fields are shown on the left side, this means that all possible fields have already been added to the query. That means no further fields can be added to the query.