How to Model Mixed Products in Same Rack Slot

How to Model Mixed Products in Same Rack Slot

stan.e.davis
Advocate Advocate
3 Views
2 Replies
Message 1 of 3

How to Model Mixed Products in Same Rack Slot

stan.e.davis
Advocate
Advocate

[ FlexSim 22.0.1 ]

We have some slot locations that allow mixed products.

Without having to employ an address scheme and hardcoding a location on an incoming product OR splitting a bay into more slots, is it possible to model a rack storage system that allows defined combinations of items to be stored in the same slot?

For example...
Bay 1 Slot 1 - product A and/or product B
Bay 1 Slot 2 - product A and/or product C

Painting appears to only allow 1 label, but if you could apply multiple labels to a slot, you could employ something similar to:
"WHERE ((ProductA = $1.Product) OR (ProductB = $1.Product)) AND slot.hasSpace($1) ORDER BY RAND()"

A SQL "LIKE" would be useful too.

Thanks - Stan

0 Likes
Accepted solutions (1)
4 Views
2 Replies
Replies (2)
Message 2 of 3

joerg_vogel_HsH
Mentor
Mentor
Accepted solution

There are multiple labels allowed. Each must have a different name!

SQL: try evaluating an array with IN.

0 Likes
Message 3 of 3

stan.e.davis
Advocate
Advocate
Thanks
0 Likes