Set Up a User Parameter to handle Multiple Text results For SQL 'IN' Operator

Hi @jberneathy,

You can do this by creating a Published Parameter in the Navigator under User Parameters. Set the type to 'Choice' and then in the configuration you can add in the different text values for the user to choose from. You can then use this parameter in your SQL query.

Your parameter definition:

And the code to build the query:

The StringReplacer replaces the spaces by (',') when more than one code is selected.

Workspace is attached.

I don't think that will cover all options.

Unless it has been improved, one of the problems is comma's spaces special characters etc..

Therefore I prefer to use multi choice parameter with alias. I then replace the spaces with commas. This averts the nescissity to handle all the specialcharacters etc.

The double regsub is caused by a irritating and still lasting problem in the way fme handles commas in the regexp.

So in this example, choosing all options

1 0 7 5 3 8 6 4 2 9 is transformed to 1,0,7,5,3,8,6,4,2,9 by the scripted parameter (TCL)

When called by a WSR I have the string parsed in a transformer as the tcl scripted parameter are not run. (at least at the time I build this. It is upgraded to latest version now and still works)

(it is a custom transformer with a lot of options to access a lot of dataset/bases whilst using some polygon as filter. Single transformer map builder.)