2022.2

l
Thequerymuststartwith=
l
Anyvariableorpropertymustbeenclosedincurlybrackets:{...}.Thiseffectivelyinsertsa
JavaScriptstatementinthequery.Notethatallothercurlybracketsmustbeescapedwithaback-
slash.
InsidethebracketsyoumayenteranyofthefollowingpropertyfieldsdefinedinthePreprocessorstep
(see"Fixedautomationproperties"onpage324and"Properties"onpage325):
l
Fixedautomationproperties.Theseareretrievedviatheautomationobject(see"Objects"on
page369),forexampleautomation.jobInfo.JobInfo9orauto-
mation.properties.OriginalFilename.
l
Propertiesthathavetheirscopesetto"Entiredata".Theseareretrievedviathedataobject(see
"data"onpage374),forexample:data.properties.myProperty.
l
Propertiesthathavetheirscopesetto"Automationvariable".Theseareretrievedviaauto-
mation.variables(see"Objects"onpage369),forexampleauto-
mation.variables.FieldList.
Propertiesthathavetheirscopesetto"Eachrecord"andcan notbeusedbecausetheSQLqueryis
executedbeforeanyrecordiscreated.Forthesamereason,variablesdeclaredinotherStepscannot
beused.
Example
= SELECT {automation.variables.FieldList} FROM {auto-
mation.jobInfo.JobInfo9}
IftheWorkflowvariabledefinedasFieldListcontainsthevalue"id,name"andJobInfo9containsthe
value"MyTable",thenthiscustomquery,onceparsed,yieldsthefollowingSQLstatement:
SELECTid,nameFROMMyTable
whichisthenexecuted.
Stepspane
TheStepstabdisplaysthedatamappingworkflow:theprocessthatpreparesandextractsdata.The
processcontainsmultipledistinctstepsandisrunforeachoftherecordsinthesourcedata.Formore
informationaboutthestepsandhowtousethem,pleaserefertoStepsand"Datamappingworkflow"
onpage221.
Findingastep
Tofindacertainstepinalargedatamappingworkflow,starttypingthenameofthestepintheFind
StepfieldatthetopoftheStepspane,andpressEnter.Usethebuttonsnexttothenumberofsearch
resultstonavigatethroughthematchingsteps.
Notethatthesearchiscase-insensitive.
Page 321