Unanswered question

Can the SQL Statement action be set to rerun a query?

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.

Michael M.
Michael M.

Michael M.

Level
0
43 / 100
points

Answers

Nouredine A.
Nouredine A.

Nouredine A.

Level
4
5000 / 5000
points
Team

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?

Michael M.
Michael M.

Michael M.

Level
0
43 / 100
points

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.

Michael M.
Michael M.

Michael M.

Level
0
43 / 100
points

Any word on this?

Nouredine A.
Nouredine A.

Nouredine A.

Level
4
5000 / 5000
points
Team

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?