Find fieldId through labelid

Question

I would like ask if it is possible to find the fieldId of a specific table through the labelId of the field.

Thanks in Advance

Is this for getting a list of all fields (and tables) that references a particular label ID? — jp2g, Apr 17 '18 at 07:08

score 3 · Answer 1 · answered Apr 17 '18 at 16:16

3

Use Cross Reference. Via interface:

Tools \ Label \ Label Editor
Enter LabelID in Find what field
Click on Used by button
Find Tables, Maps or Views in the list

You sould generate Cross reference before (Tools \ Cross reference \ Periodic \ Update)

answered Apr 17 '18 at 16:16

mazzy

1,025
1
13
26

A good approach if the label is used on the table field directly (maybe that's exactly what @Nikos Kou needs), and not on an extended data type or an enum used by the table field. – 10p Apr 18 '18 at 08:55
See more crossrefs if a label used on the EDT, enum, report, form, confkey and other AOT objects. Use button `Add-ins \ Cross-reference \ Used by` to continue exploring deeper – mazzy Apr 19 '18 at 07:02

score 2 · Accepted Answer · answered Apr 17 '18 at 12:22

One of the possible solutions:

static void FindTableFieldsByLabel(Args _args)
{
    TableId         tableId     = tableNum(AccountingDistribution);
    str             findLabel   = literalStr('@SYS132687');
    SysDictTable    dictTable;
    SysDictField    dictField;
    FieldId         fieldId;

    dictTable   = new SysDictTable(tableId);
    fieldId     = dictTable.fieldNext(0);

    while (fieldId)
    {
        dictField = dictTable.fieldObject(fieldId);

        if (dictField.isSql() && !dictField.isSystem()
            && dictField.labelLabel() == findLabel)
        {
            info(strFmt('Field name: %1', dictField.name()));
        }

        fieldId = dictTable.fieldNext(fieldId);
    }

    info('Job completed');
}

You can also use dictField.labelDefined() if you want to ignore the labels set on extended data types and not on the table fields.

Find fieldId through labelid

2 Answers2

Linked