question

Ruben M4 avatar image
0 Likes"
Ruben M4 asked Joerg Vogel commented

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.

FlexSim 19.2.4
list pull from listpull query
· 1
5 |100000

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 avatar image Begoña Espiñeira commented ·

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!


1625738889372.png

1625738940333.png

2 Likes 2 ·
1625738889372.png (31.9 KiB)
1625738940333.png (15.0 KiB)
Joerg Vogel avatar image
1 Like"
Joerg Vogel answered Joerg Vogel commented
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

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

Joerg Vogel avatar image Joerg Vogel commented ·

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.

local-list-properties.png proposal2-10_JV.fsm

1 Like 1 ·
Ruben M4 avatar image Ruben M4 commented ·

proposal2_10.fsm

it doesn't work neither

0 Likes 0 ·
proposal2-10.fsm (45.2 KiB)
Joerg Vogel avatar image Joerg Vogel Ruben M4 commented ·
@Ruben M4 , Please see my latest comment under my answer! Thanks!
0 Likes 0 ·
José Antonio MD avatar image
1 Like"
José Antonio MD answered Ruben M4 commented

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




· 5
5 |100000

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

Ruben M4 avatar image Ruben M4 commented ·

Hi and thanks for your answer.

I did what you said, but I continue having prblems with the SqlQuery screenshot-1.png


0 Likes 0 ·
screenshot-1.png (196.9 KiB)
José Antonio MD avatar image José Antonio MD Ruben M4 commented ·

Hello,

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

In your example you should use something like this:

1625739952858.png


0 Likes 0 ·
1625739952858.png (49.1 KiB)
Ruben M4 avatar image Ruben M4 commented ·

proposal2_10.fsm

it doesn't work either

0 Likes 0 ·
proposal2-10.fsm (45.2 KiB)
José Antonio MD avatar image José Antonio MD Ruben M4 commented ·

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/).

1625740940909.png

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").

1625740899092.png


1 Like 1 ·
1625740899092.png (100.2 KiB)
1625740940909.png (38.8 KiB)
Ruben M4 avatar image Ruben M4 José Antonio MD commented ·

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

It was the info type for TipoCable.

0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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