lenght of level 1 in rack in group

Question

question

Andreas BH asked Feb 12, '24 Jason Lightfoot commented Feb 13, '24

lenght of level 1 in rack in group

Hello together,

i want to know how many items are stored in all racks in level 1 in a group of racks. I tried several different formulations but failed.

for (int i = 1; i <= groupnummembers("Bereich_2"); i++)
{
k = Storage.system.queryItems("WHERE slot.storageObject.name==$1 AND slot.levelID == 1",0,groupmember("Bereich_2",i).name).length;
j=j+k;
}

it seems to me that it doesn't matter if you use == or =

Is somebody able to help?

Thank You!

Software Version:

FlexSim 22.1.4

racks groups sql query length

· 6

Felix Möhlmann commented · Feb 12 at 02:32 PM

I don't see any issues in the code and it works correctly for me in a test model.

level-content-query-test.fsm

What issue are you facing? Are you getting an error message or a wrong result? Have you checked that the racks are assigned to the correct group and that their adressing scheme is set up correctly?

0 ·

level-content-query-test.fsm (41.8 KiB)

Andreas BH Felix Möhlmann commented · Feb 13 at 07:23 AM

Good Morning. Your code works well in Skript-box. But i get the same error in Decide-activity (custom Code) as my code.

0 ·

2024-02-13-08-07-37-window.jpg (34.6 KiB)

Felix Möhlmann Andreas BH commented · Feb 13 at 09:12 AM

I get the same error, but only if I step through the code in debug mode. When running normally, the code actually works in Process Flow too. Seems to be an issue with the debugger.

0 ·

Show more comments

Jason Lightfoot ♦ commented · Feb 12 at 02:34 PM

In queries the = and == are interchangable tests for equality.

0 ·

Answer 1 · 2024-02-12T15:27:56Z

Jason Lightfoot answered Feb 12, '24 Andreas BH commented Feb 13, '24

You can do this in one line:

int numLevel1=Storage.system.queryItems("SELECT count(*) WHERE slot.storageObject IN $1 AND slot.levelID=1", 0,Group("Bereich_2").toFlatArray())[1][1]

· 1

Andreas BH commented · Feb 13 at 07:25 AM

Thank you! This works without problems.

0 ·

question