Hi, You can do it using ScanQuery[1] with specific filter, and reorder result by your logic.
You can not find in nested collection on SQL query. For do this you should store Person and Phone separately link them using foreign keys. You can then join these two table in your SQL query[2]. [1]: https://apacheignite.readme.io/docs/cache-queries#scan-queries [2]: https://github.com/apache/ignite/blob/master/examples/src/main/java/org/apache/ignite/examples/datagrid/CacheQueryExample.java -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Query-on-collections-in-a-cache-object-tp11529p11543.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.
