Skip to content

Extended Column

Overview

Adds "Column" such as "Class Column" to department management, group management, and user management.

Usage Notes

Incorrect settings may cause Pleasanter to become unusable, so please test thoroughly before use.

How To Set Extended Column

Create a CustomDefinitions folder in .¥pleasanter¥Implem.Pleasanter¥App_Data¥Parameters¥, create a text file with the column you want to extend using the following syntax, and restart IIS. Make sure to name the file Column.json.

{
    "Users_ClassA": {
        "LabelText": "ClassA",
        "GridEnabled": "1",
        "EditorEnabled": "1"
    },

    "Users_DateA": {
        "LabelText": "DateA",
        "GridEnabled": "1",
        "EditorEnabled": "1"
    },

    "Groups_DescriptionA": {
        "LabelText": "DescriptionA",
        "GridEnabled": "1",
        "EditorEnabled": "1",
        "FieldCss": "field-wide",
        "UpdateAccessControl": "ManageTenant"
    },

    "Depts_CheckA": {
        "LabelText": "CheckA",
        "GridEnabled": "1",
        "EditorEnabled": "1"
    }
}
Column name Description
LabelText Specify the name displayed of the column.
GridEnabled Enter "1" If you want to display it on the list screen. If you do not want to display it, this line is not necessary.
EditorEnabled Enter "1" If you want to display it on the editing screen. If you do not want to display it, this line is not necessary.
UseSearch Specify true if you want to enable the search function.
ChoicesText Enter the options if you want to make it a multiple-choice format. Use \n to separate the options.
FieldCss Set the "Input Column Style" (normal, wide, markdown). Specify one of "field-normal", "field-wide", "field-markdown". If you do not want to change the style, this line is not necessary.
CreateAccessControl Specify "ManageTenant" if you want to restrict this field value to only be set by the tenant manager when creating a new field. If you do not want to restrict this, this line is not necessary.
UpdateAccessControl Specify "ManageTenant" if you want to restrict this field value to only be changed by the tenant manager when updating a field. If you do not want to restrict this, this line is not necessary.
ReadAccessControl If you want to restrict this column value to be visible only to tenant manager, specify "ManageTenant". If you do not want to restrict this, this line is not necessary.

Changing the Access Restrictions of Standard Columns

In addition to extended columns, you can write the standard columns of users, departments, and groups (login ID, name, department name, and so on) in Column.json. Specifying "ReadAccessControl", "CreateAccessControl", or "UpdateAccessControl" for a standard column changes the access restriction of that column. You can also use it only to change access restrictions, without adding columns.

The following example prevents general users from viewing the login ID, name, and user code of other users.

{
    "Users_LoginId": {
        "ReadAccessControl": "ManageTenant"
    },
    "Users_Name": {
        "ReadAccessControl": "ManageTenant"
    },
    "Users_UserCode": {
        "ReadAccessControl": "ManageTenant"
    }
}

Specify the key as "table name_column name". The table name is "Users" for users, "Depts" for departments, and "Groups" for groups. You can write them in the same file as the extended column settings. For an example of relaxing the default restrictions, see "FAQ: How can I display the date of birth and gender when managing users?".

You can specify the following values.

Value Description
ManageTenant Allows only tenant managers.
ManageService Does not allow any users, including tenant managers.

Restricting the viewing of a column applies not only to the screens but also to the API and server scripts.

Function How columns you cannot view are handled
Screens (user, department, and group management) Not displayed.
API (getting users, departments, and groups) Not returned.
Server Script (users, depts, and groups) The properties remain and their values are null (version 1.5.10.0 and later).

Caution

  • Do not specify values other than "ManageTenant" and "ManageService". For users, departments, and groups, no user, including tenant managers, will be able to view the column.
  • For the access control of columns of time-limited tables and record tables, refer to "Column Access Control" to set it.

Supported Versions

Supported versions Body
1.5.10.0 and later Applied the viewing restrictions of standard columns to server scripts as well