From here, you decide what fields should be placed to the prepared query. Decided data fields should be transferred to the Selected Attr. panel and be saved:
From the existing modules select one, you may prefer to enrich the module with the query that you are defining. More detailed information about modules see here.
Specifies the number of columns of query fields that you see when you query
Custom Help Link
The url entered in this field is added to the help pages of the page. When clicked on the help menu, the user is directed to the private help document.
The menu title of the form-specific help link should be entered in this area.
Custom HTML Content
The entered content is added to the beginning of the query and form pages.Script can be added, it can be used combined with the editor's client script features. Style rules can be added to provide a query-specific view.
Double click on rows in the query result and the link will automatically open. It also opens automatically when a single line query is finished.
This will be visible at the top of the query.
The query name that appears on the screen that other allowed user can change
Events To be Executed
he event or events to run before the query result list arrives are selected from this list.
Provides parametric query feature.
Grid features are specified from here. It is important to customize your query. For detailed information about grid features see here.
Determines how the domain is displayed on the query page. By writing group headings, it is possible to display data field groups defined with different headers on the query screen.
- Active : Indicates that the ability to include the field within a group is active.
- Target Area : Indicates the region where the field will be displayed on the page.
- Top : Indicates that the form will be located in the top region.
- Left : Indicates that the form will be located in the left zone.
- Right : Indicates that the form will be placed on the right zone.
- Bottom : Indicates that the form will be in the bottom region.
- Action : Indicates that there will be an area reserved for links and buttons under the form.
- Text : it is the title of the grouped area.
- Image : The icon that will be placed in the grouped area title.
- Type : Determines how labels and icons are displayed during grouping
- Text : It shows that only text will be displayed in the grouped area.
- Image : It shows that only images will be displayed in the grouped area.
- Both : It indicates that the icon and the text will be displayed side by side in the grouped area.
If the query is to be assigned an icon, the corresponding image file is selected from there.
Labels makes the search feature more usable for your users. There are certain labels that you can use so that users can perform search syntax depend on the label. For more details about labels see here
Maximum record Counts
The maximum number of rows to list in the query result is this field. If there is no value in this area, 250, if the value is entered, the value entered will be used. The value to be entered into this area can lead to performance problems.
It is possible to create several different queries. Different names should be given to distinguish the questions from each other.
New Record Link
Define new record link, they are gateways for your end users to crete new records. For example if you add this feature to the query that you are creating then when your user visits the query page, there will be New Record button, and as clicking on that the user will be able to add new records to the query. For detailed information about New Record Link example see here.
Permission Role Name
If the authority to use the query is assigned to a certain group or user, the authority role is specified in this field. The corresponding authorization settings are made from the Authorization Server.
Prefered View Order
Prefered grid type should be placed at the top. Preffered view should be related with the query, for example if you are preparing a gant like query and you have gant chart data then select gant view as preffered order.
Query Form Row Count
Specifies the number of rows to be edited for query criteria on the query screen.
Query Page Additional Information
The information entered here is displayed at the top of the query page.
Here unlike HTML reports, the query report preparation is performed directly through the query. Using report wizard could be easy for your first examples, wizard provides options you to choose and prepare templates. For more detailed information about query reports see here.
Query Result Collection
Query result items are selected from here. Here you see the data sources and properties of these data sources, you should place the decided query results to the Selected Attr. panel as descibed in the query criteria. You can order the query result collection, e.g. first name of the thing, then, information card, then rating, then map
Client side properties are specified from here. For detailed information about it, see here.
If you want to sort the fields in the query result list (e.g. names in alphabetical order, etc.) this property is used.
SQL Join Type
Shows the join type in the sql query. LEFT, RIGHT, or INNER.
The use of sql distinct when creating a query.