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

Question

question

Tee Hiett asked Jan 08 2020 at 5:17 PM Matthew Gillespie commented Jan 10 2020 at 8:44 PM

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

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

Software Version:

FlexSim 20.0.0

tables where query

sql-flexsim.jpg (60.0 KiB)

21327-restaurantsample-6.fsm (3.4 MiB)

· 3

Matthew Gillespie ♦♦ commented · Jan 08 2020 at 5:19 PM

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

0 ·

Braydn T commented · Jan 08 2020 at 5:30 PM

@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.

0 ·

Tee Hiett Braydn T commented · Jan 08 2020 at 7:29 PM

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?

0 ·

______

Cookie preferences

Your privacy is important to us and so is an optimal experience. To help us customize information and build applications, we collect data about your use of this site.

May we collect and use your data?

Learn more about the Third Party Services we use and our Privacy Statement.

Strictly necessary – required for our site to work and to provide services to you

These cookies allow us to record your preferences or login information, respond to your requests or fulfill items in your shopping cart.

YES

Improve your experience – allows us to show you what is relevant to you

These cookies enable us to provide enhanced functionality and personalization. They may be set by us or by third party providers whose services we use to deliver information and experiences tailored to you. If you do not allow these cookies, some or all of these services may not be available for you.

YES

NO

Customize your advertising – permits us to offer targeted advertising to you

These cookies collect data about you based on your activities and interests in order to show you relevant ads and to track effectiveness. By collecting this data, the ads you see will be more tailored to your interests. If you do not allow these cookies, you will experience less targeted advertising.

YES

NO

Are you sure you want a less customized experience?

We can access your data only if you select "yes" for the categories on the previous screen. This lets us tailor our marketing so that it's more relevant for you. You can change your settings at any time by visiting our privacy statement

Your experience. Your choice.

We care about your privacy. The data we collect helps us understand how you use our products, what information you might be interested in, and what we can improve to make your engagement with Autodesk more rewarding.

May we collect and use your data to tailor your experience?

Explore the benefits of a customized experience by managing your privacy settings for this site or visit our Privacy Statement to learn more about your options.

Answer 1 · 2020-01-09T00:11:22Z

Matthew Gillespie answered Jan 09 2020 at 12:11 AM Matthew Gillespie commented Jan 10 2020 at 8:44 PM

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

sql.png (7.2 KiB)

newquery.png (8.4 KiB)

restaurantsample20.fsm (3.4 MiB)

· 2

Tee Hiett commented · Jan 10 2020 at 8:24 PM

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

0 ·

Matthew Gillespie ♦♦ Tee Hiett commented · Jan 10 2020 at 8:44 PM

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.

0 ·

question