List fields and list queries

Question

question

Thomas JR asked Oct 9, '20 Ben Wilson commented Oct 14, '20

List fields and list queries

I have a "Pull from list" - activity with the query

WHERE Booking_ID = puller.Booking_ID

The global list from which I pull the ressources is named "Exam rooms".

I have assigned the label "Booking_ID" to each exam room 3D object, and all exam rooms have been added to the "Exam rooms" list.

However, in the "Fields" - tab of the list properties I have not added a field named "Booking_ID" but my model still works as intended.

I was just wondering whether or not this is to be expected?

I thought FlexSim went through the fields defined in the "Fields" - tab of the list, but it seems to be smart enough to search for the field "Booking_ID" on the objects contained within the "Exam rooms" list themselves.

Software Version:

FlexSim 20.1.3

flexsim 20.1.3 list sql queries

· 1

Ben Wilson ♦♦ commented · Oct 14, 2020 at 05:39 PM

Hi @Thomas JR, was Matthew Gillespie's answer helpful? If so, please click the red "Accept" button on their answer. Or if you still have questions, add a comment and we'll continue the conversation.

If we haven't heard back from you within 3 business days we'll auto-accept an answer, but you can always unaccept and comment back to reopen your question.

0 ·

Answer 1 · 2020-10-09T16:46:21Z

Matthew Gillespie answered Oct 9, '20

Booking_ID is first assumed to be a field on the list, but if there isn't a field with that name then it is assumed to be a label. From the documentation:

Accessing Labels

If a field that you define in your SQL query is not a defined field on the List, then the query will retrieve the label value of the same name on the entry's value object.

WHERE SKU = "05692AQD"

In this example, if SKU has not been defined as a field on the List, and let's say it is an Item List, the query will retrieve the label named "SKU" on the items that have been added to the List, and compare it against "05692AQD".

https://docs.flexsim.com/en/20.2/Reference/Tools/GlobalLists/FunctionalReference/#QuerySyntax

question