go to post Robert Cemper · Feb 24, 2022 my wild guess InterProcessQueueWaitmight be related to parallel processing or sharding ???
go to post Robert Cemper · Feb 24, 2022 $ORDER() always operates at the distinct subscript level you start it Auto1,Auto2, Color,Color2to check for a deeper level you may use $DATA()or you run your search using $QUERY() which returns only instances with data
go to post Robert Cemper · Feb 24, 2022 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 querywhere you pass the i%* as a query parameter out of your actual running context.