Get only json documents using Marklogic node.js query builder

Question

In my Marklogic DB I have mixed documents formats. And I would like to get only JSON documents from the collection. I have a query builder statement like this

    const documents = await dbClient.documents
        .query(
            qb
                .where(qb.collection('myCollection'))
                .slice(0, 10)
        )
        .result();

Is it possible to use some filter here to get only JSON documents?

Mads Hansen · Accepted Answer · 2021-12-16 17:26:35Z

3

I'm not in a position to quickly test the following, but did walk the docs a bit. Per those docs, you should be able to specify the document format using .withOptions(). That method's search option supports all of cts:search's options, which includes specifying the document format via "format-FORMAT", or format-json, in your case.

const documents = await dbClient.documents
    .query(
        qb.where(qb.collection('myCollection'))
          .withOptions({search: ['format-json']})
          .slice(0, 10)
    )
    .result();

edited Dec 16, 2021 at 17:26

Mads Hansen

67.6k12 gold badges119 silver badges154 bronze badges

answered Dec 16, 2021 at 17:23

Brent Hartwig

463 bronze badges

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

1 Comment

Taras Dubyk Over a year ago

It works as expected! Thank you!

Collectives™ on Stack Overflow

Get only json documents using Marklogic node.js query builder

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