ClearSCADA provides access to many types of List (see Welcome to the ClearSCADA Guide to Lists). Each List is automatically filtered so that it only includes the alarms, events, historic records, or items that are relevant to the specific area of the database from which the List is displayed. If some of the Lists on your system regularly require further filtering in order to restrict their content to those entries that are of interest, consider whether to ‘customize’ those Lists. By ‘customizing’ Lists, you can provide access to such Lists without the need for further filtering each time that the List is displayed.
You can create ‘custom’ Lists in ClearSCADA by:
- Embedding Lists in Mimics—You can embed a Queries List in a Mimic, and then use an SQL query to define the content of that List. For instance, you can specify which database table ClearSCADA is to query, which fields you want the List to include, and the order in which the data is to be displayed in columns on that List.
Consider embedding Lists in Mimics if more than one user frequently needs to access information in List format, and such access would otherwise require much manual filtering of a List.
For further information, see Using SQL to Customize Lists. For examples that demonstrate how you might create ‘custom’ Lists, including by embedding Lists in Mimics, see Example Configuration.
- Using Favorites—If only one user needs to access a List that requires several filters to restrict its content, and that user’s User Account provides access to the Favorites Bar, they can filter the List as required and then add it to their list of Favorites. Whenever they display the List from the Favorites Bar, it will be filtered automatically.
Consider using Favorites as an alternative to other means of ‘customizing’ Lists, if only one user needs access to such Lists. For more information on using Favorites, see Favorites Bar in the ClearSCADA Guide to ViewX and WebX Clients.
- Adding custom pick actions to provide access to specific Lists—A system administrator can add extra Table Queries to the server, in order to provide access to Queries Lists that provide specific information. Each ‘custom’ List that is added to the system in this way is associated with a particular database table. As such, a custom pick action is associated with each item in that database table. Whenever a menu associated with that item is displayed, the custom pick action is included. The pick action provides access to the ‘custom’ List. As with Queries Lists that you embed on Mimics, you can use an SQL query to define the content of each List.
Consider adding extra Table Queries if you want to provide access to specific information in List format, and you want every item associated with a particular database table to provide access to such a List. For more information, see Extra Table Queries in the ClearSCADA Guide to Server Administration, and see Using SQL to Customize Lists. For an example that demonstrates Table Queries, see A Custom Pick Action to Display a List of Out of Service Points.
Be aware that you will need to restart the server for any extra Table Queries to come into effect.
Consider adding extra Table Queries if you want to provide access to specific information in List format, and you want every item associated with a particular database table to provide access to such a List. For more information, see Extra Table Queries in the ClearSCADA Guide to Server Administration, and see Using SQL to Customize Lists. For an example that demonstrates Table Queries, see A Custom Pick Action to Display a List of Out of Service Points.
Be aware that you will need to restart the server for any extra Table Queries to come into effect.
You can also temporarily customize a List that is not embedded in a Mimic, by altering the SQL query that is being used to display that List. However, be aware that any changes to the SQL query are lost as soon as the List is closed.