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

Question

question

Tee Hiett asked Sep 15, '20 Tee Hiett commented Sep 16, '20

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

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

Software Version:

FlexSim 20.1.3

flexsim 20.1.3 healthcare sql global lists

sql-query.jpg (340.7 KiB)

· 2

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.

Jeff Nordgren commented · Sep 15, 2020 at 05:55 PM

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 ·

Tee Hiett Jeff Nordgren commented · Sep 15, 2020 at 06:53 PM

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

Model attached.

0 ·

openclose-glass-doors-20-1-a-1.fsm (161.5 KiB)

Answer 1 · 2020-09-15T23:08:00Z

Matthew Gillespie answered Sep 15, '20 Tee Hiett commented Sep 16, '20

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

openclose-glass-doors-20-1-a-1-entryelevator.fsm (69.7 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.

Tee Hiett commented · Sep 16, 2020 at 04:50 PM

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 ·

question