2022.2

Connect2018.2DataMappingUpdates
Ignore Blank Lines
OptionaddedtotheDataMapperSettingstoignore any blank linesinthedata.(SHARED-57790)
Dynamic SQL Queries
CustomSQLqueriesnowsupporttheuseofdynamicelementswhichcanbebuiltusingJavaScriptsyn-
tax.ThisallowsanSQLquerytouseinformationpassedonbyWorkflowtodynamicallycustomizethe
query.(SHARED-34301)
Forinstance,acustomquerycouldcontainthefollowingcode:
=SELECT {automation.variables.FieldList} FROM {automation.jobInfo.JobInfo9}
ThiswouldgetconverteddynamicallytosomethinglikeSELECT id, name FROM MyTablebased
uponthevaluesofWorkflowprocessvariablesFieldListandJobInfo(9).
Set Data Fields as Not Required
Individualdatamodelfieldscannowbesetasrequiredornot required.
Bydefaultalldatabasefieldsareinitiallysettobeingrequired.Thisnewoptionprovidestheabilityto
setindividualfieldsasnotrequired.Non-requiredfieldsareindicatedintheDataModelpanelbya
greenasterisk('*')symbolafterthefieldtype.(SHARED-60067)
Landscape PDF Input
RotatedPDFpagesarenowfullysupportedinPDFinputfiles.TheDataMapperdisplaysthepagesina
human-friendlywaythatallowsyoutoselectandextractdataaccordingtotheorientation.Thisallows
theDataMappertoprocessPDFsthatareeithercompletelylandscapeorwhichcontainamixofpor-
traitandlandscapepages.(SHARED-37879)
Dynamic XPATH values
TheRepeatStep,inXMLmode,cannowusedynamicXPATHsyntax.ThisallowstheRepeatstepto
loopthroughasubsetoftheentirerecordwithouthavingtouseconditionstodeterminewhethereach
elementmeetsaspecificcondition.(SHARED-60081)
Forinstance,theXPATHstatementforaRepeatstepcouldcontainsomethinglike:
=./address[@state="{automation.jobInfo.JobInfo9}"]
Thiswouldgetconverteddynamicallytosomethinglike./address[@state="California"]
basedonthevalueofJobInfo(9).
Page 1461