Accessing indexed item label with querySlots()

Question

question

Mikael B asked Apr 27 2021 at 12:31 PM Ben Wilson commented May 03 2021 at 7:58 PM

Accessing indexed item label with querySlots()

I wonder if its possible to use indexed item labels with the querySlots command. I use this line of code to check if each zone already contains a SKU, to more evenly distribute SKUs across the zones.

Array skusInZone;
for (int i=1; i<=18; i++) {
            int Zone = i;
            Array slots = Storage.system.querySlots("WHERE zone = $2 AND slot.slotItems.length >= 1 AND slot.slotItems[1].item.SKU = $1 LIMIT 5", 0, SKU, Zone);
            skusInZone.push(slots.length);
        }

There are a total of 18 zones, and each zone consists of about 4000 slots, so I would like to make the query faster. zone is an indexed slot label. I would prefer to avoid painting slots with a SKU label. I have already indexed the item label SKU in the storage system. Is it possible to use the indexed item label in a querySlots() command?

Software Version:

FlexSim 20.0.10

query storage system flexsim 20.0.10 indexing queryslots

· 1

______

Cookie preferences

Your privacy is important to us and so is an optimal experience. To help us customize information and build applications, we collect data about your use of this site.

May we collect and use your data?

Learn more about the Third Party Services we use and our Privacy Statement.

Strictly necessary – required for our site to work and to provide services to you

These cookies allow us to record your preferences or login information, respond to your requests or fulfill items in your shopping cart.

YES

Improve your experience – allows us to show you what is relevant to you

These cookies enable us to provide enhanced functionality and personalization. They may be set by us or by third party providers whose services we use to deliver information and experiences tailored to you. If you do not allow these cookies, some or all of these services may not be available for you.

YES

NO

Customize your advertising – permits us to offer targeted advertising to you

These cookies collect data about you based on your activities and interests in order to show you relevant ads and to track effectiveness. By collecting this data, the ads you see will be more tailored to your interests. If you do not allow these cookies, you will experience less targeted advertising.

YES

NO

Are you sure you want a less customized experience?

We can access your data only if you select "yes" for the categories on the previous screen. This lets us tailor our marketing so that it's more relevant for you. You can change your settings at any time by visiting our privacy statement

Your experience. Your choice.

We care about your privacy. The data we collect helps us understand how you use our products, what information you might be interested in, and what we can improve to make your engagement with Autodesk more rewarding.

May we collect and use your data to tailor your experience?

Explore the benefits of a customized experience by managing your privacy settings for this site or visit our Privacy Statement to learn more about your options.

Answer 1 · 2021-04-28T05:29:51Z

Lars Jacobsen answered Apr 28 2021 at 5:29 AM Mikael B commented Apr 28 2021 at 1:39 PM

If possible, please provide a sample model. For the storage system query to use an index, you need to specify a label directly, otherwise it is evaluated as FlexScript and will not use an index. Thus instead of writing "slot.slotItems[1].item.SKU", try just writing the label "SKU" in your query.

· 2

Jason Lightfoot ♦♦ commented · Apr 28 2021 at 1:19 PM

The index relates to the type of query - so using findItem() could use the item indices while findSlot() would reference those of slots. Other wise you couldn't have the same label - say 'SKU' on both the slot and the items - you'd have to call them slotSKU and itemSKU in order for the query to know which you're checking.

0 ·

Mikael B Jason Lightfoot ♦♦ commented · Apr 28 2021 at 1:39 PM

I had the same feeling but I tested it out just to be sure, and the index does relate to the type of query. Here is an image from the test:

The slots doesnt have a SKU label, so the query couldnt find anything.

I think a workaround without labeling the slots could be to give slot.items the indexed label zone and use queryItems() instead. With some coding I should be able to stop the query from pulling multiple slotitems from the same slot, which I think should give the same result as querySlots(). If I try this, and it turns out successful, I will give an update in this comment chain.

0 ·

1619616630662.png (33.1 KiB)

question