Grid Features
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
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
Exmaple 3 For Detail Query
Query Result View:
Example 4 Gant View Grid Features