Hi Indy, We ran into the same problems after we upgraded to ML8.
That forced us to create the necessary indexes and also make sure that we don't specify a "collation" attribute if the sortby index is not of type string. Also, if the index is of type int, you should use "xs:int", not "xs:integer" for sort-order/@type. Regards, Danny On Thu, Apr 30, 2015 at 2:16 AM, Indrajeet Verma <[email protected]> wrote: > Hi Joe Bryan, > > Thank you for your suggestions! > > The same code was working in ML6 without any error however this is showing > exception in ML8 as SEARCH-BADORDERBY. > > So is it mandatory in ML8 but not in ML6? However going through the > documentations, it suggests the range index must be there even in ML6. > > Regards, > Indrajeet > > On Thu, Apr 30, 2015 at 11:01 AM, Joe Bryan <[email protected]> > wrote: > >> Hi Indrajeet, >> >> The documentation you linked is for optimizing "order by" clauses in >> XQuery. The <sort-order/> element is part of the Search API query options, >> which are documented here: >> http://docs.marklogic.com/search:search?q=search:search&v=8.0&api=true#opt-sort-order >> >> Thanks. >> >> -jb >> >> From: Indrajeet Verma <[email protected]> >> Reply-To: MarkLogic Developer Discussion <[email protected] >> > >> Date: Thursday, April 30, 2015 at 1:24 AM >> To: MarkLogic Developer Discussion <[email protected]> >> Subject: [MarkLogic Dev General] SEARCH-BADORDERBY >> >> Hi, >> >> I was having issues in ML8 as SEARCH-BADORDERBY: (err:FOER0000) Indexes >> are required to support element, element-attribute, json-property, or field >> sort specifications. >> >> So I created range index for the element "name" as It was being used in >> <sort-order> >> >> I just wanted to confirm whether range index are mandatory in ML8 for >> the elements that we use in <sort-order> as a search option. >> >> I have gone through the link as well for the documentation and I did >> not see that the error will be thrown in case indexes will not present. >> Please let me know if I am missing anything. >> >> https://docs.marklogic.com/guide/performance/order_by#id_29515 >> >> Thank you for your help. >> >> Regards, >> Indy >> >> _______________________________________________ >> General mailing list >> [email protected] >> Manage your subscription at: >> http://developer.marklogic.com/mailman/listinfo/general >> >> > > _______________________________________________ > General mailing list > [email protected] > Manage your subscription at: > http://developer.marklogic.com/mailman/listinfo/general > >
_______________________________________________ General mailing list [email protected] Manage your subscription at: http://developer.marklogic.com/mailman/listinfo/general
