Marklogic - I want do element search using java api with key-value within array section of the json document

Question

I want to search for element with key-value from array element section of the document. Lets say i have json looks like -

{ 
   "name":"abc", 
   "lastName":"xyz", 
   "description":"aaaaa aaaa", 
   "dob":11-10-1988,
   "workInformation":[
       {
          "address":"kolkata", 
          "workFor":"vvv Pvt Ltd"
       },
        {
          "address":"bangalore", 
          "workFor":"www Pvt Ltd"
       }
    ]
}

Lets say i want to search using java api inside array property workInformation for below mentioned key and value -

key - workFor, value - vvv Pvt Ltd

Please let me know, how to do it.

Thanks for reading.

Sam Mefford · Accepted Answer · 2016-06-22 17:58:29Z

6

One easy way is to use StructuredQueryBuilder.value. For example:

StructuredQueryBuilder sqb = new StructuredQueryBuilder();
QueryDefinition query = sqb.value(sqb.jsonProperty("workFor"), "vvv Pvt Ltd");

Another option is to use QBE.

answered Jun 22, 2016 at 17:58

Sam Mefford

2,47512 silver badges15 bronze badges

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

Collectives™ on Stack Overflow

Marklogic - I want do element search using java api with key-value within array section of the json document

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related