SQL File Iterator Trigger

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 BE_ATTACHMENT (Master_Id, FilePath, FileName) VALUES({FORM.ID}, {FilePath}, {FileName})">

  • SQL statement with placeholder:
  • OBJECT
  • static value

yes

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

<name="Files">

Defines the folder of the files.

<value="PathFiles">

yes

With the parameter Files you are able to set the name of the files field name.

Example

<WorkflowTrigger name="FilePathUploadTrigger" type="SqlFileIteratorTrigger" method="action" >
 <Param name="Sql" value="INSERT INTO BE_ATTACHMENT (Master_Id, FilePath, FileName) VALUES({FORM.ID}, {FilePath}, {FileName})"/>
 <Param name="Files" value="PathFiles" />
</WorkflowTrigger>