Filtering data

Top  Previous 

Filtering Data in grids

The filter row is at the very top of the grid and has a pale yellow background to identify it.  The view screens show a list of items in a grid and these grids have the ability to sort and filter data. Lets take a quick look.

 

 

 

Here we can see that it has been filtered to show items where the Score starts with the text "Accept" . You can apply filters to quickly see just the items that you are interested in and then choose an item to edit.

 

You can see what filters are being applied as they are summarised below the grid on the left had side. You can toggle the filter on and off by checking / unchecking the filter check box.

 

Suggestion_16x16To clear all filters simply click on the Clear link in the below the grid on the right

 

This example uses the SOP screen but the filtering is available in every grid within GuildLink.

 

Suggestion_16x16 To clear the filter in just one column, click on the filter text in the yellow filter row and you will an X to the right, click the X to clear that part of the filter.

 

FilteredGrid

Example of a filtered grid.

 

 

More Complex filtering

By default the filter applies based upon looking for text that starts with the value you enter. You can change this by clicking on the filter icon next to a column that you want to filter. Each column can be filtered differently so you can have where Score Name starts with "Accep" and also where Category equals "Open" its very flexible.

 

SelectFilterType

Example column filter options

 

Even more complex filters

If your needs are even more complex you can click on the filter link (below grid on left).  This will open the "Filter Builder" screen.

 

filetereditor

Filter Builder

 

You can add more filter conditions, remove some existing conditions and choose from even more filter criteria.  By clicking on the criteria you will see more filter options

clip0022

Advanced Filter Criteria

 

 

Sorting

To sort simply click on the column heading. The default sort order is ascending and you will see the following visual cue sortAsc

clip0024

Example column sorted in ascending order

 

To sort in descending order simply click again and you will see the column sort with the following visual cue soryDesc

clip0023

 

example column sorted in descending order