Hi, Julia: Expect a fix to Bug 33139 in MarkLogic 8.0-3.
Erik Hennum ________________________________________ From: [email protected] [[email protected]] on behalf of Julia Egoshina [[email protected]] Sent: Tuesday, April 14, 2015 10:35 PM To: MarkLogic Developer Discussion Cc: Maxim Trushin Subject: Re: [MarkLogic Dev General] cannot fetch ordered documents from specified collection using nodeJS Hi Erik, When this bug will be fixed and could you please provide me the code for tracking this bug? Thanks, Julia > On 15 Apr 2015, at 06:22, Erik Hennum <[email protected]> wrote: > > Hi, Julia: > > I'm able to reproduce the issue. It appears that the collection is not being > set for any QBE (independent of the ordering) and that it's a bug in the REST > API. > > Until the bug is fixed, you should either use QBE with enough criteria that > the collection is unnecessary or to use the Query Builder with the collection > instead of QBE. > > > Thanks for identifying the issue, > > > Erik Hennum > > ________________________________________ > From: [email protected] > [[email protected]] on behalf of Julia Egoshina > [[email protected]] > Sent: Tuesday, April 14, 2015 3:33 AM > To: [email protected] > Cc: Maxim Trushin > Subject: [MarkLogic Dev General] cannot fetch ordered documents from > specified collection using nodeJS > > Hi, > > I’ve got a problem with querying data using QBE from nodeJS. > > The following code works fine. It returns data that fits my example from the > specified collection. > > var query = client.qb.where( > client.qb.byExample( > { > "isin": params.isin > } > ) > ); > > client.queryCollection( > config.MARKLOGIC_STATIC_COL_NAME, > query > ).result( > function (docs) { > if (docs.length >= 1) { > queryResults[queryResults.length] = docs[0]; > FetchLastPrice(docs[0].sedol, 1); > } else { > LogWrite('Unable to find static document for isin "' + > params.isin + '"'); > next(errResult); > } > }, > function (err) { > LogWrite(JSON.stringify(err, null, 4)); > next(errResult); > } > ); > > Once I add an orderBy statement (highlighted) the REST service starts > returning documents that fit my example not only from the specified > collection but from all collections in my database. > > var query = client.qb.where( > client.qb.byExample( > { > "isin": params.isin > } > ) > ).orderBy(client.qb.sort('validStart', 'descending')); > > client.queryCollection( > config.MARKLOGIC_STATIC_COL_NAME, > query > ).result( > function (docs) { > if (docs.length >= 1) { > queryResults[queryResults.length] = docs[0]; > FetchLastPrice(docs[0].sedol, 1); > } else { > LogWrite('Unable to find static document for isin "' + > params.isin + '"'); > next(errResult); > } > }, > function (err) { > LogWrite(JSON.stringify(err, null, 4)); > next(errResult); > } > ); > > How can I fix it up? > > _______________________________________________ > 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 _______________________________________________ General mailing list [email protected] Manage your subscription at: http://developer.marklogic.com/mailman/listinfo/general
