Executing a Query

Events are viewed using queries.

Queries can be executed as either dynamic or registered queries:

• Dynamic query: A query object is passed in at execution time, where it is parsed and executed by Event Collector.

  This approach is recommended for queries which are either performed infrequently, or which change often when called, because the filter expression has to be parsed whenever the query is run.

• Registered query: A query object is defined and registered with Event Collector, at which point it is parsed and stored. Whenever the query is subsequently called, a reference is made to the passed query, which improves efficiency both in data transport and in parsing costs.

  This approach is recommended for queries that are performed repeatedly over a period of time, because the filter expression only needs to be parsed once, but can be run many times.

The target option specified in a query (in the Query object) defines the Event Collector database table against which the query will execute, which in turn determines the type of information to be retrieved. See Using Attributes in Query Filters for more information, and see the TIBCO ActiveMatrix BPM Event Collector Schema Reference for details of the schema for all the Event Collector database tables.