"Formatting several Read Database queries at once"

jaakko1
jaakko1 New Altair Community Member
edited November 5 in Community Q&A
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

  • Marco_Boeck
    Marco_Boeck New Altair Community Member
    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

Categories