Find Slot/Item Query

Question

question

Maryam H2 asked Jul 24 2023 at 6:41 PM Maryam H2 commented Jul 27 2023 at 2:18 PM

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.

Software Version:

FlexSim 23.1.0

query findslot finditem rac

Answer 1 · 2023-07-24T20:40:22Z

Jason Lightfoot answered Jul 24 2023 at 8:40 PM Maryam H2 commented Jul 27 2023 at 2:18 PM

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

Maryam H2 commented · Jul 25 2023 at 1:05 PM

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 ·

Jason Lightfoot ♦♦ Maryam H2 commented · Jul 25 2023 at 1:32 PM

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 ·

Maryam H2 Jason Lightfoot ♦♦ commented · Jul 25 2023 at 7:20 PM

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 ·

Show more comments

question