pull from list question

Question

question

Jimmy jang asked Dec 17 2024 at 3:04 AM Logan Gold commented Jan 07 2025 at 6:23 PM

pull from list question

Good day

i am making a model which using pull from list.

The push value is token.XX.subnodes.toArray()

and while pulling i have write the query

WHERE Type BETWEN Table("xx")[token.x][token.y] AND Table("xx")[token.x][token.z]
but it failed so i have change the query to

WHERE Type BETWEEN token.Min AND token.Max

but it is keep failing

may i know what i am doing wrong?

Best regards

Software Version:

FlexSim 24.2.1

pull from list

· 3

Joerg Vogel commented · Dec 17 2024 at 3:14 AM

@Jimmy jang, can you attach an example model? Please describe what values you are requesting from list value fields. Thanks.

0 ·

Jimmy jang Joerg Vogel commented · Dec 17 2024 at 4:29 AM

Sorry for the inconvenience.

Currently I can not upload my file.

However to be more clear about my question.

There are item inside a Tote which has label call Type and the number is random number from 1-100.

When It arrive at picking station I want to pull item from the tote using pull from list.

The query I used initially was

WHERE Type BETWEEN 1 AND 20

However since there are multiple station which require specific range of item. For example 1st 1~20, 2nd 21~40, 3rd 41~60 .....)

So I made made a table call "range" to make a reference of Min and max of range.

So I have write the query

WHERE Type BETWEN Table("range")[token.min][1] AND Table("range")[token.max][1]

In my thinking

Table("range")[token.min][1] Is 1

and

Table("range")[token.max][1] is 20

So this query should be meaning

WHERE Type BETWEEN 1 AND 20

may I know if in query can I write as below? Or is the format is incorrect?

WHERE Type BETWEN Table("range")[token.min][1] AND Table("range")[token.max][1]

Thank you in advance

0 ·

Logan Gold ♦♦ commented · Jan 07 2025 at 6:23 PM

Hi @Jimmy jang, was Joerg Vogel's answer helpful? If so, please click the "Accept" button at the bottom of 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 comment back to reopen your question.

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 · 2024-12-17T05:10:02Z

Joerg Vogel answered Dec 17 2024 at 5:10 AM Jimmy jang commented Dec 17 2024 at 8:21 AM

A query expects a string. You can compose a string. Instead of evaluating a table value in a query directly you can assign table values to a numerical variable and convert this into a string.

string.fromNum(num value)

string combineStr = string1 + string2 + string3;

If your query with static values is working, a concatenated string should work, too.

Here is an example:

Pull_between_lookup_table.fsm

pull-between-lookup-table.fsm (37.9 KiB)

· 3

Jimmy jang commented · Dec 17 2024 at 6:40 AM

Thank you for your prompt reply.

Until now i have founded out that table value should be assign to token label.

Therefore, i have use each query as below and succeed

WHERE Type = puller.Min

and

WHERE Type = puller.Max

However what i need is to pull is the range between min and max

Which i was using was

WHERE Type BETWEEN puller.Min AND puller.Max

and it failed.

May i know how should i change the format?

0 ·

Joerg Vogel Jimmy jang commented · Dec 17 2024 at 7:37 AM

@Jimmy jang, I edited my answer and attached an example

string qstr = "WHERE Type BETWEEN ";
qstr += string.fromNum(token.colMin);
qstr += " AND ";
qstr += string.fromNum(token.colMax);
print(qstr);
List.PullResult pulled = List("pushedItems").pull(qstr,5,5);
token.labels.assert("pulled",pulled).value = pulled;

above is the main structure of an concatenated string for a pull query string

0 ·

Jimmy jang Joerg Vogel commented · Dec 17 2024 at 8:21 AM

thank you it worked, still i will need to study your comments!

i really appreciate your support!

0 ·

question