Hellow,
I wanted to query over multiple partition in a list but that unfortunately not possible. Good idea for improvement imho.
Due to various reasons it still better for me to look in multiple partitions than it is to rewrite my model.
In the model I’ve build parcels arrive and are allocated to storage 1,2,3,4. They have a tonnage and a grade (1 or 2). I need to pull the earliest entry (FIFO) of a grade (for example grade 1). But I need to determine what partition has the earliest entry per grade in order to access the right partition.
All I can think of is make a query per partition in a custom code. Put those values in an array and then loop through it to find the lowest value.
Is there a better/easier way to do this?
