Example of GetGridDataOnly request - HxGN EAM - Version 11.07.01 - Customization & Programming - Hexagon

HxGN EAM Connector Grid Services Help

Language
English
Product
HxGN EAM
Search by Category
Customization & Programming
HxGN EAM Version
11.7.1

Using the above LOV definition, the correct parameters can be supplied.

To illustrate, this is the SQL statement stored for multiorg query for grid name LVACTW:

from r5activities, r5events e where evt_code=:param.jobnum and e.evt_code=act_event and e.evt_org in

(select uog_org from r5userorganization where uog_user = :parameter.r5user and (uog_common='+' or uog_org=:req.org))

The grid web service for LOVs takes the defined param.jobnum and req.org and substitutes their values from the passed LOV_PARAMETER as shown below.

(The parameter "parameter.r5user" is always provided by the system using the session’s user ID, so this does not need to be passed.)

MP0116_GetGridDataOnly_001 xmlns="http://schemas.datastream.net/MP_functions/MP0116_GetGridDataOnly_001" xmlns:dsg="http://schemas.datastream.net/MP_functions/GridRequest" xmlns:xsi="http://www.w3.org/2001/XMLSchema- instance" xsi:schemaLocation="http://schemas.datastream.net/MP_functions/MP0116_GetGridDataOnly_001

C:\shotgun\resources\build\schemas\Grid\MP0116_GetGridDataOnly_001.xsd">

<FUNCTION_REQUEST_INFO REQUEST_TYPE="LIST.DATA_ONLY.STOR ED ">

<GRID GRID_NAME= "LVACTW "/>

<GRID_TYPE TYPE= "LOV"/>

<LOV>

<LOV_PARAMETER ALIAS_NAME= "param.jobnum" TYPE="VARCHAR" VALUE="JOB3"/>

<LOV_PARAMETER ALIAS_NAME= "er q.org" TYPE="VARCHAR" VALUE="ORG1"/></LOV>

</FUNCTION_REQUEST_INFO>

</MP0116_GetGridDataOnly_001 >

Also, based on the above LOV definition, the caller knows that the result columns will be (Cost Code, Activity, Work Order) with data types of (varchar, number, varchar) and aliasIDs of (20,128,279), respectively. This returned information could also be dynamically retrieved from the FIELDS data response in a GetGridHeaderData request. However, with knowledge of this beforehand, the GetGridDataOnly web service can be called instead (with less returned data). Either method can be used.