question

mm_y_2406 avatar image
0 Likes"
mm_y_2406 asked Felix Möhlmann commented

Query WHERE filter

Hello, I am trying to pull a specific task of the list WHERE it only pulls the task with Station Labelled to the 3D object named WH4Outbound. I wrote it as: WHERE Station == Model.find("WH4Outbound") However, what I wrong doesn't seem to work, can you let me know what am I supposed to write in the Query? 1725363755093.png

FlexSim 24.1.0
sql querypull query
1725363755093.png (123.9 KiB)
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

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

1 Answer

Jason Lightfoot avatar image
0 Likes"
Jason Lightfoot answered Felix Möhlmann commented

Assign the object pointer to a label on the puller called 'station' and then use WHERE Station=puller.station

· 2
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

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

mm_y_2406 avatar image mm_y_2406 commented ·
This works. Thank you. I have another question: is it not possible to choose a specific station from the Where query without having a label on the puller?
0 Likes 0 ·
Felix Möhlmann avatar image Felix Möhlmann mm_y_2406 commented ·

You can add an expression field that returns the name of the object and compare a string to that in the query. This will of course lead to errors if you also have values on the list that do not have a 'name'.

1725373903855.png

1725373915484.png

0 Likes 0 ·
1725373903855.png (8.2 KiB)
1725373915484.png (2.3 KiB)