SI_FLAGS Property

Indicates the nature of an InfoObject. Each object can have more than one flag. Indexed. Read-Only

Type

Long

Syntax

SELECT

    SI_FLAGS

FROM

    [Categories]

WHERE

    SI_ID=ObjectID

The syntax has these parts:

Part	Type	Description
ObjectID	Long	A number that identifies the object you want to retrieve.

Used to access the property from a query result:

QueryResult.Item(Index).Properties.Item("SI_FLAGS")

Remarks

The value of SI_FLAGS can be one or more of the following:

Value	Meaning	Explanation
16	eOverrrideGlobalSettings	Indicates whether the object limits and archiving has been overridden.
18	eAddedToA Container	Indicates whether the object is added to a container during the APS' startup phase.
19	eFileCopiedToServer	Indicates whether the file is copied to the server.
20	eSystemObject	Indicates whether an object is a system object.
21	eHiddenObject	Indicates whether an object is a hidden object.

The values indicate the bit number, and not the actual value; that is, 18 is bit 18, which is 2¹⁸. You can combine flags using the logical OR operator, but queries do not support bitwise OR or AND in the WHERE clause, so the values must be used in long form (for example, 2¹⁶= 65536).

If you want to check for bits 20 and 18, there are three cases:

• Either flags are turned on, but not both.
• Both flags are on.
• Both or either flags are turned on.

The following example illustrates the first case. It selects all objects that were added to a container during the APS' startup phase (2¹⁸ = 262144) OR are system objects (2²⁰ = 1048576), but are not both.

Example

SELECT 
    SI_NAME, SI_ID
FROM 
     CI_INFOOBJECTS 
WHERE 
    SI_FLAGS = 262144 OR SI_FLAGS = 1048576

For the second and third cases, the WHERE clause would look like this (1310720 is the sum of the values 262144 and 1048576):

• WHERE SI_FLAGS = 1310720
• WHERE SI_FLAGS = 1310720 OR SI_FLAGS = 262144 OR SI_FLAGS = 1048576

Note:    All of the above examples assume that no other bits are turned on. Since more bits may be turned on, it is recommended that you do not filter using SI_FLAGS. Once the objects are returned from the APS, you can use the language's bitwise operators to find out which flags are turned on.