"Formatting several Read Database queries at once"

jaakko1jaakko1 MemberPosts:8Contributor I
edited June 2019 inHelp
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_BoeckMarco_Boeck Administrator, Moderator, Employee, Member, University ProfessorPosts:1,984RM 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 InorRegisterto comment.