Count entries on list by label value(s)

Question

question

Linda N asked Apr 30, '19 Joerg Vogel commented Apr 30, '19

Count entries on list by label value(s)

Hi all,

At the end of a work day, I want to count how many orders missed the deadline (CutOffTime). The orders are on a list named "List: Finished Orders" and I have a global variable currentDay which tracks the current day number.

I track two labels on the list CutOffDay and lateOrder. I wish to determine the number of orders on the list where CutOffDay = currentDay and lateOrder = 1. I figured I should do this with a query but I only have limited experience querying a list in the process flow objects, but for this one I want to determine it in an integer variable and write it to a table so I can assess the statistics later on. I haven't managed to figure it out myself yet, could someone help?

lateorderstellen.png

Thanks in advance!

Linda

Software Version:

FlexSim 19.0.0

labels list query label lable

lateorderstellen.png (68.9 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.

Joerg Vogel commented · Apr 30, 2019 at 02:45 PM

Try it with a table query over the global list. You use a COUNT clause of the values WHERE your conditions are fulfilled.

0 ·

Answer 1 · 2019-04-30T14:52:05Z

Linda N answered Apr 30, '19 Joerg Vogel commented Apr 30, '19

My list is not global, is that a problem?
I'll have to look into this, i've never written a query in flexscript before (at least not the Table.query() variant). Would be great if you could help me out with an example on this case!

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

Joerg Vogel commented · Apr 30, 2019 at 03:07 PM

It is a problem if the list isn’t a global list, then you can’t use table.query over the list. Please refer to the manual SQL Queries Table Selection.

0 ·

Joerg Vogel commented · Apr 30, 2019 at 03:09 PM

You find a SUM clause example sum label in global list.

0 ·

question