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

Question

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?

Answer 1

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!