Table reference in query, labelassignment

Question

question

Allen Greenwood asked Sep 29, '17 Phil BoBo commented Oct 2, '17

Table reference in query, labelassignment

In the attached model, why can I not use:

Table(“Parameters”)[1][1] in place of the constant 180 in The Pull From List query in Processor1? It throws an exception – value never read from table.
current.stats.output + 1 as opposed to getoutput(current) + 1 in the Set Label OnCreation trigger in the Source?

Basically, the model selects items by type until the wait exceeds a threshold then it focuses on the “old” items. Use a list query to do this.

Software Version:

FlexSim 17.2.2

label assignment lists and resources

multicriteriapullusing-list.fsm (19.8 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 · 2017-09-29T15:35:11Z

Phil BoBo answered Sep 29, '17 Phil BoBo commented Oct 2, '17

Using the query:

ORDER BY (age > gettablenum("Parameters",1,1)) DESC, Type ASC

is working fine.

I'm not sure why

ORDER BY (age > Table("Parameters")[1][1]) DESC, Type ASC

isn't working correctly.

You could put the expression into a field instead of directly into the query:

field.png (63.4 KiB)

· 2

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.

Allen Greenwood ♦ commented · Sep 30, 2017 at 11:06 AM

Thanks! You may want to see if using the dot notation, instead of the command, is a bug.

0 ·

Phil BoBo ♦♦ Allen Greenwood ♦ commented · Oct 02, 2017 at 01:16 PM

I added a case to the dev list. We'll look into it. Thanks.

0 ·

Answer 2 · 2017-09-29T14:06:24Z

Sebastian Hemmann answered Sep 29, '17 Phil BoBo converted comment to answer Sep 29, '17

Hi,

the first Point doesn´t work for me, either. Even

gettablenum("Parameters",1,1);

doesn´t work. Maybe a bug!? Certainly if only boxes older than a specific time should be taken you will have to use "WHERE age > 180" and if you want to define the Transport by using a list you also have to erase the Connection between Queue 1 and Processor 1!

Your second Point should be:

current.stats.output.value +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.

question