How to selectively Pull from from using Label Array?

Question

question

Jay K9 asked May 1, '24 Jay K9 commented May 3, '24

How to selectively Pull from from using Label Array?

I have 2 lists. One which keeps track of parts it has created. It has a label column called PartName.

Second list is parts requested by operator which also has a label column PartName.

When the a value it pushed in second list as a request by operator it triggers the flow.

The flow starts with a pull request from first list which pulls one value and Assign to token.requestpull

The flow moves to a batching step where I batch 3 token with a max wait time of 60 sec. I also track how many were batched before getting released

In batching process flow for label aggregation I have

From Label - requestpull.Partname

To Label - requestpull

Aggregation - Make Array

Then I want to pull from first list. The request quantity of pull from first list is the number of token I have batched which is store in label batchCount (this works right) I have puller token for second list as pullerrequest

For query I only want to select parts which are requested by operators so

WHERE PartName IN pullerrequest.requestpull

This however does not work and shows sql query mistake. Where am I making a mistake?

Software Version:

FlexSim 23.0.15

lists list pull sql queries

· 4

Joerg Vogel commented · May 01 at 10:37 PM

Try IN clause argument with brackets.

pullerrequest.requestpull datatype must be an array. Elements of this array must match with PartName. Print arguments into an output console for testing.

look for examples in https://www.w3schools.com/sql/sql_in.asp

1 ·

Jay K9 Joerg Vogel commented · May 02 at 12:27 AM

Got a work around but it works now. Thanks!

0 ·

Jeanette F ♦♦ Jay K9 commented · May 03 at 05:04 PM

Can you share your solution and accept it?

0 ·

Show more comments

Answer 1 · 2024-05-03T18:11:03Z

Jay K9 answered May 3, '24

You can create assign a label called NameArray and in values select Array and Set Array. In that portion added the following as code.

Array values = Array(arraySize);

for(int i=1; i<=arraySize;i++){
values[i] = token.requestpull[i].PartName;
}


return values;

question