Display a List of All Database Items in a Specific Class

You can use the ClearSCADA Database Schema to link to the Web interface's displays for database items. The list shows the values of each of the fields for the items of the specified class.

To display a list of the database items in a specific class:

1. Access the Database Schema.
2. Display information about the required class. For more information, see:
   • Display Information about a Creatable Class
   • Display Information about All Classes.
3. Select the List All <Item Type> hyperlink. (For example, for the CMimic class, you elect the List All CMimic Objects hyperlink.)

   When you select a suitable hyperlink, a Filter Columns window is displayed. You can use the Filter Columns window to restrict the List so that only certain items are included. The Filter Columns window works in the same way as the Filter Columns window for Queries Lists (for more information, see Filter a List in the ClearSCADA Guide to Lists).

   When you have selected the OK or Cancel button on the Filter Columns window, the list of items is displayed.

   

The list of items is the result of an SQL Query (this may be filtered or unfiltered, depending on any settings made via the Filter Columns window). The list typically contains more columns than are shown if you were to view the same items in a Queries List in ViewX or WebX.