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" : [
                                        "id": "12345"



    This is what I have tried to do:

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

         ARRAY(SELECT feedback.Features FROM c IN feedback.Features) AS Features FROM 
         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:36 PM