1.2k questions

1.4k answers

361 comments

339 users

Categories

Sidebar
0 votes
619 views
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!
by chris-m-8014 (760 points)
...