Thank you Danny for your detailed explanation! Regards, Indy
On Thu, Apr 30, 2015 at 6:25 PM, Danny Sinang <d.sin...@gmail.com> wrote: > 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 < > indrajeet.ve...@gmail.com> 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 <joe.br...@marklogic.com> >> 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 <indrajeet.ve...@gmail.com> >>> Reply-To: MarkLogic Developer Discussion < >>> general@developer.marklogic.com> >>> Date: Thursday, April 30, 2015 at 1:24 AM >>> To: MarkLogic Developer Discussion <general@developer.marklogic.com> >>> 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 >>> General@developer.marklogic.com >>> Manage your subscription at: >>> http://developer.marklogic.com/mailman/listinfo/general >>> >>> >> >> _______________________________________________ >> General mailing list >> General@developer.marklogic.com >> Manage your subscription at: >> http://developer.marklogic.com/mailman/listinfo/general >> >> > > _______________________________________________ > General mailing list > General@developer.marklogic.com > Manage your subscription at: > http://developer.marklogic.com/mailman/listinfo/general > >
_______________________________________________ General mailing list General@developer.marklogic.com Manage your subscription at: http://developer.marklogic.com/mailman/listinfo/general