All
Accepted answers
Robert Cemper · Feb 24, 2022 go to post

my wild guess InterProcessQueueWait
might be related to parallel processing or sharding  ???

Robert Cemper · Feb 24, 2022 go to post

$ORDER() always operates at the distinct subscript level you start it  Auto1,Auto2, Color,Color2
to check for a deeper level you may use $DATA()
or you run your search using $QUERY()  which returns only instances with data
 

Robert Cemper · Feb 24, 2022 go to post

No it is not possible.
this would require having the complete instantiated object inside your query.
If you require such functionality you should use a dynamic query
where you pass the i%* as a query parameter out of your actual running context.