# Self Service Portal Tables ## lf Service Portal Table {% hint style="info" %} ### Before you start You must have **Self Service Portal Setup** selected in the Admin tab of your **General Access Security Role**. {% endhint %} 1. Select Menu ![](https://1375663122-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FhlW9jKl7dcDggHAPhNU9%2Fuploads%2F2fF8hWfcUd9X58kFa7cW%2FScreenshot%202024-03-14%20at%203.44.47%20PM.png?alt=media\&token=52b922ac-5416-4c46-ba64-9dc38aaf7748) , then **Admin**, then **System Administration**. The System Administration window is displayed. In the Explorer pane, expand **Self Service Portal**. 2. Select **Self Service Portal Tables** to display the window. 3. At the top of the window you can see a box containing a list of all of the sets of tables that are held on your system. Initially, you will only see a single **Default** set. Beneath this there are three more boxes; **Tables** contains all of the tables on the Self Service Portal; **Available Columns** contains all of the columns that can be held on the selected table; and **Selected Columns** lists all of the columns that currently appear in the table on the Self Service Portal. ### **To create a new set of tables** 1. Click ![](https://1375663122-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FhlW9jKl7dcDggHAPhNU9%2Fuploads%2FdmDfochF01QmA8pRCJHu%2FScreenshot%202024-03-14%20at%203.58.20%20PM.png?alt=media\&token=35efa853-1679-4b9a-a18c-6e85f2d19bfa)beneath the box at the top of the window. This will create a default set of portal tables. 2. If you want to copy a set of tables that you have already configured, select the set name, and then click ![](https://1375663122-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FhlW9jKl7dcDggHAPhNU9%2Fuploads%2F2FT3mtG4OS0zBrjead08%2FScreenshot%202024-03-14%20at%203.56.30%20PM.png?alt=media\&token=3f6403e7-d0aa-4957-b2d9-06de91d4d0da)
### **To modify an existing set of tables** 1. Select the set in the top box to highlight it. 2. Select the table you want to modify in the **Tables** box. You will see a set of **Home Pages**, with the **Default** and **Classic** layouts; and a set of **Search Results** tables. Some of the items will represent groups of tables, as indicated by the ![](https://1375663122-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FhlW9jKl7dcDggHAPhNU9%2Fuploads%2FBFtGXjrcwqdbEXqlNRIO%2FScreenshot%202024-03-14%20at%203.26.17%20PM.png?alt=media\&token=0bb5429c-2335-47be-b716-0ed0a87bd7a8)sign. Expand the group by selecting the symbol.
3. When you select a table, all of the columns that could appear in that table are displayed in the **Available Columns** box.
This list is made up of all of the fields for the entity, or any linked entities. Some of the entries in the box will display a small arrow to their right ![](https://1375663122-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FhlW9jKl7dcDggHAPhNU9%2Fuploads%2FdONu1ag5fVhvX3vzwXG3%2FScreenshot%202024-03-14%20at%203.29.22%20PM.png?alt=media\&token=d80e115f-9e5d-4e12-969f-fd8618dbbe45). This indicates that these are categories, and there are lower tiers from which you can select. Double click on the category title to see the items within it.

Exploring the Assigned Group Category

You will notice that the category name appears in the banner at the top of the box, with an arrow ![](https://1375663122-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FhlW9jKl7dcDggHAPhNU9%2Fuploads%2FKX076YRrSnnjoFOOAYlw%2FScreenshot%202024-03-14%20at%203.29.03%20PM.png?alt=media\&token=2b2de1d4-d080-4aef-a97e-2962d2eb0d7d). Click on the arrow to return to the top level list.
4. For some of the tables, you will also see some buttons listed. These will generally also appear in the Selected Columns list, and will be mandatory, so cannot be removed. They do not have a Display name, as they are not columns as such.
5. To select a column, you can either double click on it in the **Available Columns** box, or select it and click **Add**. Alternatively, you can click and drag it into the **Selected Columns** box. {% hint style="info" %} **Select your columns with care, noting the following:** * Ensure that you do not introduce a conflict into your results. For example, only *open* requests are displayed in the Self Service Portal, so you should avoid selecting any of the Closure Analyst or Closure Group items, as this will instruct the system to find only *closed* requests, leading to blank search results. * Including extension fields in search results can slow down performance. * If you use the Catalog Portal, do not use column names that consist only of numbers. You can include numbers in the title, but it must also contain letters. * Do not use special symbols in column names. * Ensure that all of the columns can be accommodated in the table. If you are using the Default home page view, which shows two tables side by side, we advise a maximum of six columns for each table. {% endhint %} ### Renaming Columns 1. To rename a selected column, click on it and select ![](https://1375663122-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FhlW9jKl7dcDggHAPhNU9%2Fuploads%2FeuvmyugtHSYlapAthl6H%2FScreenshot%202024-03-14%20at%203.34.45%20PM.png?alt=media\&token=e99a8aaa-18ee-49eb-b0dc-2372a3e97ddb) 2. In the **Rename** dialog box, type the **Display Column Name** you want to appear in the table on the portal. You cannot change the Default Column name, as it is used in the database, and may be referenced elsewhere.
{% hint style="warning" %} * When you rename a column, bear in mind that **the column width will adjust to accommodate the length of the column names.** The table width will also expand to accommodate the wider columns, if necessary, which will have an impact, particularly if your home page is the default view, which shows two tables side by side. In order to avoid distorting the page layout, you should keep the column names short. * If you insert multiple spaces in a column name, it will be displayed as a single space. {% endhint %} ### Moving and Paginating Columns 1. To change the order in which the columns are displayed in the table, click on the columns and use the buttons, or click and drag the items you want to move.
2. You can choose whether you want to paginate the results
Paged?

This checkbox is selected by default. Leave selected to display the results in "pages", in which a specified number of items are displayed. If there are more entries in the table than can be displayed on a single page, pagination buttons appear beneath the table in the portal to display further entries.

Deselect to display a scroll bar, enabling the user to scroll down the list of entries.

Page Size

This field is only visible if Paged? is selected.

Use the drop down list to select the number of entries you want to display on each page

### Sorting Information
Sort By

Use the drop down list to select the column on which you want to sort the table results.

The drop down list contains all of the columns in the Available Columns list. The Sort By column does not have to be in the Selected Columns. It must be at the top level; you cannot sort on extension or lower level fields.

If you select to sort on a search field, the results are grouped by item, rather than in alphabetical order.

Desc/AscUse the drop down list to choose whether the information is sorted in descending or ascending order.
3. When you have finished, select ![](https://alemba.help/help/10.0/content/resources/images/save%20button.png). {% hint style="warning" %} **Check your Work** Select/confirm the set of portal tables that is being used in your self service portal system to ensure that your settings are displayed on the correct portal System and thet you have achieved your desired results. 1. Verify the My Option that are on the Portal System you are updating in the **Self Service Portal Systems Systems** Menu. 2. Log into the portal and check your changes. {% endhint %}