question

Tee Hiett avatar image
0 Likes"
Tee Hiett asked Tee Hiett commented

what is the syntax to get the value of a field from a Global List?

SQL Query.jpg

As shown In the attached picture, I want enter to an SQL into the Case Function which will return the value of the field Elevators WHERE Elevators > 0 AND Priority = 0 ORDERED BY utilization. That value will be used to send the patient to an appropriate elevator door.

Thanks,

Tee

FlexSim 20.1.3
flexsim 20.1.3healthcaresqlglobal lists
sql-query.jpg (340.7 KiB)
· 2
5 |100000

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

1 Answer

Matthew Gillespie avatar image
1 Like"
Matthew Gillespie answered Tee Hiett commented

First of all, that syntax by itself isn't going to work. You would need to use a Pull from List activity or use the Table.query() method, or something.

However, since it looks like you're just trying to find an available elevator for patients to enter the model through, I would just use the Acquire Location activity and add a step to the patient's flow for Entering via Elevator. Look at this model where I create the patient in a different spot, then acquire an elevator, and then move the patient into that elevator.

openclose-glass-doors-20-1-a-1_EntryElevator.fsm


· 1
5 |100000

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