Skip to main content

This is documentation for Caché & Ensemble. See the InterSystems IRIS version of this content.Opens in a new tab

For information on migrating to InterSystems IRISOpens in a new tab, see Why Migrate to InterSystems IRIS?

%Dictionary.CompiledIndex

persistent class %Dictionary.CompiledIndex extends %Library.Persistent, %Dictionary.CompiledIndexQuery

SQL Table Name: %Dictionary.CompiledIndex

Property Inventory

Method Inventory

Parameters

parameter SQLENABLED = 1;

Properties

property BuildPurge as %Boolean;
BuildPurge
Property methods: BuildPurgeDisplayToLogical(), BuildPurgeGet(), BuildPurgeIsValid(), BuildPurgeLogicalToDisplay(), BuildPurgeNormalize(), BuildPurgeSet()
property CompilationSignature as %CacheString;
CompilationSignature
Property methods: CompilationSignatureGet(), CompilationSignatureIsValid(), CompilationSignatureSet()
property CompilerGenerated as %Boolean;
CompilerGenerated
Property methods: CompilerGeneratedDisplayToLogical(), CompilerGeneratedGet(), CompilerGeneratedIsValid(), CompilerGeneratedLogicalToDisplay(), CompilerGeneratedNormalize(), CompilerGeneratedSet()
property Condition as %CacheString;
In the case of a conditional index, specifies the condition that must be met for an entry to be included in the index.
Property methods: ConditionGet(), ConditionIsValid(), ConditionSet()
property Data as %CacheString;
Specifies a list of properties whose values are to be stored within this index.
Property methods: DataGet(), DataIsValid(), DataSet()
property Deprecated as %Boolean;
True if this index is deprecated.
Property methods: DeprecatedDisplayToLogical(), DeprecatedGet(), DeprecatedIsValid(), DeprecatedLogicalToDisplay(), DeprecatedNormalize(), DeprecatedSet()
property Description as %CacheString;
Specifies a description of the index.
Property methods: DescriptionGet(), DescriptionIsValid(), DescriptionSet()
property Extent as %Boolean;
An extent index is used to keep track of which object instances belong to a subclass. When using bitmap indices, then an extent index is automatically maintained and there is no need to define one.
Property methods: ExtentDisplayToLogical(), ExtentGet(), ExtentIsValid(), ExtentLogicalToDisplay(), ExtentNormalize(), ExtentSet()
property Final as %Boolean;
Final
Property methods: FinalDisplayToLogical(), FinalGet(), FinalIsValid(), FinalLogicalToDisplay(), FinalNormalize(), FinalSet()
property Id as %Integer;
Id
Property methods: IdDisplayToLogical(), IdGet(), IdIsValid(), IdLogicalToDisplay(), IdNormalize(), IdSet()
property IdKey as %Boolean;
Specifies that the property or properties defined for this index will be used to form the Object Identity value for this object. This value is used to uniquely locate persistent object instances.
Property methods: IdKeyDisplayToLogical(), IdKeyGet(), IdKeyIsValid(), IdKeyLogicalToDisplay(), IdKeyNormalize(), IdKeySet()
property InheritedId as %Boolean;
InheritedId
Property methods: InheritedIdDisplayToLogical(), InheritedIdGet(), InheritedIdIsValid(), InheritedIdLogicalToDisplay(), InheritedIdNormalize(), InheritedIdSet()
property Internal as %Boolean;
If true, then do not display this item in automatic documentation.
Property methods: InternalDisplayToLogical(), InternalGet(), InternalIsValid(), InternalLogicalToDisplay(), InternalNormalize(), InternalSet()
property KeywordError as %Boolean;
KeywordError
Property methods: KeywordErrorDisplayToLogical(), KeywordErrorGet(), KeywordErrorIsValid(), KeywordErrorLogicalToDisplay(), KeywordErrorNormalize(), KeywordErrorSet()
property KeywordModified as %Boolean;
KeywordModified
Property methods: KeywordModifiedDisplayToLogical(), KeywordModifiedGet(), KeywordModifiedIsValid(), KeywordModifiedLogicalToDisplay(), KeywordModifiedNormalize(), KeywordModifiedSet()
relationship Methods as array of %Dictionary.CompiledIndexMethod [ InitialExpression = $listbuild("%Dictionary.CompiledIndexMethod","parent",+$this,"children",1,1) , Transient , Inverse = parent , Cardinality = children ];
Method
Property methods: MethodsGet(), MethodsGetObject(), MethodsGetObjectId(), MethodsGetSwizzled(), MethodsIsEmpty(), MethodsIsValid(), MethodsNewObject(), MethodsRClose(), MethodsRExec(), MethodsRFetch(), MethodsRelate(), MethodsSQLCompute(), MethodsSet(), MethodsUnRelate()
property Name as %Dictionary.CacheIdentifier [ Required ];
The name of the index.
Property methods: NameGet(), NameIsValid(), NameSet()
property NotInheritable as %Boolean;
NotInheritable
Property methods: NotInheritableDisplayToLogical(), NotInheritableGet(), NotInheritableIsValid(), NotInheritableLogicalToDisplay(), NotInheritableNormalize(), NotInheritableSet()
property Origin as %CacheString;
Origin
Property methods: OriginGet(), OriginIsValid(), OriginSet()
property Parameters as array of %CacheString;
Parameter
Property methods: ParametersBuildValueArray(), ParametersCollectionToDisplay(), ParametersCollectionToOdbc(), ParametersDisplayToCollection(), ParametersGet(), ParametersGetObject(), ParametersGetObjectId(), ParametersGetSwizzled(), ParametersIsValid(), ParametersOdbcToCollection(), ParametersSet(), ParametersSetObject(), ParametersSetObjectId()
property PosInt as %Boolean;
PosInt
Property methods: PosIntDisplayToLogical(), PosIntGet(), PosIntIsValid(), PosIntLogicalToDisplay(), PosIntNormalize(), PosIntSet()
property PrimaryKey as %Boolean;
Specifies that this index should be reported, via SQL, as being the Primary Key for this class.
Property methods: PrimaryKeyDisplayToLogical(), PrimaryKeyGet(), PrimaryKeyIsValid(), PrimaryKeyLogicalToDisplay(), PrimaryKeyNormalize(), PrimaryKeySet()
property Properties as %CacheString;
Specifies a list of properties used to build this index. May also include a collation specification for each property.
Property methods: PropertiesGet(), PropertiesIsValid(), PropertiesSet()
relationship PropertyCollection as array of %Dictionary.CompiledIndexProperty [ InitialExpression = $listbuild("%Dictionary.CompiledIndexProperty","parent",+$this,"children",1,1) , Transient , Inverse = parent , Cardinality = children ];
Property
Property methods: PropertyCollectionGet(), PropertyCollectionGetObject(), PropertyCollectionGetObjectId(), PropertyCollectionGetSwizzled(), PropertyCollectionIsEmpty(), PropertyCollectionIsValid(), PropertyCollectionNewObject(), PropertyCollectionRClose(), PropertyCollectionRExec(), PropertyCollectionRFetch(), PropertyCollectionRelate(), PropertyCollectionSQLCompute(), PropertyCollectionSet(), PropertyCollectionUnRelate()
property SequenceNumber as %Integer;
SequenceNumber
Property methods: SequenceNumberDisplayToLogical(), SequenceNumberGet(), SequenceNumberIsValid(), SequenceNumberLogicalToDisplay(), SequenceNumberNormalize(), SequenceNumberSet()
property SqlName as %CacheString;
Defines an alternate name for this index when referred to via SQL.
Property methods: SqlNameGet(), SqlNameIsValid(), SqlNameSet()
property SystemAssigned as %Boolean;
SystemAssigned
Property methods: SystemAssignedDisplayToLogical(), SystemAssignedGet(), SystemAssignedIsValid(), SystemAssignedLogicalToDisplay(), SystemAssignedNormalize(), SystemAssignedSet()
property Type as %CacheString;
Specifies the type of the index. Type 'key' is deprecated.
Property methods: TypeGet(), TypeIsValid(), TypeSet()
property TypeClass as %Dictionary.CacheClassname;
Specifies the FunctionalIndex class used to provide the implementation of the functional index interface.
Property methods: TypeClassGet(), TypeClassIsValid(), TypeClassSet()
property Unique as %Boolean [ SqlFieldName = _Unique ];
Specifies whether this is a unique index. The property or properties indexed by a unique index are constrained to have unique values. This means that no two instances can have the same collated value within the extent among the set of all objects of the class that defines the index.
Property methods: UniqueDisplayToLogical(), UniqueGet(), UniqueIsValid(), UniqueLogicalToDisplay(), UniqueNormalize(), UniqueSet()
relationship parent as %Dictionary.CompiledClass [ Required , Inverse = Indices , Cardinality = parent ];
Pointer to the containing parent object
Property methods: parentGet(), parentGetObject(), parentGetObjectId(), parentGetSwizzled(), parentIsValid(), parentNewObject(), parentRClose(), parentRExec(), parentRFetch(), parentRelate(), parentSQLCompute(), parentSet(), parentSetObject(), parentSetObjectId(), parentUnRelate(), parentUnSwizzle()

Methods

classmethod %Exists(oid As %ObjectIdentity) as %Boolean
Inherited description: Checks to see if the object identified by the OID oid exists in the extent.

Returns %Boolean TRUE if it exists, FALSE if it does not.

classmethod %LockId(id As %String, shared As %Boolean = 0, timeout As %Integer) as %Status
Inherited description: Obtain an exclusive or shared lock on the object identified by id. The type of lock obtained is determined by shared. This method is normally generated by the storage class for persistent classes using %Library.CacheStorage or %Library.CacheSQLStorage.
classmethod %UnlockId(id As %String, shared As %Boolean = 0, immediate As %Boolean = 0) as %Status
Inherited description: Release an exclusive or shared lock on the object identified by id. The type of lock released is determined by shared. If this method is not overridden then the default implementation returns an error. This method is normally generated by the storage class for persistent classes using %Library.CacheStorage or %Library.CacheSQLStorage.
classmethod parentOnDelete(id As %String, concurrency As %Integer) as %Status

Indexes

index (IDKEY on Name) [IdKey, Type = key];
Index methods: IDKEYCheck(), IDKEYDelete(), IDKEYExists(), IDKEYOpen(), IDKEYSQLCheckUnique(), IDKEYSQLExists(), IDKEYSQLFindPKeyByConstraint(), IDKEYSQLFindRowIDByConstraint()

Triggers

trigger OnDelete (BEFORE event DELETE);
trigger OnInsertUpdate (BEFORE event INSERT/UPDATE);

Inherited Members

Inherited Methods

FeedbackOpens in a new tab