Options

"Formatting several Read Database queries at once"

jaakko1jaakko1 Member Posts: 8 Contributor II
edited June 2019 in Help
Hello all,

I have a process with ten different "Read Database" operators that all include an SQL script with a date in them. I would like to be able to change this date on all the operators at once without having to click through all the operators and change the date individually. Is there a way to do this? Many thanks again in advance for your help.
Tagged:

Answers

  • Options
    Marco_BoeckMarco_Boeck Administrator, Moderator, Employee, Member, University Professor Posts: 1,995 RM Engineering
    Hi,

    you can use macros for that. For example, using the following query in a Read Database operator replaces the FROM clause with the macro value specified: 

    SELECT %{name} FROM test;
    To set a macro you can either define it in the process context (View -> Show View -> Context) or use one of the macro operators.

    Regards,
    Marco
Sign In or Register to comment.