Inepro Back Office Suite, Technical Manual

Page: 118 / 248

110 - Inepro Back Office Suite
Steps
How to build an advanced filter
If viewing a selection of the data in the database, a filter is often needed.
With a filter, decide which data is not needed and filter it out.
In this example the 'Paper Prices' table is used.
To build a filter press the Build Filter button , this screen will pop up:
Click on 'press the button to add a new condition'.
Click on the field name to select another.
We have chosen 'Product Code'.
Set the operator to 'like' and the condition to '%8%'.
Like '%8%' means search for everything with an 8 in the
string.
The % is a wildcard.
The view shows three product codes: '08', '20060306152528' and '20060306152809' which all have an '8'.
Below the filter bar to indicate a filter is used can be seen. The column(s) that the filter applies to has a blue arrow in stead
of a black arrow.
Notice that the product group has to different values 'special' and 'Print'.