SQLTrigger

Workflow Manager Developer Guide

HGD_Variant
15.00
HGD_Product
GeoMedia Smart Client
HGD_Portfolio_Suite
Platform

Parameters

Name

Value

Mandatory

Description

<name="Sql">

Supported types:

<value="Insert Into BUILDINGEXTENSIONAUDIT(EDITOR,BUILDINGEXTENSION_ID) Values({USER.NAME}, {FORM.ID})">

  • SQL statement with placeholder:
  • OBJECT
  • static value

yes

With the parameter Sql you are able to set the SQL statement.

Example - method="after"

This trigger fires after the node has been processed, for example, after a save - action. First the trigger checks if a certain condition is valid and then it executes the defined SQL-Statement.

<WorkflowTrigger name="SqlTriggerAudit" method="after" type="SqlTrigger" condition="OBJECT[HasValueProvider.GetValue({FORM.ID})]">
  <Param name="Sql" value="Insert Into BUILDINGEXTENSIONAUDIT(EDITOR,BUILDINGEXTENSION_ID) Values({USER.NAME}, {FORM.ID})" />
</WorkflowTrigger>

Example - method="action"

This trigger fires after a button - action. First the trigger checks if a certain condition is valid and then it executes the trigger. The following line is defined in the FormSettings.xml: 
(action="SCRIPT[IG.trigger(...)]" ) For detailed functionality see Javascript API Guide. 
The following line is defined in the WorkflowSettings.xml: 
 ...
 <WorkflowTrigger name="DeleteFileTrigger" type="SqlTrigger" method="action">
   <Param name="Sql" value="Delete From BE_ATTACHMENT1 Where ID = {REQUESTCONTEXT.fileId}"/>
 </WorkflowTrigger>
 ...