How use a Global Table in a query to pull from a list?

Question

question

Tee Hiett asked Feb 1, '21 Tee Hiett edited Feb 2, '21

How use a Global Table in a query to pull from a list?

In adapting this attached COVID-10 vaccination model to an unusual location, I've had to adjust the Observation Lanes. I have built a global table ObsLanesCapacity with the capacity for each lane. I cannot figure out how to use this table in the query to Pull from Observation Lanes in the Wait for Observation content box. My latest attempt is WHERE Lane == Puller.LaneNum AND queueSize < Table("ObsLanesCapacity") [1][Puller.LaneNum]."

Thanks for your help

Software Version:

FlexSim 21.0.1

global table healthcare lists flexsim 21.0.1

covid-19-vaccination-hoover-met-2.fsm (568.0 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 1 · 2021-02-01T21:56:18Z

Parker S answered Feb 1, '21 Tee Hiett edited Feb 2, '21

I believe an easier solution would be to store the Observation Lane capacity as a label on the Lanes themselves and include that label on your "ObservationLanes" list. Then your query would be this:

WHERE ObservationLanes = puller.LaneNum AND queueSize < Capacity

support_covid-19-vaccination-hoover-met-2.fsm

support-covid-19-vaccination-hoover-met-2.fsm (568.5 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 · Feb 01, 2021 at 10:52 PM

Thanks, @Parker S Nice solution!!!! Now, how can I get cars from the Vacation10 or Vacation2_10 spots go to ObservationLane10 Or ObservationLane11 whichever has the fewer cars?

0 ·

question