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