📊 Feature Description
Menu: Nástroje → Uživatelské dotazy
User queries allow you to invoke a specialized SQL query,
which can retrieve virtually any analysis and data from the ABRA Flexi system.
💡 This functionality is available only in the ABRA Flexi Premium edition.
Query results can be exported to:
🧾 XML
Creating queries requires knowledge of SQL.
If you need a custom report, please contact customer support or the sales department.
▶️ Running a Query
In an open table or form, click the button
located in the top toolbar of the current record.
A list of available queries will appear.
Each query is listed with its abbreviation and name.
Select the desired query and click "Finish".
💡 This will run the query and display the resulting data on screen according to its configuration.
🧱 Main Panel
Clicking the "New" button opens the form for creating a new query.
__________________________________________________________________
⚙️ Details
On this tab, you can specify the following properties:
Private – determines whether the query is accessible to all users or only to the author.
Primary Form – affects access rights and links to the original record.
Places of Use – specifies which agendas the query will be available in.
__________________________________________________________________
🎯 Parameters
Each query can have input parameters defined, which prompt the user for values before the query runs.
The entered values are then inserted into the SQL query at the designated location.
The value entered by the user is inserted into the query at the designated location. This location is marked by clicking the "Insert Parameter" button.
Each parameter has a defined type that determines how the value is entered. For example, if you use the type "Current Record", the system automatically fills in the ID of the current record — useful, for instance, for analyzing sales of a specific price list item.
"Cardinality N" means that the parameter allows multiple values to be entered at once (e.g., selecting multiple companies or warehouses).
Example:
If "Cardinality N" is unchecked → the parameter accepts a single value.
If "Cardinality N" is checked → multiple values can be entered for the parameter (e.g.,
firma=code:FIRMA1&firma=code:FIRMA2) and theINoperator can be used in SQL.
__________________________________________________________________
🧮 Properties
This tab contains the list of fields returned by the query.
Here you can configure:
the order of fields,
column names for visualizing the results.
Fields can be generated automatically from the written SQL query using the "Generate Properties" tool.
For properties to be generated, the SQL query must return at least one row of data.
⚠️ Other Notes
Characters such as ; or : cannot be inserted directly into the SQL query body
→ replace them using the following functions:
chr(59)instead of;chr(58)instead of: