Neotys.com

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
Answer count
4 answers
Category
General
Author name
Michael M.
Date
June 14, 2017
almost 7 years ago
Hits
viewed 432 times
question
q

Answers

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?

Author name
Nouredine A.
Date
answer
a
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.

Author name
Michael M.
Date
answer
a
Michael M.
Michael M.

Michael M.

Level
0
43 / 100
points

Any word on this?

Author name
Michael M.
Date
answer
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?

Author name
Nouredine A.
Date
answer
a