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.
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 |