Skip to content
Logo

Data search

Searches for tables are done using sorting and filtering.

`` `{= html}

Sorting data ----------------- One column at a time ---------------- 1. To sort the contents of the table by column, click on header of the column of interest with the left mouse button.! [Sorting a table by one column] (https://abris.site/docs/img/column_sorting_3.png) 2. When you click it again, the sorting is inverted to the opposite.! [Reverse sorting a table by one column] (https://abris.site/docs/img/column_sorting_4.png) By several columns --------------------- - Sometimes you need to sort data by several columns, for example, if the data in the column is duplicated.In this case, their selection is carried out taking into account several criteria.1. To sort the contents of the table into several columns, hold down the Shift key and left-click to select the required columns.`` `= {html} <! - [Highlight a row in a table] (Select-row) ->

Highlight a row in a table

Display selected row when changing sort

When changing the sorting, you can select a row, so it will not be "lost" during further manipulations.

  1. Clicking on the column heading of the table sorts the rows according to the values ​​in this column.A repeated click of the mouse switches the direction of sorting.

When changing the sorting, the line selected by the user will remain in expanded form.

Display the selected row when changing the filter condition

In addition to sorting, you can also filter data by various criteria.

  1. Filtering parameters are set in the field that can be displayed by clicking on the filter icon to the right of the column heading (or by clicking on the "Contextual Actions" button in the upper right corner of the program and selecting "Table Filter"), and then click on the line that appears under the heading and select " Apply. "

When the filter condition changes, the user-selected string remains in expanded form (provided that it falls under the filter criteria).

Display selected row when updating data

When updating the contents of the table, the row selected by the user remains in expanded form.

Сохранение выделения выбранной строки при обновлении
данных

`` `{= html}

Filtering and searching ------------------ Searching a row throughout the table ------------------------ ---- 1. In order to use the search, you must enter a query in the search line in the upper right corner of the page.2. In order to reset the search, you must delete the entered query and click on the update button.> Search is carried out on all contents of the table.! [Search for a row throughout the table] (https://abris.site/docs/img/search_by_table_1.png) Search for a row in columns --------------------- --- 1. In order to use the column search, you need to refer to the table filters.In the upper right corner of the page, open the menu and select "Table Filter" or click on the filter icon to the right of the column heading.After that, a new row will appear under the heading of the table.! [Opening the filtering panel] (https://abris.site/docs/img/search_by_column_1.png) 2. Then you need to click on the empty cell under the heading of the desired column.The window that may open may contain fields for entering a value, selecting one or more of the list of available values ​​in a column, and selecting a date.! [Functions for searching rows by columns] (https://abris.site/docs/img/search_by_column_2.png) 3. Next, click on the "Apply" button.- If you need to create another filter in the same column, you must click on the "Add Condition" button.- If you need to create another filter, but in a different column, then you must repeat all the above steps for the new column.! [Filtering strings by selected conditions] (https://abris.site/docs/img/search_by_column_3.png) 4. To reset the search, click on the filter and click on the "Reset" button.5. In order to turn off the search by rows, you need to open the menu in the upper right corner of the page and select \ "Filter table (or click on the filter icon to the right of any column). Dynamic filtering for reporting forms -------- --------------------------------- For tables arranged in a certain way, it is possible to connect dynamic filtering of content by certain values. it’s more convenient than the standard question from the aesthetic side and is more visual.! [Filtering parameters in reporting forms] (https://abris.site/docs/img/dynamic_filter_1.png) 1. Filters are controlled through a drop-down list for each parameter, which greatly facilitates input.Also, depending on the type of data, additional options may be available.In particular, the following options are available for fields containing dates: - by clicking on one of the date elements (day, month or year), you can enter the desired value manually; - clicking on one of the elements yesyou, and then on the "switch" element (up / down arrow) you can increase and decrease it in steps - one;- clicking on the "down arrow" element opens a form in which additional features are available for switching date elements with arrows.Clicking on the dot icon allows you to automatically select today's date.Depending on the type of data inside the field, the set of options may vary.2. The selected parameters will automatically start filtering.! [Setting filtering options for reporting forms] (https://abris.site/docs/img/dynamic_filter_3.png) `` <! - [`Different search tools for a column depending on the type of data in the column`] (Different- search-tools) -> `` {= html} `` {= html} <! - [Calculation of totals for columns depending on the type of data displayed] (Calculation-of-totals) ->

Calculation of total values ​​for columns depending on the type of data displayed

  1. To calculate the totals, there is a function "Totals", available in the "Contextual Actions" menu in the upper right corner.

After its inclusion, a line is displayed under the table with a choice of attributes for calculations.

For numbers

For numbers, there are options for calculating the sum, arithmetic mean and number of values.

Подсчет суммы, среднего арифметического и количества значений для
числовых колонок

For text and other fields

For text, there is only a count of the quantity.

Подсчет количества записей для текстовых и прочих
полей

Sort rows by values ​​from additional columns

Sorting by additional columns is carried out similarly to sorting by other columns (see. Sorting data ).

Filter rows by values ​​from additional columns

Filtering by additional columns is carried out similarly to filtering by other columns (see Searching a row by columns ).

Counting the total number of rows by filtering

When filtering, in the navigation element of the table responsible for displaying rows, the value of the values ​​suitable for the filtering conditions is calculated.

Отображение в элементе навигации количества строк, соответствующих
условиям
фильтрации