Hi, Problem:
I have a solar query to search some documents as below. name=*&enableStore=(true OR null)&lcState=(PUBLISHED OR PROTOTYPED) the result of this query returns documents below. > > name : API1 > context: /ctx/1.0 > > name : API1 > context: /ctx/2.0 > > name: API1 > context: /ctx/3.0 but I want this to return only the document with max context name: API1 context: /ctx/3.0 Any suggestions how can I improve the above query to achieve this? Thanks & Regards, Ishara Cooray Mobile : +9477 262 9512 WSO2, Inc. | http://wso2.com/ Lean . Enterprise . Middleware http://cloud.wso2.com/