question

Shinya O avatar image
0 Likes"
Shinya O asked Shinya O edited

Find an item with zero subnode length in the storage system

Hi,

I am trying to find an item with zero subnode length in the storage system, but my sample model does not work.

Is my query wrong?

Thanks in advance.

ISNULLsample.fsm

FlexSim 23.0.8
queryfinditem
isnullsample.fsm (41.2 KiB)
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

Felix Möhlmann avatar image
1 Like"
Felix Möhlmann answered Shinya O edited

- The keyword item in the storage query refers to the Slot.Item class representation of the stored item. To check the number of subnodes you have to first get the actual object with item.item.

- ISNULL seems to return 0 if there are no subnodes regardless of the second parameter. You could also just check for the number of subnodes.

WHERE ISNULL(item.item.first, 0) == 0

WHERE item.item.subnodes.length < 1
· 1
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.

Shinya O avatar image Shinya O commented ·

Thank you very much.

0 Likes 0 ·