Using the workbench

The workbench appears throughout the system.

For example, when you search for employees, or when you select and run a query, the results are displayed in a workbench. The workbench is a list, with column headings for the fields across the top, and each record is one row. Data is displayed like this:

Using the workbench

The workbench is like a spreadsheet and you can arrange how you want to display the data.

Moving columns

You can rearrange the columns and choose the order in which you want to display them. Move the pointer onto the column you want to move, hold down the left mouse button, drag the heading to where you want it to be, and then drop it. Arrows are displayed to show where the column is going to be dropped.

Sorting data

You can sort the data in alphabetical or reverse alphabetical order.

For example, to sort the results alphabetically based on the employee’s surname, click the Surname column header.

Using the workbench

Data sorted in acending alphabetical order (A-Z) is indicated by an up-arrow in the column header.

To reverse the current sort order, click the Surname column header.

Using the workbench

Data sorted in descending alphabetical order (Z-A) is indicated by an down-arrow in the column header

Grouping data

To group the data based on common columns, drag the required column header to the grouping area.

Using the workbench

For example, dragging the Department column header into the grouping area arranges employees belonging to the same department into groups.