Find item based on a label on storageObject of the item

[rhramac]

[ FlexSim 22.2.4 ]

How do I find an item based on a label "Type" on the storageObject (Racks, Floor storage) in the model.

I tried using find item activity in the process flow with the query as follows:

I get an exception that looks like the query tried to access Type on an object that is not a storageObject. Is there anything wrong with the query or my approach?

Other approach I have is to label items and use item label to identify them.

[kavika_faleumu]

Hi @Rahul R,

It's hard to know how to help without looking at your model. To receive a more accurate solution, please post your model or a sample model that demonstrates your question.

Proprietary models can be posted as a private question visible only to FlexSim U.S. support staff. You can also contact your local FlexSim distributor for phone or email help.

---

If you can't post your model, then some more details about your list would be helpful.

Upon first look at your Query, I'm a little skeptical of using item.slot.storageObject.Type in your Query. What does item refer to? Is that a column name, a label, etc.?

Generally, you'd put a ColumnName for the query to look for the token.Type.

WHERE ColumnName = $1.Type

[rhramac]

@Kavika F : Thank you, I will post as a private question as I am unable to reproduce the issue on a smaller problem. I was trying to refer to the items in the storage system (similar to value in the list). As you said, that reference could be incorrect.

[joerg_vogel_HsH]

I assume, you have stored pallets in a rack. Each pallet stores several items, Those have labels and one of them is Type. Unfortunately the warehouse knows only the pallets while searching an item, because item is only a keyword, which references the first subnode level of a slot to identify slotitems. Please don't make a mistake to mismatch keywords with actual references to items in subnodes of a tree like structure.

[Jeanette_Fullmer]

Hello @Rahul R ,You can edit this question to be a private question and attach your model to it.

[rhramac · Accepted solution]

Thank you!

I will close this question, I was able to get to desired behavior using list (instead of querying storage system).

[joerg_vogel_HsH]

@Rahul R, Too late, here is an approach directly in Finditem activity: findItem2022_1.fsm.

findItem quere here is:

WHERE item.item.up.Type = $1.Type

findItem query works, too:

WHERE item.storageItem.currentSlot.storageObject.Type = $1.Type

[rhramac]

Thank you Joerg! Appreciate you looking at it again!

[jason_lightfootVL7B4]

I think the item.item syntax will unvirtualize all items - so if you're using that feature, this would not be a good option.