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.

Jeff Nordgren avatar image Jeff Nordgren commented ·

Hi @tee.hiett,

As good as a graphic is, It's hard to know how to help without looking at your model. To receive a more accurate solution, please post your model or a sample model that demonstrates your question.

Proprietary models can be posted as a private question visible only to FlexSim U.S. support staff. You can also contact your local FlexSim distributor for phone or email help.

Thanks.

0 Likes 0 ·
Tee Hiett avatar image Tee Hiett Jeff Nordgren commented ·
0 Likes 0 ·

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.

Tee Hiett avatar image Tee Hiett commented ·

Thanks @matthew.gillespie That makes 2 times in one basic model you showed me the utilization of the Move activity. Maybe I'll catch on one of these days.

Tee

0 Likes 0 ·