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

Question

question

David Besson asked Jun 28, '16 David Besson commented Jun 28, '16

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

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

Software Version:

FlexSim 16.1.0

process flow list

capture.png (14.2 KiB)

how-to-set-a-pull-from-list-activity-with-query-in.fsm (23.6 KiB)

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.

Answer 1 · 2016-06-28T14:23:43Z

Phil BoBo answered Jun 28, '16 David Besson commented Jun 28, '16

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

sql-in-array.png (59.8 KiB)

sql-query-label.png (87.4 KiB)

query-in-array.fsm (24.4 KiB)

query-in-string-label.fsm (24.0 KiB)

· 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.

David Besson commented · Jun 28, 2016 at 03:20 PM

Thanks!

0 ·

question