title: How can I filter array values in a Json in Sql Server
body: <p>How can I filter an array value without specifying the index in the array</p>
  <p>This is my array</p>
  <pre><code>{   
     &quot;level1&quot;:{
        &quot;level2&quot;:[
           {
              &quot;level3&quot;:&quot;test&quot;,            
           }
        ]
     }
  }
  </code></pre>
  <p>I want to retrive all rows that contains a level3 a value test.
  Something like this</p>
  <pre><code>select * from Documents 
  where Json_Value(DocumentInfo, '$.level1.level2[X].level3') = 'test'
  </code></pre>
  <p>It this not possible in Sql Server?</p>