Page tree
Skip to end of metadata
Go to start of metadata

Sorting

In most tables, sorting is performed by clicking the left mouse button on the title of the column along which you want to sort. By default, sorting is done in an ascending way. If you click again on a column that was sorted in an ascending order, it will become sorted in a descending order.

In some tables, several columns can be sorted in a specific order. To do so, hold down the Ctrl key and select the columns in the desired order, without releasing the Ctrl key. Once you have selected the columns, release the key.

Press the Ctrl+F keyboard shortcut to switch a table's column to search mode. Next, type the symbol sequence that you are searching for.

To find the next match of the text, press the Ctrl+Enter keyboard shortcut. If you want to find the previous match, press Ctrl+Shift+Enter.

When the column in which the search is performed is protected from editing, entering in edit mode is done automatically by directly writing the character sequence that you are searching for. After a span of 1.5 seconds of inactivity, the table will automatically exit the search mode.

Filter

In most tables, filtering is performed by entering the criterion by which you will filter specific column(s) in the filter field of the specified column (the grey fields, right below the table's header. If they are not visible, check below how to activate them.) and pressing Enter.

More complex filter criteria are also available, for example:

10.% - all rows that begin with 10 in the specified column will be displayed. In other words, "%" replaces multiple characters.

20.1_ - all records that begin with 20, such as 20.10, 20.11, 20.12  will be displayed, but not 20.10.10. In other words, "_" replaces one character.

< 50 - all that are less than 50

>0.5 AND <=50 - there is an option to use the logical operator "AND"

< 10.11.2004  - it is possible to filter records before a specified date (or after а specified date, if the symbol ">" is used)

< 50 OR >100  - the logical operator "OR" is used

in (1,2,3,4) - enumerating a list of values

 ~ Text% - similar to

!~ Text % - negation


The filter criteria form is

[Operator1] Operand1 [)] [AND|OR Operator2 Operand2[)]]

where the OperatorX is one of

 [=|<>|!=|>|<|>=|<=|~|!~|IN(]

and OperatorX is a number, date, or string, whereas for the Operator, IN is a list of values, separated by a comma.

System menu

If the button is available at the upper left corner of the table, when you select it, the table's system menu will appear. The system menu will give you access to some additional functions. These functions may vary depending on the program product that you are using.

Some of the functions are:

Export

The context menu allows for print preview, preview in editor, saving files in various formats (Text, HTML, RTF, XLS, CSV, VCLDBIFF), as well as their visualisation in MS Excel and OpenOffice.

Settings

To be able to change some of the settings, you must first disable the Use default settings option.


Columns

When you open the Columns tab, the column list will be shown. Mark or unmark each option to indicate whether the column will be visible or not. If you want to rearrange the columns, you can use the  and buttons.


For each column, you can set the following parameters:

  • Code
  • Name
  • Type
  • Client UIC
  • Client
  • Period
  • Note
  • Method
  • Audited entity
  • Completed

Once you are ready, click the Save button to save the changes.

  • No labels