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
