Hi, I am executing the search query which returns the result and now i need to sort them on the basis of condition.......
i need to order by the result if element abc exists in the documents of result set, if it dose not exists in the document of result set then order by xyz element if it is available in the document. What it means is i have to sort the result set on the basis of first element and if it dose not exists then i have to do the sorting on another element. below scenarios can be available in the data/result set of search..... 1. Document may have only first element 2. Document may have only second element 3. document may have both the elements 4. document may have none of the element So sorting should be done on the preference of first element if it is available and if not available then sorting should be done on another element. It means my final output should have sorted result set mixed on the basis of first and second element on the basis of their respective availability. Can some body please help me out here (how to achieve the expected behavior) if you have done it earlier or faced the same situation. Also what would be the behavior of document which do not have any of the element for ascending and descending condition. means will they come in first or last always? you can assume that my search is working perfectly fine and i just need to add the order by clause. Thanks Anu
_______________________________________________ General mailing list [email protected] http://xqzone.com/mailman/listinfo/general
