I am using SQL to populate a shared queue variable (with JavaScript), but when the variable is exhausted I want to rerun the SQL to fill it up again - but it seems that it will not re-execute - I've added a timestamp to the query and it never changes.
How do you execute your SQL statement? Is it inside your Javascript or through a SQL advanced action?
Could you describe a little bit what you are doing?
I am using the SQL advanced action. Each time a shared queue is empty I want to rerun the SQL and use a script to repopulate the shared queue. I have this all working except I never seem to get new results from the SQL statement.
Any word on this?
I'm not able to reproduce that behavior. I feeding a shared queue with a SQL statement from a SQL advanced action. I consume the values and each time the SQL statement is executed the shared queue is filled again.
Your design may be different. Could you provide more information on how and when you fill your shared queue in your script?
