Common functions:Filter Data (Queries)

From Logilys
Revision as of 15:49, 31 May 2011 by Ncarrier (talk | contribs)
Jump to: navigation, search

Template:Header Common Functions

Introduction

The filter tool allows to display on the screen elements that have something in common.Whether it is all the clients living in the same city, all the transactions of a golf tournament or all the GL accounts starting with 40. This tool is available in all the software managements and is represented by this icon: Button Filter.png.


By clicking on the Button Filter.png button, the following menu will appear.
Filter information 001.png
If you choose the option "Add filter", you will have to name it and it will then be found in the "Current filter" drop-down menu.

Temporary filter and current filter

Temporary filter

The option Temporary filter" displays the filter screen directly.


Current filter

The option "Add filter" allows to name a filter that is about to be created.


When the filter is created, it is then available in the "Current filter" drop-down menu for further use.

"Special" tab

Selection

Characteristics

Links

"Fields" tab

Types of fields

Use of operations

is blank

is equal to ...

is between ? and ?

is in the list ...

is greater or equal to ...

is smaller or equal to ...

is true

contains ...

begins with ...

ends with ...

Others

List of choices

Example of simple filter

Example of a two-condition filter

Condition (AND) vs (OR)

"Query" tab

Process to filter several conditions