SQL File Iterator Trigger

From GeoMedia Smart Client
Jump to: navigation, search
Settings WorkflowSetting FormSetting CommonSetting
WorkflowTrigger SQL Trigger SQL Iterator Trigger SQL File Iterator Trigger Mail Trigger Session/Remove Session Trigger Log Trigger





With this trigger you are able to upload files via SQL.

Parameters

Name Value Mandatory Description
 <name="Sql">
Supported types:
  • SQL statement with placeholder:
 <value="INSERT INTO BE_ATTACHMENT (Master_Id, FilePath, FileName) VALUES({FORM.ID}, {FilePath}, {FileName})">
  • 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..



Pfeil new.png To the top Pfeil new.png

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>



Language: English