Managing Columns in a Table
Most tables show only a selection of the fields from the underlying database. You can configure these tables to show as many or as few of the available fields as you choose. One reason to change the displayed fields is to perform searches or filtering on the data—searches and header filters are limited to the fields currently visible in the table (simple filters and advanced filters are not limited only to visible columns, as described in Adding a Simple Filter and Creating an Advanced Filter.
Your choice of columns to display, and their positions in the table, are both ‘sticky’ (that is, persist when you go to look at a different page and then return to the one you modified). Of course, each person can set these preferences independently (they are maintained for each login account).
Note:You cannot change the width of individual columns. Column width re-sizes dynamically to suit the width of your browser window.
To manage columns in tables (or lists):
1. | To change the order of visible columns: |
a. | Choose which column you want to move. |
b. | Use your mouse to drag that column header left or right along the row of column headers. |
As you move far enough, a pair of small vertical arrows appear to indicate the current target gap between other columns.
c. | When your preferred spot is highlighted by these arrows, drop the column header you are dragging. |
The table is redrawn with the column in your new position. You may repeat this process as often as required. The order you set is maintained for this table until you next change it.
2. | To add a column to the table: |
a. | From the set of icons above the right side of the list, click the column chooser icon: |
The Choose columns palette appears, floating over the table. You may drag the palette by its title bar to any convenient location.
b. | In the palette, scroll to locate the desired column header, and drag it out of the palette to the header row on the table. |
As when you reorder the columns, the current target location for dropping the new column is indicated by two small vertical arrows highlighting the gap between existing column.
Tip:Column names are arranged alphabetically. If a table includes properties from many different database objects, the column names in the Choose columns palette are grouped under blue titles that identify the underlying object.
Note:If a database column is not listed in the Choose columns palette, you cannot display it in a list in a saved view of the page. For some objects, additional columns are available if you wish to prepare a custom report.
c. | Repeat for any additional columns you want to add. |
d. | When satisfied, you may close the Choose columns palette in either of these ways: |
• | In the top right corner of the palette, click the X close icon. |
• | Above the list, click the column chooser icon again. |
3. | To hide a column, removing it from the list: |
a. | From the set of icons above the right side of the list, click the column chooser icon: |
The Choose columns palette appears, floating over the table. You may drag the palette by its title bar to any convenient location.
b. | Drag the chosen column header from the table and drop it anywhere within the Choose columns palette. |
The column disappears from the table, and the column header is inserted in alphabetical order into the Choose columns palette.
c. | Repeat as required, and then close the palette as described above. |
4. | To reset a table to its original, factory-supplied configuration (including visibility and ordering of columns), click the restore defaults icon: |