Page tree
Skip to end of metadata
Go to start of metadata

How to Edit Data Fields( Column List)?

Description

This page gives detailed guides how to define data fields' ( attributes) properties.

Content

  1. Open Column List Meta Interface: Go to Management> Framework Operations> Object List and select an object( e.g. ada) that you want check its data fields, click on its Column List,



  2. Members are the data columns, when you ckick on one of the members then you see properties of it, in the Properties. e.g. Below you see properties of Objectid's Properties:

 

 

 

Data types and editor properties for columns to be defined below are examples. There is no obligation for editor features to be used in data types. (Example: a field in the varchar data type is not necessarily a text box.) 

 

How to Define Properties for Data Fields?

 Defining the basic properties of the column ( of varchar/string/character etc.data type)
  • You can edit columns/members' display names :


 

  • The groupable can be marked as its statistical properties With this process, statistical reporting can be made.

  • After your selections and arrangements for the properties, click on Save.
 Defining form editor properties of the column (of varchar / string / character etc.)

 

  • Defineing form editor properties for an example column, Activities (varchar / string / character etc.): 
    • Select a form editor for the selected column (e.g. Activities)
    • The default text box comes automatically if the data fields are varchar, string data type.
    • From Group properties, the field and title of the column for the page can be specified. E.g. select Target Field as left for its position etc
    • In the field, type the group heading for that column. (E.g. General Activities)
    • Select/enable Validations. For example type ' You cannot leave this field as blank' to the error message field. So that in your created query page, your users cannot left blank the criteria that you selected.


 Defining query editor properties of the column (varchar/string/character etc.)
  • Defineing query editor properties for Activities columns (varchar/string/character etc.)
    • Open query editor properties with drop-down lists.
    • The query editor column selection comes as default Text Box for string fields.
      • From the Group properties, specify the positioning title of the column with respect to page. e.g. Select target area as Left.
      • To the Text field, type the group heading of the column (e.g. Activities)

 

 Defining display editor properties the column (varchar / string / character etc.)
  • To Define its display editor properties for the selected column (varchar / string / character etc.), Select the Default option for display edtior:

 

 Defining form editor properties of an Area column (real/double/float/numeric/decimal etc.)
  • Defining the form editor properties for an example, IArea, column (real/double/float/numeric/decimal etc.)
    • Open the form editor properties of the column, click on drop down list.
    • Select Textbox Float for decimal fields.
    • From the Group properties, specify the positioning title of the column with respect to page. E.g. Select target area as Left.
    • To the Text field, type the group heading of the column.

 Defining query editor properties of an Area column (real/double/float/numeric/decimal etc.)
  • Defining the query editor properties for IArea column (real/double/float/numeric/decimal etc.)
    • Open query editor properties of the column.
    • Select Textbox Float for decimals. 
    • From the Group properties, specify the positioning and title of the column with respect to page. E.g. Select target area as Right.
    • To the Text field, type the group heading of the column.

 Defining display editor properties of an Area column (real/double/float/numeric/decimal etc.)
    • Defining display editor properties for IArea column (real/double/float/numeric/decimal etc.) 
      • Open display properties field of area column (real/double/float/numeric/decimal etc.) and set this field as default.

 Defining basic properties for the Area column
    •  You can change its viewng name (of IArea column) e.g. Area (m2)  



    • E.g., Select, Sum operation for Summary Type of the Grid option. And statistical report properties, select Sum operation for Aggregate Funciton and save the selected properties.

 Defining form editor properties of poly (geometry) column

Defining form editor properties of poly (geometry) column: 


Columns with geometry data types carry spatial characteristics. When Netigma is integrated with Geo Servers, it is possible to use web based map features in Netigma's Queries, Forms and Reports. If there is not any geoserver map settings etc., then Poly column properties is not going to be defined. 


    • Open The column's(e.g. Poly) form editor properties.
    • Select Coordinate editor, for its form editor property.
    • Specify SRID and geometry types(e.g. poly). In this demo example, the object had 4326 (geographical wgs 84) srid code. Geometry type: should be specified as polygon (area).


      • From the Group properties, specify the positioning and title of the column with respect to page. E.g. Select target area as Right.
      • To the Text field, type the group heading of the column. (e.g Island Location)
 Defining query editor properties of poly (geometry) column
  • Defining query editor properties of poly (geometry) column:
  • Open query editor properties of the column, drop down list.
  • Select geometry for query editor.
  • From the Group properties, set where the collumn is going to appear in the page and type title of the column. E.g. select Target Field as bottom.
  • In the Text field, type the group heading of the column, (e.g. General Info of State)

 

 Defining display editor properties of poly (geometry) column

Defining display editor properties for poly column(geometry)

  • Open display properties, and select Map



 Defining form editor properties of the column (varchar/ string/character etc.)
  •  Defining form editor properties for the StateName column (varchar/string/character etc.)
      • Got to Object List select a table(e.g. State), and go to column list and select the (varchar/string/character etc.) type of column(e.g. StateName)
      • Open form editor properties.
      • Select Text Combobox option
      • Activate the lookup box.

With the lookup feature, the object (State table) will gain drop-down list type feature for its own. Drop-down list editors should be used with the lookup feature is active. 



    • From the Group properties, specify the positioning and title of the column with respect to page. E.g. select target zone as Left
    • In the Text field, type the group heading of the column, (e.g. General Info of States)
 Defining query editor properties of the column (varchar/string/character etc.)
  • Defining query editor properties for StateName column (varchar/string/character etc.)
    • Open the query editor properties
    • Select Text Combobox option
      • From the Group properties, set where the collumn is going to appear in the page and type title of the column. E.g. select Target Field as Left
      • In the Text field, type the group heading of the column, (e.g. General Info of States)


 
 Defining display editor properties of the column (varchar/string/character etc.)
  • Defining display editor properties for StateName column (varchar/string/character etc.)
    • Set this field to default.
 Defining other properties of the column (varchar/string/character etc.)
  •  Defining other properties for StateName column (varchar/string/character etc.) :
    • You can type and change the viewed name of the column from Display Name field: For example, type State Name
    • Mark the Groupable option from the statistical properties. With this process, statistical reporting feature will be active for queries that mentions State Name column.



    • Then Save all the properties.
 Defining form editor properties of (integer) type columns
  • Defining form editor properties for (integer) type columns.
    • Open the form editor properties.
    • Select Text Combobox.
    • From the Lookup Settings, in the example below; 
      • Table name was selected.
      • Value Column Name was selected as State_id.
      • Display Column Name was selected as state_type.
      • Sort column name was selected as state_id.



    • From the Group properties, set where the collumn is going to appear in the page and type title of the column. E.g. select Target Field as Left
    • In the Text field, type the group heading of the column, (e.g. General Info of States)
 Defining query editor properties of integer type column (integer)
  • Defining query editor properties for column (of integer type) :
    • Open query editor properties of the column.
    • Select Text Combobox type its query editor property. 
    • Select Text Combobox for its form editor property.
    • From the Group properties, set where the column is going to appear in the page and type title of the column. E.g. select Target Field as Left
    • In the Text field, type the group heading of the column, (e.g. General Info of States)
    • Set its display editor type to Lookup
 Defining other properties of integer type of column
  • Defineing other properties for (integer) type columns:
    • You can change the displayed name of the column: For example: change it to State Type 
    • Groupable option can be marked in the statistical properties of the column. With this process, statistical reporting feature will be active for queries that involves State Type.


    • Then save the property settings.

Virtual Column Operations 

In Netigma, beside data columns; link, sql macro virtual column and non-sql macro virtual column types can be defined. In this page as an example, link and the sql macro example are going to be shown. 

 Defining Information Card Action

 

 

  • Defining an Information Card type of action:
    • Add new column to the selected table:


    • Select Link type, and fill the Name and Display Name fields and press Add button



    • Select Link for display editor property (for the added column).After the selection, the display editor will be active with Link properties
    • Enable "Show in List" option for Group properties and type group heading of the column.




    • Select Information Form Link action.
  • Click on drop down its Action properties: 
    • Select Info Card for the Link.
    • The destination can be specified from Target, that is the place which Info form is going to be opened.
    • Witihin URL parameters field, enter the parameters
    • The information card operations can be added to the query result collection criterias.
 Defining a Map Action
  • Defining a Map Action
    • Add new column as in the previous.
    • Select type as Link
    • Fill Name and Display Names:


    • Select Link for display editor properties.
    • In the activated display editor field, type "Description" , and from Group properties type in Text field e.g. Map.
    • Enable Show in list and Show all Option.
    • Select Map for Action type. To fill the action properties see detailed Map Action
    • Select the target field where map is going to open.


 
    • Map actions can be added to the query collection criterias.
 Defining Sql Macro Column

 

  • Example 1: Area\1000 (km2) 
    • Add new column to the object(e.g. to the State table) and select its type as Sql Macro Virtual Column
    • Fill for the Name and its Display Name such as:

 

 

    • Select column data type as double. (sql macro will return the decimal value of the column that will be the result of the field)
    • Write, {T@states.area}/1000 in the Sql macro field

 

  • In the Sql Macro field you can operate with T@OBJECT_NAME.COLUMN_NAME
  • When the sql macro is typed as {T@STATES.AREA} / {T@STATES.POPULATION}, the AREA data of the State object will be divided with POPULATION data and the result will be returned to this column.
  • In Sql Macro field, you can write sql statements depending on the database used in the project and use database functions. However, the sql clauses are not recommended for portable projects, as they will eliminate database independence.
  • E.g. suppose you had "MONTH( {T@building_lisace.yr_accaptence_date }) " type of sql macro. And suppose that this expression is valid for ms sql server, access and oracle databases; but not valid in postgres databases then for that, in custom sql macro fields define " DATE_PART('Month',  {T@building_lisace.yr_accaptence_date })::text "
    • It will bring the AREA data that is from database.
    • Select 1 -> will bring the result of your clause from the database.
    • Convert (datetime, '23.10.2016 ', 104) -> will use the convert function in the database 

  • Example 2: Using Logical Operators
    In the example above, it is shown that macro result values are obtained by performing arithmetic operations with columns and fixed values. Logical operators, other than arithmetic operators can be used in macro columns. However, it is important to note that the database that is being used should match the SQL syntax of the database. Let's assume that the database has a DateTime type column named DateOfBirth. As a result of a query, records that are less than 18 years olds is going to be displayed as children and 18 years and older as adults. In this case, a sql macro would look like this: CASE WHEN DateDiff(YEAR, {T@PUBLICBIRTHDATES}, GETDATE()) <= 18 THEN 'Children' WHEN DateDiff(YEAR, {T@PUBLICBIRTHDATES}, GETDATE()) > 18 THEN 'Adult' END
    • Select Use view editor for the form editor property.
    • For display editor select Default.
    • Select Texbox Float for query editor property.


    • "Area Km2" sql macro column can be added to the form column.
    • It can be added to the query criterias and also to the query result collection criterias.