Marklogic Node API - how to filter the results from a valuesBuilder

I want to retrieve all documents in my MarkLogic db that have month=November and also group them by name, and get the count of records per name. I know I can get the frequency per name by using valuesBuilder with a range index on the name field, but how can I filter this result so that I only get the count of records for the month of November?

Supposedly valuesBuilder.fromIndexes().where() can do the filtering, but I don’t know what to pass here and examples online seem to be sparse.

Posted by Roy Tang under notes at 21 Nov 2016 12:52pm #node.js #marklogic #questions #stackoverflow #software development
Also on: stackexchange / 1

Comments

Dave Cassel

2016-11-21 14:33:57

According to the API doc, the where clause takes a queryBuilder.query. With that in mind, you should be able to do something like this (not tested):

var marklogic = require('marklogic');
var vb = marklogic.valuesBuilder;
var qb = marklogic.queryBuilder;
vb
  .fromIndexes()
  .where(qb.value('month', 'November'))

If you enjoyed my content for some reason, I'd love to hear from you! Here are some options:

You can buy me a coffee!
You can write a reply on your own site and submit the URL as a webmention via the form below.
Or you can just contact me!