SI_AGGREGATE_COUNT Property

Specifies the number of objects retrieved by a query that uses the COUNT function.

Type

Long

Syntax

Used to access the property from a query result:

QueryResult.Item(Index).Properties.Item("SI_AGGREGATE_COUNT").<count property>

Remarks

SI_AGGREGATE_COUNT is a property bag that is available only after doing a COUNT query. For example, if a query such as SELECT COUNT(SI_ID) FROM CI_INFOOBJECTS is made, the bag will contain a value that indicates the number of distinct objects that have the SI_ID property (for example, SI_AGGREGATE_COUNT.SI_ID = 100).

It is recommended that you do not mix aggregate and non-aggregate functions in a query statement; for example, do not use the TOP N function together with the COUNT function.