Doubt with Pull from List

Question

question

Ruben M4 asked Jul 8, '21 Joerg Vogel commented Jul 8, '21

Doubt with Pull from List

Good morning everybody!

I would like to make a list request based on a token tag that is going through the "Pull from list" operation. In this case in the FlexSim User Manual I see references to the WHERE command used with numbers, for example:
WHERE WHERE ID = 2, WHERE ID > 1 or WHERE Name = 'Operator2'

But I don't see any reference where you can access to the the label value of a token. I imagine it will be something like that:

WHERE ID = puller.ID or WHERE ID = token.ID

But I can't get the request right.

Software Version:

FlexSim 19.2.4

list pull from list pull query

· 1

5 |100000

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

Begoña Espiñeira commented · Jul 08, 2021 at 10:16 AM

Good morning @Ruben M4

To access the token label you have to put WHERE ID = puller.ID. As you can see the puller has the token assigned. On the other hand you have to have the ID tag as a list field.

I hope it helps!

2 ·

1625738889372.png (31.9 KiB)

1625738940333.png (15.0 KiB)

Answer 1 · 2021-07-08T10:40:25Z

Joerg Vogel answered Jul 8, '21 Joerg Vogel commented Jul 8, '21

WHERE ID = puller.ID

would be correct. You need to address the Puller in your Picklist property or Process Flow activity.

List_Puller_PF.fsm

list-puller-pf.fsm (33.5 KiB)

· 3

5 |100000

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

Joerg Vogel commented · Jul 08, 2021 at 11:12 AM

Naturally you must set the label under List "Advanced" properties to be present in your List.

As I did that, there was still the same behavior. As I converted the label and list entry field to be numbers the query worked.

proposal2-10_JV.fsm

1 ·

local-list-properties.png (14.0 KiB)

proposal2-10-jv.fsm (43.3 KiB)

Ruben M4 commented · Jul 08, 2021 at 10:31 AM

proposal2_10.fsm

it doesn't work neither

0 ·

proposal2-10.fsm (45.2 KiB)

Joerg Vogel Ruben M4 commented · Jul 08, 2021 at 11:15 AM

@Ruben M4 , Please see my latest comment under my answer! Thanks!

0 ·

Answer 2 · 2021-07-08T10:14:46Z

José Antonio MD answered Jul 8, '21 Ruben M4 commented Jul 8, '21

Hello.

See "Puller" in Pull activity options, you will see by default its reference is "token". If you use "puller" insted of "token", you can filter using this information.

I hope I have been helpful.

19.1. Ejemplo Pull filter.fsm

191-ejemplo-pull-filter.fsm (22.9 KiB)

· 5

5 |100000

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

Ruben M4 commented · Jul 08, 2021 at 10:23 AM

Hi and thanks for your answer.

I did what you said, but I continue having prblems with the SqlQuery

0 ·

screenshot-1.png (196.9 KiB)

José Antonio MD Ruben M4 commented · Jul 08, 2021 at 10:26 AM

Hello,

If you see my example, I use "puller" in Query no "token".

In your example you should use something like this:

0 ·

1625739952858.png (49.1 KiB)

Ruben M4 commented · Jul 08, 2021 at 10:32 AM

proposal2_10.fsm

it doesn't work either

0 ·

proposal2-10.fsm (45.2 KiB)

José Antonio MD Ruben M4 commented · Jul 08, 2021 at 10:45 AM

If you filter information in the list, you need this information in the list. Please create Field in the list advance options (see user manual:https://docs.flexsim.com/en/19.2/Reference/ProcessFlowObjects/SharedAssets/List/).

If I check your logic, you have another problem, in the Push Activity your label is a number and a string in the Pull Activity, both have to be the same info type (update TipoCable to number info: right click and "Assign Number Data").

1 ·

1625740899092.png (100.2 KiB)

1625740940909.png (38.8 KiB)

Ruben M4 José Antonio MD commented · Jul 08, 2021 at 10:54 AM

@José Antonio MD it is working. Thank you so much.

It was the info type for TipoCable.

0 ·

question