Grid Features
Description
Grids are UI feature of your queries. Netigma allows you to customize your grids to highlight relevant information in appropriate way. Grids are different than tables which how only two dimensional data; but by cystom grid fetures you can put many data fields in one place. For example in the query result, you can show reports/charts not in the link form but directly the view of them, or you can create hirearchic/expandable query results which each result depends on the previous result etc. . Here in this section grid features are explained and the examples are provided.
Content
Grid Features (General Description)
Click on expandable Grid Features:
DataView Column Count
If DataView column number is selected as 3, the report comes in 3-line clusters. Use here for card view as including related report see example 1
Detail Query
Here you select a query then in the query result, detail view appears in each row which is the selected query. The selected detail query comes as queries with is queried the line it is linked to. Use this feature with Netcad Grid (preffered view order)
Detail Report Name
The report that is related to the query result lines, is selected from here. The detail view appears in each row in the query result that is the selected report. The selected report appears to be queried according to the line it is bound to.
Grid Flags
Hide Key Field
Used to prevent the column containing key field information from being included in the query result. Used for tree grid view.
Example: If the Hide Key Field option is marked for the object query with the key field unit.objectid, the objectid column is not shown in the query result.
Hide Parent Field
It is used to prevent the column of Parent domain knowledge from being included in the query result. Used for tree grid view.
Example: If Hide Parent Field is checked for the object query, which is the Parent Field unit.parentid, the parentid column is not shown in the query result.
Key Field Path
The name of the key column in which the hierarchy information is tracked is written in this field. (Primary key) . Used for tree grid view.
Example : Unit.OBJECTID (The hierarchical relationship in the unit table is based on OBJECTID knowledge.)
Parent Field Path
The column where the upper hierarchy information is kept is written in this field. Used for tree grid view.
Example : unit.parentid (parentid column in the Unit table)
Related Report
The report related to the query result lines is selected from this field. If there is not any report in the list, you can quicklt create, for this click on + button, you'll be directed to report design tool which provides data fields The detail view appears in each row in the query result and the report selected in this detail view is displayed. The selected report appears to be queried according to the line it is bound to.
Show In Cardview
Select it, if the prefered view order is Card view. For Card view, you should also provide data column count parameter and related report. So that the related report will appear as card look
Important
In order for the query result view to be shown in a Tree Grid, the "Preferred View Sequence" in the Query Properties should be selected as TreeGrid.
Important
If the data types of the Parent Field and Key Field columns are not the same, the result is a Tree-Grid, but the master-detail structure does not occur and all records appear at the same level.
Here below some examples are given in order to distinguish how the grid features should be defined depending on the desired appearance:
Example 1 for Card View
Here, the query is the result of how many lines of the report, the report will come from. If DataView column number is selected as 3, the report comes in 3-line clusters.
Show in Card View: This box should be ticked so that the query result is "Card View". When this box is unchecked, the query result is Row Template.
Example 2 For Detail Row Report View
Important
The "Preferred Display Order" in Query Properties must be selected as DevexpressGrid or Netcad Grid for the report result view to be able to get detailed report.
Exmaple 3 For Detail Query
Query Result View:
Important
For the query detail to appear in Query result view, the "Preferred View Order" in the Query Properties should be selected as DevexpressGrid or Netcad Grid.
Example 4 Gant View Grid Features
Important
"Preferred View Order" in the Query Properties should be selected as Gant View. Mappings and Text Settings should be provided and be saved . Below an example Gant View in the prefered view order is given:
