Scan Forms

 

The scan is a read only, tabular, often summarised version of the record set that you are viewing. 

It is the starting point to the detail of the record.  Select the burger stack in order to view the detail

 

It’s from this detail form that the record can be changed.

 

Data displayed in scan can be sorted by click on the heading of the column you wish to sort by.

 

The sort order depends on how many times you click on the heading.

 

•    Click once it is sorted ascending

•    Click twice and it is sorted descending

•    Click three times and sorting is switched off for that column

 

It is possible to apply sorts to more than one column, in which case the order in which the fields are being used is indicated by a number alongside the column heading.

 

 

 

 

 

‘Filter Sets’ can be added to the scan menu.

 

Filters that are used frequently can be predefined and added to the filter sets for easy querying by the user. 

 

One filter set can be added as a default, when the scan is opened this filter is always used to display the data. 

 

The filter set that is set as default will say [Default] next to it in the list.  The active filter will be marked with a green tick.

                       

          

           

 

Details of any currently applied filter criteria are displayed in the grid header detail.

 

Filter sets are useful for restricting the quantity of returned records by using specific and relevant criteria.

 

Within scan forms many of the columns also support an additional filter function that allows the column content to be searched using a partial or complete string search.

 

For example, typing the word ‘Fork’ would return all of the work orders where the description starts with the word ‘Fork’.

 

           

 

 

Searching ‘lift’ in the same manor would return no work orders as the description does not start with ‘lift’;

 

 

           

 

But this can be overcome by pre-fixing the search string with the % symbol we can tell the filter to look anywhere in the description column for the search word. So in this example changing the word ‘lift’ to ‘%lift’ will now return any work orders where the string ‘lift’ appears anywhere in the description.

 

         

 

If a predefined filter set has been selected, then the standard filter will operate on the records found from the predefined filter set.