IMetaDictionaryLookup.LookupKeys

Syntax

LookupKeys(Attribute: String): Array;

Parameters

Attribute - name of an attribute, which values are necessary to receive.

Description

The LookupKeys method searches and returns an array of values of a specified attribute.

Example

Executing the example requires that the repository contains a time series database with the OBJ_FC identifier. This database must have a time series attribute with the COUNTRY identifier.

Add links to the Metabase, Cubes, Rds, Orm, Dimensions system assemblies.

Sub UserProc;
Var
    MB: IMetabase;
    RubDesc: IMetabaseObjectDescriptor;
    RubrIn: IRubricatorInstance;
    DictInst: IMetaDictionaryInstance;
    MetaDLookup: IMetaDictionaryLookup;
    Conditions: IOrmConditions;
    Cond: IOrmCondition;
    i: Integer;
    Res: Array Of Integer;
Begin
    MB := MetabaseClass.Active;
    RubDesc := MB.ItemById("OBJ_FC");
    RubrIn := RubDesc.Open(Null) As IRubricatorInstance;
    DictInst := RubrIn.Facts;
    MetaDLookup := DictInst.CreateLookup("");
    Conditions := MetaDLookup.Where;
    Cond := Conditions.Add;
    Cond.AttributeName := "COUNTRY";
    Cond.Value := 512;
    i := MetaDLookup.LookupKeys("FACTOR").Length;
    Res := New Integer[i];
    Res := MetaDLookup.LookupKeys("FACTOR");
    For i := 0 To Res.Length - 1 Do
        Debug.WriteLine(Res[i].ToString);
    End For;
End Sub UserProc;

After executing the example the console window displays indicator keys that satisfy the following condition: value of the COUNTRIES attribute equals to 512 in an indicator.

See also:

IMetaDictionaryLookup