After you create a query, it remains the current query until you change it. Using this feature, you can append a new query to the existing one and re-query the database. For example, suppose you create the following query:
{Type} ="AI" AND {Alarm Areas} ="Boston"
This query displays all the Analog Input blocks in the Boston alarm area. By appending the query:
AND {AI LOLO Alarm}<= "10"
you can display only those Analog Input blocks in the alarm area which have a LOLO alarm value less than or equal to ten.
To locate blank
cells in the database:
- In Classic view, on the View menu, click Properties.
-Or-
In Ribbon view, on the View tab, in the Settings group, click Properties.
- Select the Query tab and enter the following query.
{TAG NAME} = "*" AND {column_name}=""
For example, to find blank cells in the Description column use the query:
{TAG NAME} = "*" AND {Description}=""
This query displays all the blocks in the database that have no text in their Description fields.
