AnsweredAssumed Answered

How do I add dynamically set parameters to a DB query

Question asked by jvayle448913 on May 8, 2018
Latest reply on May 18, 2018 by leif_jacobsen

So basically, I am trying to query our database to pull out every customer record that has a paticular company ID. Right now, I wrote a process that pulls out ALL of the company records, and returns them in a flat file(CSV) and it works fine (see picture below). What I want to do now is basically add a parameter to that query. Ideally, this could be easily set before the execution of the process itself and then persist across multiple executions of the process unless it is manually changed by the user. I have looked at some of the documentation around process properties and stuff but I feel very lost so a little help and direction would be great. Thank you in advance for any help you can provide!

 

Photo of current process

Outcomes