Using Global Macro in Query ?

Question

question

Aditya Prakash asked Jul 25, '16 Ben Wilson edited Jul 26, '16

Using Global Macro in Query ?

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.

Software Version:

FlexSim 16.1.0

query

· 2

Joerg Vogel commented · Jul 25, 2016 at 07:53 AM

Maybe different datatype?

0 ·

Aditya Prakash Joerg Vogel commented · Jul 25, 2016 at 08:01 AM

No Jörg, both are num for sure.

0 ·

Answer 1 · 2016-07-25T19:44:39Z

Jordan Johnson answered Jul 25, '16 Ben Wilson edited Jul 26, '16

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.

· 1

Aditya Prakash commented · Jul 26, 2016 at 05:25 AM

@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

0 ·

question