none
How to query for multiple conditions within nested JSON array RRS feed

  • Question


  • Background:
                  
    I wish to locate all the nested fields within my JSON document that contain the "state" = "new" and where the "id" length > 4

         
              {
                  "id": "123"
                  "feedback" : {
                     "Features" : [
                                      {
                                        "state":"new"
                                        "id": "12345"

                                      }
                

                                  ]
             }


    This is what I have tried to do:

    Since this is a nested document. My query looks like this:



         SELECT
         c.feedback.Features,
         ARRAY(SELECT feedback.Features FROM c IN feedback.Features) AS Features FROM 
         c
         WHERE length(Features.id) >15


    However, the syntax is not correct and I am currently researching and looking for examples for this case


    Any help is appreciated
    Thursday, August 13, 2020 7:33 PM