Dynamic Input Group Replacement with PostgreSQL

Question

Hi,

I have a dynamic input tool that I am using that takes a list of companies and searches a broader list for matches using 'ilike' in postgresql.

The workflow runs with no group replacement for the SQL IN clause however this is very slow as it is calling each query individually, however when I try and use the group replacement to speed things up the tool errors saying: Error Opening "Select ..." no columns returned.

Any ideas what might be causing this or any potential workarounds? I have tried changing the character limits with no luck

Thanks

BLamb · Answer

the modify then replaces the 000000 with the replacement field.

As I say, it works fine when running individually it just takes too long as each query is executed individually

BLamb · Answer

Hi, thanks for reaching out on this - apologies for my delay in replying!

The where clause is written like this: where column ilike '%000000%'

When I look at the error from the workflow, it looks as though it is creating the dynamic input statement as: 
where column ilike '%'abc', 'xyz'%'

Im not sure if this is the correct syntax for postgre as I have only been using it for a few weeks.

Thanks for any insight you can give

alexnajm · Answer

How do you have your list of companies replacing the placeholder value? What is your WHERE clause?