Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
2500_config_apps:1100_add_edit_queries:0100_query_props [2026/08/13 00:55] – removed - external edit (Unknown date) 127.0.0.12500_config_apps:1100_add_edit_queries:0100_query_props [2026/08/13 04:06] (current) – repoint link into merged parent page cli
Line 1: Line 1:
 +[<10>]
 +====== Query Properties ======
 +
 +The following properties of a query can be specifed:
 +
 +===== Name =====
 +
 +Specify the name of the query uniquely identifying it within the business space version. The name must be unique among the names of other queries defined in the business space version. Any symbols (including spaces) are allowed.
 +
 +===== Category =====
 +
 +You can group queries by category. Queries belonging to a particular category are grouped in the Elements Tree. Enter a new category or select from the list of existing ones. You can apply the same category to several queries at once if you paste them under this category in the Elements Tree.
 +
 +===== Description =====
 +
 +Specify a description of the query. Any description if defined is included into the generated documentation for the business space version – see [[2500_config_apps:3100_gen_doc|Generating Documentation]].
 +
 +===== Panel Operations =====
 +
 +The buttons will be displayed at the top, bottom, left or right of the query. Alternatively they can be temporarily added to the application menu or put in the "tools area" of the panel header. The menu will allow uses to perform certain operations from the query – start a process, display a document and so on. The concept is very similar to the [[2500_config_apps:0500_add_edit_objects:0200_defining_forms:0500_operations|panel operations of the form]]. 
 +
 +Some spefic operations available for queries include Exporting query results in CSV, XLSX and PDF formats.
 +
 +===== Panel Header =====
 +
 +This is exactly the same as defining [[:2500_config_apps:0500_add_edit_objects:0200_defining_forms:0200_form_properties#panel_header_and_caption|panel header for object forms]].
 +
 +===== Item Display Rules =====
 +
 +Specify conditions for displaying entries in the results table in different colors and font styles (this is similar to defining item rules for references – see "[[2500_config_apps:0700_add_edit_attributes:0500_ref_attrib|Item Display Rules]]").
 +
 +===== Auto Refresh =====
 +
 +//**AwareIM**// will automatically refresh query results whenever an object shown in query results is modified, or when a process invoked by a query operation completes. Sometimes it may be necessary to refresh the query results screen after some other object is modified or some other process completes. The "Auto-Refresh" options allow you to specify such objects and/or processes as well as define a time interval for periodic automatic refresh.
 +
 +===== Resizing =====
 +
 +Click on the "Resizing" property to allow/disallow the user to resize the query results panel at run time and/or specify size constraints. The Resizing Options dialog will be displayed. Tick the "Resize Width" checkbox to allow user to change width of the panel; tick the "Resize Height" checkbox to allow user to change the height. Specifying size constraints can be useful if your application is displayed on different screen sizes and resolutions. For example, if you specify min. width scroll bars will be displayed on small screens, but not on the large ones.
 +
 +===== CSS style and CSS class =====
 +
 +Here you can assign CSS style and class to the query to customise its appearance. See the "How to use CSS" section in the How To Guide for more details.
 +
 +===== Tour =====
 +
 +The "Tour" feature allows configurators to add explanation to the elements of the query results screen, so that the user can understand the screen better. The explanation of the element is displayed to the user at the bottom of the screen with the marker pointing to the element of the screen being displayed. The user can jump between the elements of the screen and //**AwareIM**// automatically scrolls to the element being explained and displays the marker for the element. For more details about tours see the "How to use the Screen Tour feature" in the How To Guide.
 +
 +===== Script =====
 +
 +For users who are familiar with Javascript this dialog allows specifying additional parameters when queries are initialized and displayed. See [[:3500|Programmers Reference Guide]] for more details.
 +
 +===== Resolve Shortcuts =====
 +
 +This properties allows the developer to specify which shortcuts will be resolved when the query is run. By default all shortcuts are automatically resolved. However, there resolving shortcuts is relatively slow, so you can boost the performance of the query if you specify that some or all shortcuts don't need to be resolved for the query. You have to be careful and make sure that those shortcuts that you unselected are not used in the list of columns displayed by the query or in presentation rules or in item rules or in applicability conditions, otherwise they will not work correctly.