Skip to end of metadata
Go to start of metadata

Queries

Description

Icon

Queries are gateways to handling data, they fetch the things (information cards, views, maps, reports, descriptions etc.) in a desired way, since NETIGMA allows you to design the query and the query results in terms of contents and views. This page describes Queries interface and development operations within it. This page describes Queries interface and development operations within it.

Content

Icon

 

Go to Management>Object List: select an object and click on its Queries

Icon

For each object actually there is an default query that Netigma automatically creates. Within Queries interface you can view the existing queries, create new ones or edit.


When you click on queries, the following screen opens:

netigma query homepage display


Query Properties

Query Criteria

From here, you decide what fields should be placed to the prepared query. Decided data fields should be transferred to the Selected Attr. panel and be saved:

Module

From the existing modules select one, you may prefer to enrich the module with the query that you are defining. More detailed information about modules see here.

Other

Column Count

Specifies the number of columns of query fields that you see when you query

The url entered in this field is added to the help pages of the page. When clicked on the help menu, the user is directed to the private help document.

Custom Help Link Header

The menu title of the form-specific help link should be entered in this area. 

Custom HTML Content

The entered content is added to the beginning of the query and form pages.Script can be added, it can be used combined with the editor's client script features. Style rules can be added to provide a query-specific view.

 Double click on rows in the query result and the link will automatically open. It also opens automatically when a single line query is finished.

Description

This will be visible at the top of the query.

Display Name

The query name that appears on the screen that other allowed user can change

Events To be Executed

he event or events to run before the query result list arrives are selected from this list.

Extra Criteria

Provides parametric query feature.

Grid Features

Grid features are specified from here. It is important to customize your query. For detailed information about grid features see here.

Group

Determines how the domain is displayed on the query page. By writing group headings, it is possible to display data field groups defined with different headers on the query screen.

  • Active : Indicates that the ability to include the field within a group is active.
  • Target Area :  Indicates the region where the field will be displayed on the page.
    • Top : Indicates that the form will be located in the top region.
    • Left : Indicates that the form will be located in the left zone.
    • Right : Indicates that the form will be placed on the right zone.
    • Bottom : Indicates that the form will be in the bottom region.
    • Action : Indicates that there will be an area reserved for links and buttons under the form.
  • Text : it is the title of the grouped area.
  • Image : The icon that will be placed in the grouped area title.
  • Type : Determines how labels and icons are displayed during grouping
    • Text : It shows that only text will be displayed in the grouped area.
    • Image :  It shows that only images will be displayed in the grouped area.
    • Both : It indicates that the icon and the text will be displayed side by side in the grouped area.

Image File

If the query is to be assigned an icon, the corresponding image file is selected from there.

Labels

Labels makes the search feature more usable for your users. There are certain labels that you can use so that users can perform search syntax depend on the label. For more details about labels see here

Maximum record Counts

The maximum number of rows to list in the query result is this field. If there is no value in this area, 250, if the value is entered, the value entered will be used. The value to be entered into this area can lead to performance problems.

Name

It is possible to create several different queries. Different names should be given to distinguish the questions from each other.

Define new record link, they are gateways for your end users to crete new records. For example if you add this feature to the query that you are creating then when your user visits the query page, there will be New Record button, and as clicking on that the user will be able to add new records to the query. For detailed information about New Record Link example see here.

Permission Role Name

If the authority to use the query is assigned to a certain group or user, the authority role is specified in this field. The corresponding authorization settings are made from the Authorization Server.

Prefered View Order

Prefered grid type should be placed at the top. Preffered view should be related with the query, for example if you are preparing a gant like query and you have gant chart data then select gant view as preffered order.

Query Form Row Count

Specifies the number of rows to be edited for query criteria on the query screen.

Query Page Additional Information

The information entered here is displayed at the top of the query page.

Query Reports

Here unlike HTML reports, the query report preparation is performed directly through the query. Using report wizard could be easy for your first examples, wizard provides options you to choose and prepare templates. For more detailed information about query reports see here.

Query Result Collection

Query result items are selected from here. Here you see the data sources and properties of these data sources, you should place the decided query results to the Selected Attr. panel as descibed in the query criteria. You can order the query result collection, e.g. first name of the thing, then, information card, then rating, then map

Script Options

Client side properties are specified from here. For detailed information about it, see here.

Sort Properties

If you want to sort the fields in the query result list (e.g. names in alphabetical order, etc.) this property is used.

SQL Join Type

Shows the join type in the sql query. LEFT, RIGHT, or INNER. 

Use Distinct

The use of sql distinct when creating a query.