2022.2

ManualsBrandsObjectif Lune ManualsApplicationsPlanetPress Connect

311

312

313

314

315

316

317

318

319

320

Table Of Contents

l

ISO8601:Thissettingallowsfordateswithdifferenttimestampformats,orbelongingtodif-

ferenttimezones,tobeparsedinsideasinglejob.Datesthatdonotincludeaspecifictime

areautomaticallyconsideredtousethecurrentlocale'stimezone.

SelecttheISOtemplatetobeusedwhenparsingthetimestamp.OtherISO8601formats

canbehandledviatheCustomoption.

l

Custom:Setacustomdateformat.ForthemarkersavailableintheDataMappersee

"Date"onpage278.

l

Date Language:Setthelanguageforadatevalue(ex:IfEnglishisselected,thetermMaywill

beidentifiedasthemonthofMay).

l

Use offset from UTC:Selectthedefaulttimezone,whichistobeusedtoextractanytimestamp

thatdoesnotalreadyincludetimezoneinformationwiththetime.

Note: DefaultdataformatstelltheDataMapperhowcertaintypesofdataareformattedin the

data source.Theydon'tdeterminehowthesedataareformattedintheDataModelorinatem-

plate.IntheDataModel,dataareconvertedtothenativedatatype.Dates,forexample,arecon-

vertedtoaDateTimeobjectintheDataModel,andwillalwaysbeshownas"year-month-day"

plusthetimestamp,forexample:2012-04-1112.00AM.

SQL Query Designer

TheSQLQueryDesignerisusedtodesignacustomSQLquerytopullinformationfromadatabase.It

canbeopenedbyclickingthe Custom SQLbuttonontheSettingspane,underInputData.

l

Tables:Listsalltablesandstoredqueriesinthedatabase.

l

Custom Query:Displaysthequerythatretrievesinformationfromadatabase.Youmayusevari-

ablesandpropertiesinthequery,tomaketheselectiondynamic.See"Usingvariablesandprop-

ertiesinanSQLquery"below.

EachdatabasetypehastheirownversionoftheSQLquerylanguage.Tolearnhowtobuildyour

ownquery,pleaserefertoyourdatabase'susermanual.

l

Test Querybutton :Clicktotestthecustomquerytoensureitwillretrievetheappropriate

information.

l

Results:DisplaystheresultoftheSQLquerywhenclickingonTest Query.

Using variables and properties in an SQL query

WhenyouusevariablesandpropertiesinanSQLquery,theselectionwillbedynamicallyadjusted

eachtimethedatamappingconfigurationisactuallyusedinaWorkflowprocess.

TocreateadynamicSQLquery:

Page 320