I'm new to Marklogic and need to do a quick evalution of Marklogic in (4 day's). I was wondering how I can execute a query, using the java API, that will get me all the json documents that DO NOT have a certain jsonKey?
I'm dazzeld at the moment by the query api and don't know what to use for this. Any help is greatly appreciated!!
Regards
Jan van de Klok
So you're trying to use JSON key-value queries as https://docs.marklogic.com/guide/java/searches#id_56295 describes? Those appear to be positive queries only, equivalent to cts:element-value-query terms.
For a more complex query you'd probably use the structured query option, described in the next section of the same guide. You could construct it in XML using the search:not-query and search:value-constraint-query elements. Or use interfaces like http://docs.marklogic.com/javadoc/client/com/marklogic/client/query/StructuredQueryBuilder.NotQuery.html to construct it in Java code.
Another option is to use a simple string query with a defined constraint option, something like cat -mytag:dog. But that means defining mytag as a custom constraint with cts:not-query and cts:element-value-query. I believe you'd have to write that in XQuery. In the long run there's only so much you can do in MarkLogic without using XQuery.
