Sidebar

Can I change a source node DB Query SQL Statement at run-time?

0 votes
334 views
asked Sep 14, 2015 by chris-m-8014 (760 points)
I'm trying to change a source node SQL statement at run-time with a scheduled script that runs every time the channel runs.  Is this possible?

1 Answer

0 votes
I worked with Brandon on a solution.  I was trying the modify the query of a source node during the runtime of the channel.  Since that wasn't possible, Brandon steered me toward another solution.  He had me use a CSV source node and then in it's custom script, find the query I wanted to run in a lookup table and then run it with qie.doQuery.  Then I loop through the recordset and add the query result with qie.addInboundMessage.

This worked great!
answered Sep 15, 2015 by chris-m-8014 (760 points)
...