question

Lars Jacobsen avatar image
0 Likes"
Lars Jacobsen asked Jeanette F commented

How to add a Site ID to Storage System Address Scheme?

Is it possible to expand the storage system address scheme with an additional field, i.e. Site ID? The issue is that I would like to query storage possibilities by site and not only globally.


1660122955237.png

FlexSim 22.1.3
storage systemaddress scheme
1660122955237.png (28.1 KiB)
· 3
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Joerg Vogel avatar image Joerg Vogel commented ·

@Lars Christian J2 , There exists an Aisle side management in manual for left and right side by mapping of Aisle ID and slot progression. Front and Back side are seperated by even and uneven numbering.

https://docs.flexsim.com/en/22.2/Reference/PropertiesPanels/WarehousingPanels/AddressMapping/AddressMapping.html#slotProgression

0 Likes 0 ·
Jason Lightfoot avatar image Jason Lightfoot ♦♦ Joerg Vogel commented ·
I think the question was about a Site ID indicating the warehouse location rather than a Side ID.
0 Likes 0 ·
Jeanette F avatar image Jeanette F ♦♦ commented ·

Hi @Lars Christian J2, was one of Lars Christian J2's or Jason Lightfoot's or Felix Möhlmann's answers helpful? If so, please click the "Accept" button at the bottom of the one that best answers your question. Or if you still have questions, add a comment and we'll continue the conversation.

If we haven't heard back from you within 3 business days we'll auto-accept an answer, but you can always unaccept and comment back to reopen your question.

0 Likes 0 ·
Jason Lightfoot avatar image
0 Likes"
Jason Lightfoot answered Joerg Vogel commented

The simplest way will be to duplicate the address scheme for each site and include the site ID at the start.

1660125019189.png

1660125222071.png


Then on the storage objects choose the correct scheme for the site:

1660125085224.png

1660125102805.png



1660125019189.png (15.0 KiB)
1660125085224.png (5.7 KiB)
1660125102805.png (5.7 KiB)
1660125222071.png (9.4 KiB)
· 6
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Lars Jacobsen avatar image Lars Jacobsen commented ·

So I should by able to query these two fields? They do not contain any value.

0 Likes 0 ·
Jason Lightfoot avatar image Jason Lightfoot ♦♦ Lars Jacobsen commented ·

You said you wanted to use change the address - here the slot.address=="LON-A-1-A-1-1" or "CPH-A-1-A-1-1". Without this, finding "A-1-A-1-1" would give slots in both racks.

0 Likes 0 ·
Lars Jacobsen avatar image Lars Jacobsen Jason Lightfoot ♦♦ commented ·

I query the storage system like this

1660128770315.png

I am not sure how to access the 2 new fields in the address?



0 Likes 0 ·
1660128770315.png (5.3 KiB)
Show more comments
Lars Jacobsen avatar image
0 Likes"
Lars Jacobsen answered Jason Lightfoot edited

Thanks for all the input. I realized that I can use slot.storageObject to limit the result of the sql query.


Object Site = Model.find("SiteA");

Array WrhObj = Site.subnodes.toArray();

int Zone = 10;

return Storage.system.querySlots("WHERE slot.zoneID = $1 AND slot.storageObject IN $2", 0, Zone, WrhObj).as(Array).length;


1660199196567.png


1660199196567.png (117.9 KiB)
· 1
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Jason Lightfoot avatar image Jason Lightfoot ♦♦ commented ·

Yes - there's probably 20+ ways you can get around it without using the address. You could also also check if slot.storageObject.up = site. Might be more efficient than checking if it's in an array depending on the length.

0 Likes 0 ·
Felix Möhlmann avatar image
0 Likes"
Felix Möhlmann answered

I don't believe that this is possible.

You could use an (indexed) slot label for that purpose though. Or is there any reason you would like to avoid using labels?

1660124001354.png


1660124001354.png (215.6 KiB)
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.