title: How to select field values from array of objects?
body: <p>I have a JSON column with following JSON</p>
  
  <pre><code>{
      "metadata": { "value": "JABC" },
      "force": false,
      "users": [ 
          { "id": "111", "comment": "abc" },
          { "id": "222", "comment": "abc" },
          { "id": "333" }
      ]
  }
  </code></pre>
  
  <p>I am expecting list of IDs from the query output <code>["111","222", "333"]</code>. I tried following query but getting null value. </p>
  
  <pre><code>select colName-&gt;'users'-&gt;&gt;'id' ids from tableName
  </code></pre>
  
  <p>How to get this specific field value from the array of object?</p>