topic Re: How to set a Pull from List activity with Query "IN" a label in FlexSim Forum

How to set a Pull from List activity with Query "IN" a label

david_besson — Tue, 28 Jun 2016 12:38:15 GMT

[ FlexSim 16.1.0 ]

Flowitems with itemtypes 1, 2 and 3 enter in a queue and are pushed to a list (with a Field itemtype).

A Fixed resource Process flow tells a Processor to pull the flowitems from this list, but only ones with itemtype 2 and 3. -> Activity "Pull from List" with Query "WHERE itemType IN (2, 3)":

It works, but is it possible to reference the itemtype which are pulled with a label on the Processor? Indeed, the itemtypes to pull could be different: only itemtype 1, itemtype 1 and 2, ...

A label "itemType" on the Processor with the value "(2, 3)" and the Query "WHERE itemType IN getlabel(current, "itemType")" seems wrong.

Thanks for your help!

how-to-set-a-pull-from-list-activity-with-query-in.fsm

Re: How to set a Pull from List activity with Query "IN" a label

philboboADSK — Tue, 28 Jun 2016 14:23:43 GMT

You don't have access to "current" in a Query field. You have access to "puller" (from the Puller field; the entering token in your example) and "value" (the value of each entry on the list that you are comparing to).

You can use the IN clause with an array stored on a label:

query-in-array.fsm

You could also form the query as a string on a label and then use that label:

query-in-string-label.fsm

Re: How to set a Pull from List activity with Query "IN" a label

david_besson — Tue, 28 Jun 2016 15:20:46 GMT

Thanks!