How to pull using array label?

Question

question

Enrique Elizaga asked Jan 16 2018 at 8:58 AM Enrique Elizaga commented Jan 18 2018 at 12:51 AM

How to pull using array label?

Hi, I tried to pull tokens that comply with either of 2 label criteria.

One SKU_SOURCE is a regular label match operation and the other one SKU_MULTISOURCE an array that is relevant if its index value is greater than 0. Both labels are delcared in the list.

I tried:

WHERE SKU_SOURCE == Puller.SOURCE, OR SKU_MULTISOURCE[index] > 0

It didn't work. Any ideas?

Software Version:

FlexSim 18.0.0

pull from list array label

Answer 1 · 2018-01-16T10:12:47Z

Mischa Spelt answered Jan 16 2018 at 10:12 AM Enrique Elizaga commented Jan 18 2018 at 12:51 AM

Hi Enrique. First of all, what you posted has a syntax error: there should not be a comma before OR:

WHERE SKU_SOURCE == Puller.SOURCE OR SKU_MULTISOURCE[index] > 0

Maybe that already solves your problem. If not, the parser probably does not understand the array index notation. Is index a label on the pulled tokens as well? In that case, you could create a label for SKU_MULTISOURCE[index] and just use that in your query. Or, the workaround that sort of pollutes your toolbox but always works: create a user command MatchesSource taking two tokens, that returns true or false:

Token puller = param(1);
Token pulled = param(2);
return pulled.SKU_SOURCE == puller.SOURCE || pulled.SKU_MULTISOURCE[pulled.index] > 0;

and then in your query you can simply write:

WHERE MatchesSource(puller, value)

· 1

question