How to find a flowitem using value after pushing to global list?

Question

question

JIANYUAN, HALLEY L asked Mar 23, '20 Braydn T answered Mar 24, '20

How to find a flowitem using value after pushing to global list?

Hello all,

I am trying to set a condition where if an item.Type has a certain value they will get pulled to a certain processor. However, I have to use a global list for other functions and am unable to use the port to case option for output.

I woud like for processors to pull the item based on their value instead. Upon looking through the manual I have came up with various functions like:

List("Name").entries()[1].value == 1

List("Name").stats.input.value == 1

Variant value= item.Type;

value== 1 (I suspect this didn't work as items were pushed to the global list)

From my understanding, this would set off the condition where item gets pulled if the value is correct. Is there a way to find out the value from before items were pushed to the global lists?

On a side note, could it work if the condition was value == 1 || value == 3 (ie the processor would pull if value was either 1 or 3)?

Software Version:

FlexSim 20.0.0

process flow global table pull strategy

Answer 1 · 2020-03-24T12:44:37Z

Braydn T answered Mar 24, '20

@JIANYUAN, HALLEY L

Lists in flexsim use SQL. Here is a link to our documentation that should help clarify this: https://docs.flexsim.com/en/20.0/Reference/Tools/GlobalLists/FunctionalReference/

Go into the list settings and check that there is a field in the list that represents the type like this:

and then in the pull from list in the query field, you can use a SQL query like this:

WHERE Type == 1.

Make sure Type in both places has the same capitalization.

list.png (13.8 KiB)

question