question

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

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

covid-19-vaccination-Hoover-Met_2.fsm


@Matthew Gillespie

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


FlexSim 21.0.1
global tablehealthcarelistsflexsim 21.0.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.

1 Answer

·
Parker S avatar image
0 Likes"
Parker S answered Tee Hiett edited

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


· 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, @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 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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