Using Global Macro in Query ?

[aditya_prakash1]

[ FlexSim 16.1.0 ]

Why query doesn't support Global Macros ? When I write this "WHERE (puller.active_flag == ON AND shift_query == ON)" instead of "WHERE (puller.active_flag == IsActive() AND shift_query == IsActive())" flexsim gives the error "exception: Invalid SqlQuery object". On the other hand IsActive() query works perfectly.

PA: IsActive() just returns the global macro ON.

[joerg_vogel_HsH]

Maybe different datatype?

[aditya_prakash1]

No Jörg, both are num for sure.

[JordanLJohnson · Accepted solution]

This is a known issue. If you are using the query command in FlexScript, you can use the $ syntax, and use the macro as an appropriate argument.

query("WHERE puller.active_flag == $1 AND shift_query == $1", ON)

If you are using the Pull From List activity in Process Flow, you can make a user command, as you demonstrated above. You could also look in to using a list field.

[aditya_prakash1]

@jordan.johnson, Thanks, you have previously answered it on this thread as well.

https://answers.flexsim.com/questions/22117/global-macros-not-evaluated-in-process-flow-querie.html