How to configure SQL Filter in Push from List

Question

question

WillRS asked Oct 4, '24 WillRS commented Oct 5, '24

How to configure SQL Filter in Push from List

In this model, I need to pull a dock from a list (Lista Docas), based on the Label Destino_Caminhao that is in the tokenDocking Process.fsm

Software Version:

FlexSim 23.0.15

sql queries docking order logistic

docking-process.fsm (16.1 MiB)

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Answer 1 · 2024-10-04T06:38:54Z

Felix Möhlmann answered Oct 4, '24

The "puller" is used to pass variables into a Pull from List query. By default the puller is set to be equal to the token, so you'd simply use "puller" in place of "token".

capture1.png (19.5 KiB)

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Answer 2 · 2024-10-04T16:50:30Z

Gustavo Teodoro answered Oct 4, '24 WillRS commented Oct 5, '24

Try using WHERE puller.Destino_Caminhao == Destino_Fabrica. In this case, you are specifying that Destino_Caminhao (in the token) must be equal to Destino_Fabrica (the label in the list). The model is attached.

docking-process.fsm

docking-process.fsm (102.9 KiB)

· 1

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

WillRS commented · Oct 05 at 12:09 PM

Thanks!

This works correctly

0 ·

question