Sunday 24 March 2019

python - Writing SQL WHERE Clause using Multiple Choice values in FME?


I published a parameter which is of Choice Multiple type. I wish to use values from this parameter for WHERE Clause when Reading Inputed Data in the begin of Workbench.


So there is no problem if I have type of published parameter just Choice, then I use following:


WHERE Clause Tile = '$(Name)' 


but I do not know how to write SQL WHERE Clause statement if I have Multiple Choice and want to read all data for Name of Tiles selected in Multiple Choice, because SQL form above does not work ...


Example:


In multiple choice i select the names: Anna, John, Tim. Then, I want that data for tiles that have those names are read.



Answer



FME 2012 Beta (nightly build) has introduced:


===========================================================================
=========================== BUILD 12130 20110818 ===========================
===========================================================================
SQLExecutor and SQLCreator: Implemented support for multiple SQL

statements through the FME_SQL_DELIMITER. Implemented ability to ignore
SQL errors by prefixing statements with a
hyphen (C40056 C40314 C42660 PR#29343)

ftp://ftp.safe.com/fme/beta/whatsnew.txt


Beta Builds available ftp://ftp.safe.com/fme/beta/


(Not tested it yet but will be doing so in the near future)


No comments:

Post a Comment

arcpy - Changing output name when exporting data driven pages to JPG?

Is there a way to save the output JPG, changing the output file name to the page name, instead of page number? I mean changing the script fo...