Skip to end of metadata
Go to start of metadata

Grid Features

Description

Icon

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

Icon

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

Icon

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

Icon

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

Icon

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

Icon

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

Icon

"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: