Marklogic QueryByExample in collection NodeJS

Question

TLDR

Is there a way to limit queryByExample to a collection in NodeJS?

Problem faced

I have a complex query with some optional fields (i.e. sometimes some search fields will be omitted). So I need to create a query dynamically, e.g. in JSON. QueryByExample seems to be the right tool to use here as it gives me that flexibility to pass a JSON. However my problem is that I would like to limit my search to only one collection or directory.

e.g. I was hoping for something like

searchJSON = {
        title: { $word: "test" },
        description: { $word: "desc" }
};

//query
db.documents.query(qb.where(
    qb.collection("collectionName"),
    qb.byExample(searchJSON)
)).result()...

In this case searchJSON could have been built dynamically, for example maybe sometimes title may be omitted from the search.

This doesn't work because the query builder only allows queryByExample to be the only query. But I'd instead like to built a dynamic search query which is limited to a collection or directory.

ehennum · Accepted Answer · 2017-07-26 16:24:37Z

2

At present, I think you would have to express the query with QueryBuilder instead of Query By Example using

qb.and([
  qb.collection('collectionName'),
  qb.word('title', 'test'),
  qb.word('description', 'desc')
  ])

See http://docs.marklogic.com/jsdoc/queryBuilder.html#word

That said, it should be possible for the Node.js API to relax that restriction based on the fixes in MarkLogic 9.0-2

Please file an issue on https://github.com/marklogic/node-client-api

answered Jul 26, 2017 at 16:24

ehennum

7,33515 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Kholofelo Over a year ago

This works. I wasn't aware that the and method can take an array. Thank you.

Collectives™ on Stack Overflow

Marklogic QueryByExample in collection NodeJS

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related