Tabular forms
Sorting of columns by default.
-
Go to [Selected entity] > button [More] > button [Setup…].
-
In the detailed form, click the button [Edit] to switch to edit mode.
-
Enter in the field “Additional parameters”:
{ "order": [ { "field":"a", "desc":"b" }, ... ] }
The field “field” contains the name of the field by which sorting is performed.
The field “desc” contains the value “false” in the case of sorting from smaller to larger, and “true” in the opposite case.
-
Enter values instead of a and b.
If there are several conditions for sorting, then the rows are listed separated by commas inside the “order” element.
-
Click the button [Save] to save the changes or the button [Cancel] to exit edit mode without saving.
Displaying table rows by condition.
-
Go to [Selected entity] > button [More] > button [Setup…].
-
In the detailed form, click the button [Edit] to switch to edit mode.
-
Enter in the field “Additional parameters”:
{ "hardFilter": [ { "levelup": false, "operand": { "field":"a", "path": ["a"], "op": "b", "value": ["c", ...] } }, ... ] }
The “level up” field always contains the value “false”. The value “true” is used for more complex queries containing additional conditions for fields, and is mainly intended for internal use.
The field “field” contains the name of the field by which the filtering is performed.
The “path” field contains a value if several tables were used when creating the entity. For simple queries, this field contains a value similar to the value in the “field"field.
The “op” field contains the operation to be performed. The values in this field can be:
- “EQ” - equal;
- “NEQ” - not equal;
- “G” - more;
- “- “F” - calling a function with the name corresponding to the value in the “field"field;
- “FC” is a special parameter for internal use. It is not used in this manual;
- “EQF” - compares the value from the” field “field with the value from the” value “field;
- " FEQ " - a special parameter for internal use. It is not used in this manual;
- “L” - less;
- “GEQ” - greater or equal;
- “LEQ” - less or equal;
- “C” - occurrence of a substring;
- “ISN” - is equal to 0;
- “ISNN” - not equal to 0.
- “DUR” - set for time and dates. Checks whether the date or time falls within the last period. The period is specified in the format Durations.
The “value” field contains the value at which the condition (operation) will be executed.
-
Instead of a, b and c enter:
- instead of “a” - the name of the field (not the title) by which you want to filter;
- instead of “b” - an operation, when the condition is met, the filtering will be performed;
- instead of “c” - the value that will be used by the operation as a border.
If there are several conditions for filtering, then the lines are listed separated by commas inside the “hard Filter” element.
If there are several values that will be used by the operation for filtering, then the rows are listed separated by commas inside the “value” element.
-
Click the button [Save] to save the changes or the button [Cancel] to exit edit mode without saving.
The “Report form” element allows you to use frequent values when filtering.
-
Go to [Selected entity] > button [More] > button [Setup…].
-
In the detailed form, click the button [Edit] to switch to edit mode.
-
Enter in the field “Additional parameters”:
{ "report_properties": [ { "preset": [ "a", ... ], "field": "b" }, ... ] }
-
Instead of a and b, enter:
- instead of “a” - a frequently occurring value to search for (or several if necessary);
- instead of “b” - the field by which the search will be performed;
If there are several fields, then list them separated by commas inside the “report_properties” element, for example:
" report_properties ": [ { "preset": [ "English", "Russian" ], "field":"language" }, { "preset": [ "Action", "Drama" ], "field":"category_name" } ]
If the field that is being searched for is a foreign key: specify the frequently occurring values along with the key, for example:
"report_properties": [ { "preset": [ { "key": 1, "value": "English" }, { "key": 2, "value":"Russian" }, { "key": 3, "value":"German" } ], "field":"language" }, { "preset": [ "Action", "Drama" ], "field":"category_name" }, ... ]
-
Click the button [Save] to save changes or the button [Cancel] to exit editing mode without saving.
The element for filtering is added according to the data type of the field.
The “Article” element displays tabular forms in the form of articles.
-
Go to [Selected entity] > button [More] > button [Setup…].
-
In the detailed form, click the button [Edit] to switch to edit mode.
-
Enter in the field “Additional parameters” :
{ "articlePageSize":"a" }
Instead of “a”, specify the number of displayed articles.
-
Click the button [Save] to save the changes or the button [Cancel] to exit edit mode without saving.
-
Go to [Selected entity] > button [More] > button [Setup…].
-
In detailed form click the button [Edit] to switch to edit mode.
-
Enter in the field “Additional parameters”:
{ "reload_interval": "ms" }
Instead of * “ms”*, specify the number-the interval (in milliseconds) with which the page will be updated.
-
Click the button [Save] to save the changes or the button [Cancel] to exit edit mode without saving.