Column Advanced Settings: Option List: Filter, Sort, Display Format

Overview¶

You can use a customized list of options by writing the "Option List" in JSON format.

Limitations¶

1. Cannot be used with columns other than "Owner Column", "Manager Column", and "Class Column".

Prerequisites¶

1. "Site Administration Permission" is required to configure settings.

Operation Procedure¶

Open the advanced settings of the classification in the Editor tab, and write the display method of the options in JSON format in the option list.

For Depts, Groups, and Users¶

The following example displays a list from the user table in the format "Name - Dept", then department and name in ascending order.

JSON¶

[
    {
        "TableName": "Users",
        "MembersOnly": true,
        "SearchFormat": "[Name] - [Dept]",
        "View": {
            "ColumnSorterHash": {
                "DeptCode": "asc",
                "Name": "asc"
            }
        }
    }
]

The following example displays a list from the user table in the format of "Name - Email Address", in ascending order of name.

JSON¶

[
    {
        "TableName": "Users",
        "SearchFormat": "[Name] - [MailAddresses]",
        "View": {
            "ColumnSorterHash": {
                "Name": "asc"
            }
        }
    }
]

The following example extracts and displays users belonging to the specified department code from the user table.

JSON¶

[
    {
        "TableName": "Users",
        "MembersOnly": false,
        "SearchFormat": "[Name] - [Dept]",
        "View": {
            "ColumnFilterHash": {
                "DeptCode":"[\"200600\",\"200610\",\"200620\"]"
            },
            "ColumnFilterSearchTypes":{
                "DeptCode": "ExactMatchMultiple"
            }
        }
    }
]

The following example extracts and displays users belonging to a specified group ID from the user table.

JSON¶

[
    {
        "TableName": "Users",
        "View": {
            "ColumnFilterHash": {
                "Groups": "[1,2]"
            }
        }
    }
]

Example of Display in Search Dialog¶

Displayed in the format specified in SearchFormat: "[Name] - [Dept]".

Link to Table¶

In the example below, a list is displayed in ascending order by title for records with CheckA turned on in the table with site ID: 12345. When a value is selected, the linked ClassA is posted to ClassB, and the linked ClassB is posted to ClassC.

JSON¶

[
    {
        "SiteId": 12345,
        "NoAddButton": false,
        "View": {
            "ColumnFilterHash": {
                "CheckA": true
            },
            "ColumnSorterHash": {
                "Title": "asc"
            }
        },
        "Lookups": [
            {
                "From": "ClassA",
                "To": "ClassB",
                "Type": 0
            },
            {
                "From": "ClassB",
                "To": "ClassC",
                "Type": 0
            }
        ]
    }
]

When you do not want to include yourself or your department in the option¶

You can exclude yourself and your department from the options by specifying ExcludeMe in the JSON of the option list.
Use this when you do not want the logged-in user to be selected as the approver in an approval workflow using a process button, etc.

JSON¶

[
    {
        "TableName": "Users",
        "ExcludeMe": true
    }
]

Notes¶

If you specify [[Self]] as the default value for the editor settings, you and your department will be set, so as a general rule, do not specify it.
FAQ: How to use user, dept, and group options in classification columns

Hide the login user/affiliated department setting button by setting the style "display: none;" or similar.
Manage Table: Editor: Column Advanced Settings: Option List: Login User Settings Button

How to Specify ColumnFilterExpressions¶

For information on how to specify ColumnFilterExpressions to narrow down the option list by the value of another column, please refer to the following manual.

Manage Table: Editor: Column Advanced Settings: Option List: Filter (narrow the option list by the value of other columns)

Related Information¶

• Manage Table: Editor: Column Advanced Settings: Option List
• Manage Table: Items: Owner
• Manage Table: Items: Manager
• Manage Table: Items: Class
• Manage Table: Editor: Column Advanced Settings: Use Search Function
• Developer Function: JSON Data Layout: View
• Manage Table: Editor: Column Advanced Settings: Option List: Link
• Manage Table: Editor: Column Advanced Settings: Option List: Lookup
• FAQ: How to use user, department, and group options in class column
• Manage Table: Editor: Column Advanced Settings: Option List: Login User Settings
• Manage Table: Editor: Column Advanced Settings: Option List: Filter (narrow