You can use the Extra Table Queries feature to create custom pick actions that provide access to specific Queries Lists. The pick actions are added to the pick action menu for the relevant type of items and can be selected from the Database Bar, Mimics, Lists, and so on.
The Extra Table Queries feature is useful as it allows you to provide fast access to lists containing specific information.
Example:
In this simple example of how the Extra Table Queries feature can be used, a custom pick action is added to database points. When selected for a specific database point, the custom pick action instructs ClearSCADA to display a list of the points that are in the same Group as the selected database point.
The Display All Points in Group pick action is configured by defining the following Extra Table Queries settings:
.png)
- Index—2. The index is a number that is associated with the Extra Table Query. Each query has its own index number that is used to identify the query.
- Table—CDBPoint. This is the table that contains the database points configuration. The pick action for the Extra Table Query will be associated with the database items in the CDBPoint table (all database points).
- Name—Display All Points in Group. This is the name of the pick action option that will provide access to the List that is defined by the Extra Table Query. The option is available for the items within the selected Table (all database points).
- Title—$FullName$. This sets the title of the Extra Table Queries display to the Full Name value of the selected database point.
- Query—The following query defines the data that is included in the Extra Table Query:
SELECT * FROM CDBPoint WHERE ParentGroupId=$ParentGroupId$
The Query sets the Query list to select the items in the CDBPoint table that have ParentGroupId values that match the ParentGroupId of the selected point. The items are then displayed on a List.
When the Display All Points in Group pick action is selected from a database point's pick action menu, a Queries list is displayed. The list shows those points that have ParentGroupId values that match the ParentGroupId value of the selected point (so the List displays the points that are in the same Group as the selected point).
For more information, see the topics that are listed in the gray footer section at the bottom of this topic. Select the relevant entry to display the topic that you require.
For a further example that illustrates how the extra table query feature can be used, please see A Custom Pick Action to Display a List of Out of Service Points in the ClearSCADA Guide to Lists.