QBE Approach in LUI Lists

QBE (Query by Example) Approach in LUI Lists

QBE is the most apparent and fast way to set the conditions for searching the required rows in LUI lists. As a result, the user gets the rows corresponding to the text patterns specified in the fields, where the restrictions are imposed. Setting the conditions this way makes them coherent and easy to read and understand by the users. Moreover, once set the conditions can be easily modified and saved with a unique name for easier re-use when needed.

Major Principles

QBE can be used in literally any of LUI lists. To enter QBE mode press F7 and click "Change search conditions" button on the list's toolbar. This clears all the data in the displayed form, and the user can type in any field of the row or rows displayed. The inputted text is interpreted as one or several conditions (predicates) applied to the column where the text was typed. The conditions in the same row are combined by AND. The conditions from different are combined by OR. To apply the set conditions press F8 or click "Run query" button.

Example:

This condition is interpreted as:

Show all contracts signed in 2011 and having numbers containing three zeros as well as contracts with legal entities signed prior to 2011, and in addition, all the contracts for three objects exactly.

This will be translated to the following SQL predicates:


contract_no like '%000%' and contract_date>=to_date('01.01.11','DD.MM.RR')
or contract_date<to_date('01.01.11','DD.MM.RR') and legal_status='ЮЛ'
or n_object=3

Predicate language

Any cell in QBE mode can contain a condition text (predicate), which is specified in one of the following ways:

Examples of constructing conditions:

Try it:

Agreements

To enter QBE mode press F7 and click "Change search conditions" button on the toolbar
To apply the set conditions press F8 or click "Run query" button

Saved conditions

All QBE conditions (along with the sorting order) can be saved in users' configurations and easily re-used when choosing a saved configuration from the list of all such configurations. Once the configuration is selected, all previously set QBE conditions are deleted and new conditions are applied. After selecting the configuration, the user can modify QBE conditions and save them replacing the current configuration or as a new one if needed.

← Home