SQLTrigger

From GeoMedia Smart Client
Jump to: navigation, search
Settings WorkflowSetting FormSetting CommonSetting





Parameters

Name Value Mandatory Description
 <name="Sql">
Supported types:
  • SQL statement with placeholder:
 <value="Insert Into BUILDINGEXTENSIONAUDIT(EDITOR,BUILDINGEXTENSION_ID) Values({USER.NAME}, {FORM.ID})">
  • 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 here.



The following line is defined in the WorkflowSettings.xml:

  1.  ...
  2.  <WorkflowTrigger name="DeleteFileTrigger" type="SqlTrigger" method="action">
  3.    <Param name="Sql" value="Delete From BE_ATTACHMENT1 Where ID = {REQUESTCONTEXT.fileId}"/>
  4.  </WorkflowTrigger>
  5.  ...



Language: English