Language-independent descriptions in the grid - HxGN EAM - 12.0.1 - Feature Briefs - Hexagon

HxGN EAM Alert Management

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

To include a language independent descriptions in your grid you can call database function r5o7.o7get_desc on Oracle and dbo.r5o7_o7get_desc on SQL Server. The function requires the following inputs:

  • Language code

  • Entity code

  • Primary key of record

  • System Codes – Code for the Status, Type or Codes Entity

  • You can leave this field blank.

Some examples:

  • WO description: r5o7.o7get_desc(:parameter.language,'EVNT',evt_code,'','')

  • Object description: r5o7.o7get_desc(:parameter.language,'OBJ',obj_code||'#'||obj_org,'','')

  • WO status: r5o7.o7get_desc(:parameter.language,'UCOD',evt_status,'EVST','')

  • WO priority: r5o7.o7get_desc(:parameter.language,'UCOD',evt_priority,'JBPR','')

  • Trade: r5o7.o7get_desc(:parameter.language,'TRAD',act_trade,'','')

  • In SQL Server use null instead of ''.