question

David Chan avatar image
0 Likes"
David Chan asked Joerg Vogel commented

Place item randomly between levels that matches label

Hi I would like to place an item randomly on a rack between the levels with label value matches. That is if Type 2 is from level 2 to 5, I would like to place item randomly between these levels.

Is there a way, to read the label properties of a level so that I can match it with item Type?

Thanks


David

FlexSim 21.2.3
rack level label
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 Joerg Vogel commented

main query clause

"WHERE slot.mylabel = $1 AND slot.levelID IN (2,3,4,5) ORDER BY RAND()"

find_slot_by_label_level.fsm

mylabel is a storage system label set in toolbox.

bays are painted with mylabel value = 2

painted-bay-slots-resticted-levels.jpg


painted-bay-slots-resticted-levels.jpg (20.3 KiB)
find-slot-by-label-level.fsm (39.9 KiB)
· 2
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.

David Chan avatar image David Chan commented ·
@Joerg Vogel Thanks for the solution. If I do not know which level where the slot.mylabel has the value 2. Is there a way to query?

David

0 Likes 0 ·
Joerg Vogel avatar image Joerg Vogel David Chan commented ·

Hi @David Chan, my example model finds one slot. You want to get all slots matching with a query. This is a task for a different method. You can try querySlots. The result array contains all slots. Now you can identify the level of each slot in the array. I think you should ask this as a new question, because you ask for a query of a different attribute. Your initial question deals with data for an item, your added request deals with data of a warehouse. Please accept my answer, if I have answered your question. Thanks.

0 Likes 0 ·