Workflow API Changes 2013

From GeoMedia Smart Client
Jump to: navigation, search



For consistency of the XML definition some changes have been applied.

Filter Definition

The definition of the form attribute filter looks like:

 filter="SQL[sqlexpression]"



Old Definition:

 <Form name="WINDTURBINE" table="WINDTURBINE" idfield="ID" filter="type == 1">



New Definition:

 <Form name="WINDTURBINE" table="WINDTURBINE" idfield="ID" filter="SQL[type==1]">



Order Definition

The definition of the form attribute order looks like:

 order="SQL[order by sqlexpression]"



Old Definition:

 <Form name="WINDTURBINE" table="WINDTURBINE" idfield="ID" order="type asc">



New Definition:

 <Form name="WINDTURBINE" table="WINDTURBINE" idfield="ID" order="SQL[order by type asc]">



FormTable Definition

The definition of the FormTable looks like:


Old Definition:

 <FormTable name="NAME" label="LABEL" datatype="string" idfield="ID" type="table">



or

 <FormTable name="NAME" label="LABEL" datatype="string" idfield="ID" type="listbox">



New Definition:

 <FormTable name="NAME" label="LABEL" datatype="string" idfield="ID">



Save Action including Geometry

The definition of an action to capture a geometry in GeoMedia SmartClient looks like:

 action="SCRIPT[IG.captureGeometry()]"



Old Definition:

 <FormAction name="GeometrySave" label="GeometrySave" visible="form" action="Geometry/SaveInSession">



New Definition:

 <FormAction  name="GeometrySave" label="GeometrySave" visible="form" action="SCRIPT[IG.captureGeometry()]">



Parameters of WorkflowTrigger

The definition of "Param" in the node WorkflowTrigger looks like:

 <Param name="" value="" />



Old Definition:

 <Param name="Test" value="Some value" type="String" />



New Definition:

 <Param name="Test" value="Some value" />



File upload

The handling of files have been changed to fit requirements like multiple file upload.


Old Definition.

 <Form name="…" uploaddir="C:\Temp\Upload"><FormField name="…" type="filepicker" datatype="file"/></Form>



New Definition:

 <Form name=”…” ><FormFile name="FilePath" datatype="file" uploaddir="C:\Temp\Upload" multiple="false" /></Form>



DBTrigger

The name of the DBTrigger has been changed to SqlTrigger. Also the parameter CompensationSql has been removed.
The value of Sql parameter must not contain SQL[].

 <WorkflowTriggertype="SqlTrigger" ..>



Old Definition:

 <WorkflowTrigger name="TestTrigger" type="DBTrigger" method="after">
   <Param name="Sql" value="SQL[DELETE FROM MyTable]" />
 </WorkflowTrigger>



New Definition:

 <WorkflowTrigger name=" TestTrigger" type="SqlTrigger" method="after">
   <Param name="Sql" value="DELETE FROM MyTable" />
 </WorkflowTrigger>



IteratorTrigger

The name of the IteratorTrigger has been changed to SqlIteratorTrigger.

 <WorkflowTriggertype="SqlIteratorTrigger" ..>



Old Definition:

 <WorkflowTrigger name="test" type="IteratorTrigger" method="action">
  <Param name="Sql" value="UPDATE Recipients SET IsActive = 1 WHERE Mail = {Iterator}" />
  <Param name="Iterator" value="Recipients" />
 </WorkflowTrigger>



New Definition.

 <WorkflowTrigger name="test" type="SqlIteratorTrigger" method="action">
  <Param name="Sql" value="UPDATE Recipients SET IsActive = 1 WHERE Mail = {FORM.Recipients}" />
 </WorkflowTrigger>



Mail Trigger

A set of properties has been removed from the MailTrigger. Following properties are still supported:

  • From (formally known as Sender)
  • Recipients
  • Subject
  • Body

Following properties has been removed:

  • Sender
  • Bcc
  • Attachments
  • Salutation
  • Footer
  • Font
  • FontSize
  • InMemoryAttachment
  • InMemoryAttachmentName



SessionDataTrigger

The SessionDataTrigger has been renamed to SessionTrigger. Also the properties have been harmonized with all other triggers:

 <WorkflowTriggertype="SessionTrigger" ..>
  <Param name="Key" value="[Name of session key value]" />
  <Param name="Value" value="[Value to set]" />
 </WorkflowTrigger>



Old Definition:

 <WorkflowTriggertype="SessionDataTrigger" ..>
  <Param name="Keys" value="Test.ID=3" />
 </WorkflowTrigger>



New Definition:

 <WorkflowTriggertype="SessionTrigger" ..>
  <Param name="Key" value="Test.ID" />
  <Param name="Value" value="3" />
 </WorkflowTrigger>



Old Definition:

 <WorkflowTriggertype="SessionDataTrigger" ..>
  <Param name="RemoveKeys" value="Test.ID" />
 </WorkflowTrigger>



New Definition:

 <WorkflowTriggertype="RemoveSessionTrigger" ..>
  <Param name="Key" value="Test.ID" />
 </WorkflowTrigger>




Oracle Sequences

Old Definition:

 <Form name="…" table="…" idfield="ID"><FormField name="ID" datatype="number" visible="hidden" /></Form>



New Definition:

How to use Oracle sequences



Language: English