Working with Data Tables in the User Interface

There are various options available for you to customise how information is displayed in data tables on a page within the .wms webUI. All data tables in the .wms webUI have the following customisable options:

Availabe options to customise data tables.

By default, only 10 rows of data are displayed in a data table on a page. You can choose to display more rows.

  1. Click Show 10 rows to display a drop-down list of options.

    Select to display more rows in a data table.

  2. From the drop-down list of options, select the number of rows you wish to display on a page.

    The data table displays the number of selected rows and your selection is reflected for the option.

    The button reflects your selection for the number of rows to display.

By default, all columns for a specific data table are displayed. You can choose to not display some of the columns. The column options depend on the data being displayed.

  1. Click Select Columns to display a list of the current columns.

    Select columns to not display.

  2. Deselect the columns you do not wish to be displayed in the data table.

    The data table displays only the selected columns. Deselected columns are not highlighted in the options list.

    Deselect columns to not display them in a data table.

The information contained in data tables can be exported to the following formats:

  1. Click Excel Export to export the information in a data table to a Microsoft Excel file.

  2. View and/or download the file.

  1. Click PDF Export to export the information in a data table to a PDF file.

  2. View and/or download the file.

Click any column heading to sort the column in ascending or descending order, then click the column heading again to reverse the order.

Tip:   ENG 6705 At this stage, all columns display the ascending or descending icon, even if they cannot be sorted. This will be fixed in a future release.

If the information in a data table displays over a number of pages, use the page navigation located in the bottom right-hand corner of a page. You can go to the next and previous pages or to a specific page, as needed.

Find specific information in a data table using the Search field.

As you type the first 3 characters of your search text, the data table filters to display results based on what you have entered. The data table is further filtered as you keep typing your search text.

The more unique your search text the fewer results are displayed in the data table. This lets you find exactly what you want.

Some pages and/or reports offer extra filters where you can show all or a subset of the list. These filters are usually displayed above the data table. Click an option to filter the data table by a selection.

See also