5 Filtering Lists
From TrueERP wiki
Filtering Lists
Do you know how to filter a list or report to show only specific details?
Filters and Queries can be accessed and created from within reports and lists, across all modules. There is no limit to the number of columns and data you can filter on at the same time, but keep in mind the difference between an "And" filter and an "Or" filter.
Right mouse click in any number of columns or fields you wish to filter and a range of options will pop up. Then left mouse click on the desired filter.
And filters to name and something else
Or filters to name or something else
Partial filters part of a name/option/word
Exclude excludes something eg. date range
Bracket a bracket can be created with a filter within it then a further one created. To be used when you require a
calculation to be done, before another command
When a filter has been created, right mouse click and choose preview to view details.
If you wish to clear a filter you have created, right mouse click and choose Clear Filter from the options.
If the filter you have created is one that would be re-used, this can be saved by right mouse clicking and selecting
'Add Custom Filter', (Name and save it), the custom filter will then run automatically when selected in the future.
You can add further filters as you require.
Creating a "Default Custom Filter" will open that list with this filter active everytime.
A quick a easy way of filtering is to select the data required, then hold down and press (at the same time)
"Ctrl + Shift + N"
