Manage columns in queries
Manage the display of the columns at runtime by selecting columns and arranging them in a query.
-
Navigate to
or
Work queue queries or
System queries.
The list of queries appear.
- Create a new query or open the query in which to manage columns.
-
Click the
Columns tab.
By default, few columns are selected.
-
Select the check box for the column names that should appear at runtime. For example, select Time pending column to
appear at runtime to search for activities that are pending for a specific period. To display all columns at runtime select the
Show checkbox on the column header.
Use on the column header to reorder the columns.
At runtime, the columns are displayed in the specified order.
-
On the
Display as column list, select
Bar or
Circle for SLA (Activity and Job). (Default: Bar)
When you run the query, the circle or bar appears under the SLA (Activity, Job) column.On upgrading TotalAgility to 7.7.0 or when you import an existing query, the bar option is displayed in the first column without any column heading.
-
By default, the
Width column displays default width for each column. To change the width for
a column, do the following:
-
Select the column name for which to change the width and click
.
Alternatively, double-click the column name to edit.
- For Width, increment or decrement the value.
- Click OK.
The columns displayed and their width configured within the query are applied at runtime. However, you can also specify the width of the columns at runtime when you edit a query within the control. -
Select the column name for which to change the width and click
.
- Click Save.