How to customize columns in Web Portal

Published: 06/08/2018

Applies to: Cayosoft Administrator 8.4.0 or later.

Summary: Cayosoft Administrator has centralized columns' settings for Active Directory Web queries shared among all Admin Units. You can customize these general columns' settings or you can redefine them for certain Admin Units.

---

Default Columns for Active Directory queries 

To see which columns are defined as default for Active Directory Web queries perform the following steps:

1. Home > Configuration > Connected Systems Extensions > Active Directory.
2. Open the Customize Columns (Web Portal) section.
3. Here is the list of Active Directory objects' queries defined as default:

This set of columns is defined by default for all Active Directory Web queries in all Admin Units. You can modify them as you like: change column names, add more columns, or remove some of them, change default column's width and hide some columns by default. To change the columns, click ... near each setting to open Properties to display dialog.

By the way, each column has equal width in the grid, but you can change the defaults and set custom width for each column in % or pixels.

We recommend to save somewhere the default columns set, so you can restore defaults for your Web queries.  

These settings will apply to all users in Web Portal.

How to define columns set for a single Web query in the Admin Unit

If you need to redefine the columns set for some Active Directory Web query for all users in Web Portal, perform the following steps:

1. In Cayosoft Administrator open Web query you need to modify
2. Open More Options section
3. Specify columns in Properties to display setting:

4. After that in Cayosoft Web Portal browse for Active Directory -> Ad Users query
5. You will see the specified columns: 

 If you need to restore default columns, you can always come back to Cayosoft Administrator, open this Web query, and select Use Default Columns for AD Users query

 

Columns manual formatting

The recommended way to change the columns is to click ... near each setting to open Properties to display dialog. Here you can select new property and a column and modify its display name in the Web Portal grid, width, and other properties.

Also, you can use manual formatting for the columns:

To set the column for Web query specify object property LDAP name and column name for it - for example: mail~Email Address.

It's also possible to specify column width and make the column invisible by default: mail~Email Address~true~25%. True or 1 means that the column will be invisible, 25% defines column width.

If the third parameter, true or 1, is not defined, the column will be visible in the Web Portal. In this example new column with display name Email address based on AD attribute mail will appear in the grid, with 25% width, visible by default: mail~Email Address~true~25% or mail~Email Address~~25%).

If the width is not set, all columns will have the same width. 

 

How to customize columns in Web Queries in Web Portal

If you need to redefine the columns set for Web Query in Web Portal only for the currently logged in user, perform the following steps:

1. Select the Web Query.
2. Click the button at the upper right corner and click Chose columns:
   
3. Select the columns that you need to display in the grid for the selected Web Query:
   
4. To get the default set of columns click Reset.