Hi Michael, Thanks alot for the reply. I tried using collation as "http://marklogic.com/collation/codepoint"; but it was not sorting the elements as per our requirement.
I solved the problem by creating the custom collation for the title element on the range index itself. Thanks, Abhinav Kumar Mishra -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Michael Blakeley Sent: Monday, February 10, 2014 10:32 PM To: MarkLogic Developer Discussion Subject: Re: [MarkLogic Dev General] Sorting based on title element of an xml is not working In the options, specify the range index collation too. Do this whenever you refer to the range index. For example: http://docs.marklogic.com/guide/rest-dev/appendixb#id_33716 <sort-order type="xs:string" collation="http://marklogic.com/collation/codepoint"; direction="ascending"> <element ns="http://purl.org/dc/elements/1.1/"; name="title"/> </sort-order> Without the collation, the evaluator will look for a range index in the default collation. That's usually the root collation, and it's the default collation for the current evaluation scope, *not* the database default collation. So it's a good idea to specify the collation to your configuration wherever you refer to the range index. -- Mike On 9 Feb 2014, at 21:51 , <[email protected]> <[email protected]> wrote: > Hi All, > > I am trying to sort the productset xml on title in ascending order. It is > working fine for the documents which I newly create. But it is giving the > wrong result for the existing documents. > > My requirement is to sort the title element which will display the > title in the ascending order as given below:- > > _productSet > @grade1 > 1grade > Bgrade > Grade1 > bgrade > grade2 > > i.e. title would be in the order which starts with special character, then > numbers, then upper case characters and at the last lower case characters. > > The structure of product set xml is like and will be present in collection > like http://pcenamespace/productsets : > > <pce:productSet> > <dc:identifier>1680174081022788315</dc:identifier> > <pce:program-id>7937430281626559657</pce:program-id> > <dc:title>_ productSet</dc:title> > ........................................... > <pce:productSet> > > > I have following search options and constraints, and I have created range > index for program-id in the database, and database have default collation as > http://marklogic.com/collation/codepoint :: > > > <options xmlns="http://marklogic.com/appservices/search";> > <constraint name="ProgramID"> > <range type="xs:unsignedLong" facet="false"> > <element ns="http://pcenamespace"; name="program-id" /> > </range> > </constraint> > <constraint name="Show"> > <collection prefix="http://pcenamespace/"; facet="false" /> > </constraint> > <operator name="sort"> > <state name="relevance"> > <sort-order> > <score /> > </sort-order> > </state> > <state name="titleAscending"> > <sort-order direction="ascending" type="xs:string"> > <element ns="http://purl.org/dc/elements/1.1/"; > name="title" /> > </sort-order> > </state> > <state name="titleDescending"> > <sort-order direction="descending" type="xs:string"> > <element ns="http://purl.org/dc/elements/1.1/"; > name="title" /> > </sort-order> > </state> > </operator> > </options> > > I am using the following query to fetch the results: > > query=ProgramID:7937430281626559657 Show:productsets > sort:titleAscending > > > > Thanks, > Abhinav Kumar Mishra > > This e-mail and any files transmitted with it are for the sole use of > the intended recipient(s) and may contain confidential and privileged > information. If you are not the intended recipient(s), please reply to > the sender and destroy all copies of the original message. Any > unauthorized review, use, disclosure, dissemination, forwarding, > printing or copying of this email, and/or any action taken in reliance > on the contents of this e-mail is strictly prohibited and may be > unlawful. _______________________________________________ > General mailing list > [email protected] > http://developer.marklogic.com/mailman/listinfo/general _______________________________________________ General mailing list [email protected] http://developer.marklogic.com/mailman/listinfo/general This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information. If you are not the intended recipient(s), please reply to the sender and destroy all copies of the original message. Any unauthorized review, use, disclosure, dissemination, forwarding, printing or copying of this email, and/or any action taken in reliance on the contents of this e-mail is strictly prohibited and may be unlawful. _______________________________________________ General mailing list [email protected] http://developer.marklogic.com/mailman/listinfo/general
