Using The Lookup Function to Obtain Organization, User, and Group Information

Overview¶

This explains how to use the lookup function to obtain information about organizations, users, and groups.

In this FAQ, we will introduce a configuration example for obtaining information from the organization table.

Configuration Example¶

Specify a "Link" in JSON format in the "Option List". The description method is the same as "Manage Table: Editor: Column Advanced Settings: Option List: Filter, Sort,".

In the example below, when an "Column" is selected, ClassA in the organization table is transferred to ClassC, ClassB is transferred to ClassD, and ClassC is transferred to ClassE.

JSON¶

[
    {
        "TableName": "Depts",
        "Lookups": [
            {
                "From": "ClassA",
                "To": "ClassC",
                "Type": 0
            },
            {
                "From": "ClassB",
                "To": "ClassD",
                "Type": 0
            },
            {
                "From": "ClassC",
                "To": "ClassE",
                "Type": 0
            }                          
        ]
    }
]