How to customize columns in Web Portal

Summary: Cayosoft Administrator has centralized columns' settings for the 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.

Applies to: Cayosoft Administrator 8.4.0 or later.

Default columns for Active Directory queries

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

1. In the Cayosoft Administrator Console, navigate to Configuration > Connected Systems Extensions > Active Directory.

2. Open the Customize Columns (Web Portal) section.

3. Review the list of Active Directory objects' queries defined as default:

By default, a predefined set of columns is available for all Active Directory web queries across all Admin Units. You can customize this column set to suit your needs by:

• Renaming columns.

• Adding or removing columns.

• Adjusting the default width of columns.

• Hiding specific columns by default.

To modify the columns, click the ... button next to each setting to open the Properties dialog.

Initially, all columns in the grid have equal width. However, you can override these defaults and set custom widths for each column, using either percentages (%) or fixed pixel values.

RECOMMENDED: Cayosoft recommends saving a copy of the default column set before making changes. This allows you to easily restore the original configuration if needed.

These column settings apply globally to all users accessing the 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 the Web Portal, perform the following steps:

1. In the Cayosoft Administrator Console, open the web query you need to modify.

2. Open the More Options section.

3. Specify columns in the Properties to display setting:

   

4. In the Web Portal, browse for the AD Users query.

5. Review the specified columns:

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

Manual formatting of columns

The recommended method for modifying columns is to click the ... button next to each setting and open the Properties dialog. In this interface, you can:

• Select new properties for columns.

• Modify column display names in the Web Portal grid.

• Adjust column widths and other settings.

For advanced users, columns can also be manually configured using specific formatting syntax:

1. Define the Object Property and Column Name - specify the object property’s LDAP name and assign a display name for the column. For example:

   Copy

   mail~EmailAddress  

2. Set Additional Properties - you can also define column width and visibility by extending the syntax. For example:

   Copy

   mail~Email Address~true~25%  

   • true or 1: Hides the column by default.

   • 25%: Sets the column width to 25%.

   If the visibility parameter (true or 1) is omitted, the column will be visible by default. For instance:

   Copy

   mail~EmailAddress~~25%  

   This will create a visible column named Email Address based on the mail attribute, with a width of 25%.
   

3. Default Width - If no width is specified, all columns will default to equal width in the grid.

Example

To create a hidden column with a custom width:

mail~Email Address~true~25%  

To create a visible column with a custom width:

mail~Email Address~~25%  

How to customize columns in Web Queries in Web Portal

If you need to redefine the columns set for Web Query in the 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 Choose 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.