I extracted and transformed worksite records from a Oracle dB and stored them in a PostGIS dB. There are about 700 worksite records having a unique ID.
I need to extract additional worksites from the Oracle dB based on some spatial queries, which I only want to execute in close proximity of the 700 initially selected sites.
For this I want to use SQL creators transformers and in the WHERE clause of the query I would like to be able to use something as :
WHERE ID in $(id_list)
$(id_list) would be the list of my 700 initial records (78748, 48575, 05843, 47585, etc.)
Do I have to do this using a multiple choice parameter as suggested at Writing SQL WHERE Clause using Multiple Choice values in FME?
I can't seem to open the documentation to fully understand this solution.