I need to run a sql statement to determine if my workspace should run. If the sql statement returns any records, then I need to terminate the flow. If nothing is returned then it is okay to run the workspace. I would like to pass in a user parameter as a string to be used in the sql statement. Is this possible?
Solved
Can you run a SQLExecutor transformer that takes a string as a parameter and uses it as part of the SQL statement to be executed?
Best answer by redgeographics
In short: yes, you can build the query using attribute values, parameters etc.
You should probably look into the NoFeaturesTester to check if nothing comes back too
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.