Sometimes a little information has a big
effect. In this rubric of the COMOS Plant
Manager, Doc COMOS answers your ques-
tions and gives you tips on how to work
with the COMOS software solution even
more efficiently. Today Doc COMOS an-
swers the following question:
“How could I realize a query
even faster?”
Doc COMOS will introduce in two videos
the search method “database query”, which
helps save time.
The first video shows the two different
methods to do a query. In both methods,
the amount of data is equal. With the meth-
od of the “classic query” (video sequence of
the first 45 seconds) it takes around 10 sec-
onds to request, interprete, and display the
information. Much more faster you could
receive the information by the search meth-
od “database query” (video sequence from
second 45). Even with the same amount of
information, this type of query needs only
approx. one second compared to the “classic
query” to request, interprete, and display the
information.
The second video is presenting how to cre-
ate a “database query”. The video shows
the different working steps:
1. Open an empty “Query”
2. Select “Database search”
3. The configuration field of the “database
query“ will be opened
4. Define the “start object” by drag & drop
Tips and Tricks – ask Doc Comos
5. Define the searched settings (e.g.
Property, Attribute or FreeProperty)
6. Specify the settings by further definition
(e. g. Name, Lable, or Description)
7. Define the searched value
(in our sample it is G125)
8. Link to “AND operation”. In the configura-
tion field the fixed settings are linked to
“AND operations”
9. Again, define the searched settings
(e.g. Property, Attribute, or FreeProperty)
10. Specify the settings by further definition
of the “Attribute name” (in the sample we
enter “PIA055”)
11. Define the searched value
(in our sample it is “7”)
12. Link to “OR operation”. The different
configuration fields are linked to
“OR operations”
13. A new configuration field will
be opened. Enter the requested
information in the fields (in our
sample it is “Property, Name, =
und G55”).
14. To start the query, click the
“Search” button
15. The requested information will
be shown
16. Only the defined data sets will be
taken from the database. In our
sample we have a “Query: 16/16”.
Video 1 (1:21 Minuten)
Video 2 (1:43 Minuten)
19 COMOS Plant Manager | 3/2012
NEWS