Not null property value search in marklogic

Question

I want to search documents from the query console based on some property which is not null. Lets say this is the json documents i have.

{ "a1" : "1234", "a2" : "abc", "a3" : null, "a4" : "mno" }

{ "a1" : "1235", "a2" : "xyz", "a3" : "value", "a4" : "mno" }

I can query documents based on property like this

cts:search(fn:collection(), cts:json-property-value-query("a3","value"));

I am not able to use not equal logical operator with this query. Can anybody let me know, if i have to search documents based on property a3 which is not null then what has to be the query ?

David Ennis -CleverLlamas.com · Accepted Answer · 2017-01-13 11:58:55Z

3

Using just value-queries, I would do it like this:

cts:search(fn:collection(), cts:and-query(
            (
            cts:json-property-value-query("a3", "*", "wildcarded"),
            cts:not-query(cts:json-property-value-query("a3", json:null()))
            )
           ) 
      );

I could have affected this with a smaller query by using a word-query instead of a value query.

Note that the use of the wildcarded query was just to isolate candidate documents that had the element 'a3'. For XML, I would have used an element-query to make sure I had the element, but I do not know of any way to do that in json directly.

answered Jan 13, 2017 at 11:58

David Ennis -CleverLlamas.com

7,81514 silver badges20 bronze badges

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

2 Comments

Tamas Over a year ago

What would the equivalent of this query using ServerSide JavaScript?

David Ennis -CleverLlamas.com Over a year ago

I do not have that answer - but I would think Query builder should be able to build the above. Note: This is a new question and will be lost in the comments. I suggest you open a new ticket and ask the question there.

Collectives™ on Stack Overflow

Not null property value search in marklogic

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related