topic Re: where is the table for the Where statement in restaurant model? in FlexSim Forum

where is the table for the Where statement in restaurant model?

tee_hiett — Wed, 08 Jan 2020 17:17:53 GMT

[ FlexSim 20.0.0 ]

sql-flexsim.jpg 21327-restaurantsample-6.fsm

I am studying (and modifying) the FlexSim restaurant sample to learn more about FlexSim. I understand what the Where statement in the Sit activity does but I don't know how to access the source table(s). I would appreciate some direction here. Thanks, Tee

Re: where is the table for the Where statement in restaurant model?

Matthew_Gillespie — Wed, 08 Jan 2020 17:19:38 GMT

I'm not sure what you're asking. What do you mean by source tables?

Re: where is the table for the Where statement in restaurant model?

braydn_t — Wed, 08 Jan 2020 17:30:45 GMT

@Tee Hiett

TableAndChairs is the group TableAndChairs. If you go to Toolbox > Groups > People > Locations > TableAndChairs You will see all the members of that group that the SQL Statement is drawing from.

Re: where is the table for the Where statement in restaurant model?

tee_hiett — Wed, 08 Jan 2020 19:29:39 GMT

I can see the Global Lists Locations contains the values for Priority and occupancy that the Where statement needs. How can I see the entire SQL statement?

Re: where is the table for the Where statement in restaurant model?

Matthew_Gillespie — Thu, 09 Jan 2020 00:11:22 GMT

The Location field on the Table location resource is showing the entire SQL statement:

WHERE TableAndChairs AND Priority = 0 AND occupancy >= Puller.PartySize ORDER BY occupancy

This model was built last year when the only option for writing a custom query was to write the entire thing yourself in that top field. However, in 20.0 we added two more fields to the resource activities to make it easier to write custom queries. So in 20.0 to get the same effect you would configure the activity like this:

Here's an updated model where I made that change: restaurantsample20.fsm

Re: where is the table for the Where statement in restaurant model?

tee_hiett — Fri, 10 Jan 2020 20:24:54 GMT

The original sql had priority equal 0. The SQL you created that priority equals 150. The model seems to run perfectly with either value, in fact, with another value. Why was priority included? Is there any way I can see this code?

Thanks,
Tee

Re: where is the table for the Where statement in restaurant model?

Matthew_Gillespie — Fri, 10 Jan 2020 20:44:18 GMT

When it says "Priority = 0" that's referring to the Priority label on the tables. That statement is saying to only acquire something that hasn't already been acquired. You need this statement or tables that were already acquired can be acquired again before they're released.

The Priority field in the Resource's properties is the Priority value of requests made when you acquire. That way if there are multiple requests for a table, the one with the highest priority will get the next available table.

What code do you want to see? You shouldn't need to look at any code. If you just fill out the 4 fields on the Resource properties it will plug all the pieces in and write the SQL for you.