question

Maryam H2 avatar image
0 Likes"
Maryam H2 asked Maryam H2 commented

Find Slot/Item Query

What is the query in the 'Find Slot/Item' object that specifically looks for items in a particular rack? How can I create a query that filters for one or multiple racks?

  • I have not set up an Adress Scheme and I'm just using the paint slot tool to match labels of items with the racks.
FlexSim 23.1.0
queryfindslotfinditemrac
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

·
Jason Lightfoot avatar image
0 Likes"
Jason Lightfoot answered Maryam H2 commented

You need to add the clause:

WHERE slot.as(Storage.Slot).storageObject=

followed by your rack reference. At some point I hope the shorter version

WHERE slot.storageObject=

will work - I've not tested it in the latest versions.

· 15
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.

Maryam H2 avatar image Maryam H2 commented ·
Hi @Jason Lightfoot

I have two racks that both have the same type of items but the operator picks the items from the first rack while I want the operator to pick items from teh second one.

When I put the script you mentioned above it doesn't work.


0 Likes 0 ·
Jason Lightfoot avatar image Jason Lightfoot ♦ Maryam H2 commented ·
So if the rack is referred to a token.rack and you're passing in the token as $1, then your expression would be: 
WHERE slot.as(Storage.Slot).storageObject=$1.rack

Is that what you had, or something similar? If not please post the expression you're using along with the token labels and their values.

0 Likes 0 ·
Maryam H2 avatar image Maryam H2 Jason Lightfoot ♦ commented ·
Actually what if the rack is an object in teh storage system and no reference to it used with token.rack. Is it possible to write a query in Find Item and reference a specific pallet rack object something like below but I don't know what would be the secon part? 
WHERE SKU == $1.SKU AND --
0 Likes 0 ·
Show more comments

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.