How to write cts query using marklogic java api

Question

I want to run below query using the MarkLogic Java API

cts:search(fn:doc(), cts:and-query((cts:collection-query("/abc/xyz"), 
cts:collection-query("/abc/xyz/pqr"))))

Sam Mefford · Accepted Answer · 2017-04-17 18:13:32Z

6

Use a StructuredQueryBuilder, the and() and collection() methods to construct the equivalent structured query to search for documents that are in both the collections.

// create the client -- this will change slightly in Java Client API 4.x
DatabaseClient client = 
    DatabaseClientFactory.newClient(host, port, user, password, authType);
// create a manager for searching
QueryManager queryMgr = client.newQueryManager();

// create a query builder
StructuredQueryBuilder qb = new StructuredQueryBuilder();
// build a search definition
StructuredQueryDefinition query = 
    qb.and(
      qb.collection("/abc/xyz"), 
      qb.collection("/abc/xyz/pqr"));

// run the search
queryMgr.search(query, resultsHandle);

edited Apr 17, 2017 at 18:13

Sam Mefford

2,47512 silver badges15 bronze badges

answered Apr 17, 2017 at 1:03

Mads Hansen

67.6k12 gold badges119 silver badges154 bronze badges

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

Comments

Mads Hansen · Accepted Answer · 2017-04-17 00:44:30Z

2

You need to use a structured query, rather than a cts:query. They're very similar in expressiveness. The Java Client API includes a builder class for structured query, com.marklogic.client.query.StructuredQueryBuilder.

For details, see the following:

edited Apr 17, 2017 at 0:44

Mads Hansen

67.6k12 gold badges119 silver badges154 bronze badges

answered Apr 16, 2017 at 14:33

kcoleman

6663 silver badges8 bronze badges

Collectives™ on Stack Overflow

How to write cts query using marklogic java api

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related