Report type SQL | OverIT Knowledge Hub

This topic explains how to manually create an SQL report using NextGen Geo.

Before you start

Configure the first step of a report module: Reports type

Configure an SQL report

An SQL table can displayed in a report format as a table, allowing users to view all the data in a tabular and filterable format. Accessing this table is done through a standard SQL query, enabling the use of any SQL syntax within the query.

In the configuration panel, you have to define:

Type: SQL
Connection name: The connection to the database. Available databases are configured as system properties within the project
SQL Query: The field where to write the query

Examples

A company that provides gas pipelines services uses NextGen Geo to map and track the physical assets in the field. These assets data are tracked in an SQL table assets_data, containing information such as code, installation date, life status and geographical location.

The operational manager needs an overview of the asset conditions and maintenance information, checking assets with older maintenance date, in order to make informed decisions about preventive maintenance.

The data related to the assets is stored in an SQL table assets_data

SQL Query:

SELECT 
  asset_code AS Asset Code,
  last_maint_date AS Last maintenance date,
  status as Status
ORDER by last_maint_date ASC;

Reference:

Access to dashboard widget: Module widget
Configure user’s access to module widget: Functional Groups