topic Re: Query array label issue on Acquire Resource in FlexSim Forum

Query array label issue on Acquire Resource

leandroom — Fri, 17 Jan 2025 18:28:05 GMT

[ FlexSim 24.2.3 ]

Hello,

I got 3 Machines, each Machine has a label (.numMachine) containing an integer 1, 2 or 3. Ex: Machine1.numMachine = 1.

I got a box (flowitem), storing an array label (.numMachines) containing the number of the Machine that it was processed. Ex: Box1.numMachines = Array[2]: {1,2}.

So now i want to Acquire a new Machine for the box to be processed, but can't be the same that already was processed by, so if my box was processed by Machine1 and Machine2, i want to acquire Machine3.

How can i write a correct query logic?

Re: Query array label issue on Acquire Resource

joerg_vogel_HsH — Sun, 19 Jan 2025 09:39:26 GMT

Have you tried to use:

NOT IN

followed by an inserted array clause?

Re: Query array label issue on Acquire Resource

moehlmann_fe — Mon, 20 Jan 2025 07:06:04 GMT

"Pulled" and "token" are not valid keywords in the query. The thing that is queried can be accessed through "value" (though any text that has no other meaning will automatically be interpreted as a label on the value). Other parameters can be passed into the query through the use of "puller". In an Acquire activity the puller is always the token (in Pull from List the user can specify the puller).

So the query should be

WHERE numMachine NOT IN puller.item.numMachines

Re: Query array label issue on Acquire Resource

Jeanette_Fullmer — Thu, 23 Jan 2025 16:32:02 GMT

Hi @Leandro Meirelles, was Joerg Vogel's answer helpful? If so, please click the "Accept" button at the bottom of their answer. Or if you still have questions, add a comment and we'll continue the conversation.

If we haven't heard back from you within 3 business days we'll auto-accept an answer, but you can always comment back to reopen your question.