question

Stan Davis avatar image
0 Likes"
Stan Davis asked Joerg Vogel answered

How to Model Mixed Products in Same Rack Slot

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

FlexSim 22.0.1
rackssql
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

1 Answer

·
Joerg Vogel avatar image
0 Likes"
Joerg Vogel answered

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

SQL: try evaluating an array with IN.

· 1
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Stan Davis avatar image Stan Davis commented ·
Thanks
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.