Grid designer limitations - HxGN EAM - Version 11.07.01 - Feature Briefs - Hexagon

HxGN EAM Alert Management

Language
English
Product
HxGN EAM
Search by Category
Feature Briefs
HxGN EAM Version
11.7.1

The FROM Clause field does not support the use of complex constructs. A grid that selects several columns from the r5objects table can easily be created by specifying r5objects in the FROM Clause field. Most joins are allowed as well like r5event, r5activities for example.

But more complicated constructs are not supported. For example, if the table is defined as (SELECT obj_code AS equipment FROM r5objects) or if you need an outer join like r5events LEFT OUTER JOIN r5activities ON evt_code = act_event. When you specify these in the FROM Clause the system will raise an error message indicating they are too complex.

Self-hosted customers have a work around for this problem in that they can access the database and create a view. The name of this view can then be used in FROM Clause.

Hosted users can still use the Views screen and create a view on that screen.