Global Variable used correctly?
I have a very long string (469 characters comma-separated quoted list) that I have set in a global variable.
The global variable content is in a similar form to this: 'a','b','c','d'
I am attempting to use this in the full query for a table in the WHERE clause using the IN operator like so:
select col1, col2 from sqlTable where col1 in ($$gv_list)
When I save and try to run this, no rows are loaded. I am using version 4.9.7.
This may be possible depending on which database you are using.
I tried something similar using MySQL database as a source and was able to do your use case.
This 3 minute video shows how to do this use case: