Introduction

The CoreOne Admin User Interface v2 has new dynamic data tables that offer dynamic sorting and filtering. Based off the environments configuration - such as configured attributes - the data tables will show additional columns. By default, the data tables show predefined columns and the user has the option to add additional columns.

The CoreOne Admin User Interface offers the option to define what columns are shown to the user by default and which additional columns should be offered. This is a per table definition. This how to describes how to achieve this with the example of the Core Identity List.

Step 1 - Locate the configuration file

The configuration file is located in the following directory:

C:\ProgramData\itsense\Configuration\AdminUI_Customer_DataTableConfiguration.json

Open the file and locate the following section:

{
  "Id": "CoreIdentityDataTable",
}

Step 2 - Determinate the columns to show

The easiest way to find out what columns are available is to read the available fields from the API by calling the following URL:

{{urlv2}}/latest/appcustomer/servicedmcore/coreidentity/fields

This will return your a list of available elements. Find yours and note down the appropriate system_name (line 10) of your element.

{
    "display_name_parts": [
        {
            "value": "E-Mail (HR)",
            "kind": "PlainValue"
        }
    ],
    "name": "E-Mail (HR)",
    "type_name": "Email",
    "system_name": "ext_e_mail_hr",
    "type_full_name": "System.String, mscorlib",
    "category": "Module.DM.IdentityManagement.PersonalData",
    "is_collection": false,
    "depth_level": 0,
    "kind": "AttributeValue",
    "updateable": true
}

Step 3 - Define the default columns to show

Add the following section to configuration file to define the columns you would like. Simply add all system_names of your desire:

{
  "Id": "CoreIdentityDataTable"
  {
    "DefaultColumns": ["readonly_display_name", "readonly_email", "core_identity_type.name", "valid_from", "valid_to", "ext_e_mail_hr"]
  }
}

Step 4 - Exclude any columns you might not want to show

If you would like to exclude certain columns and make sure users can not select them, you can also configure that by adding another section (Line 5):

{
  "Id": "CoreIdentityDataTable"
  {
    "DefaultColumns": ["readonly_display_name", "readonly_email", "core_identity_type.name", "valid_from", "valid_to", "ext_e_mail_hr"],
    "ExcludedColumnsToShow": [ "ext_e_private_banking_number" ]
  }
}