title: How can do NRQL(NewRelic) query on json data
body: <p>This is data  which stored in newRelic.
  I want to query on the field <strong>entity</strong> which is inside payload field. How will write the query. Thanks in advance</p>
  <pre><code>  &quot;results&quot;: [
      {
        &quot;events&quot;: [
          {
            &quot;appId&quot;: 1818553174,
            &quot;appName&quot;: &quot;abc&quot;,
            &quot;entityGuid&quot;: &quot;MTUxMjA2OHxBUE18QVBQTElDQVRJT058MTgxODU1MzE3NA&quot;,
            &quot;host&quot;: &quot;C02G40VUMD6M&quot;,
            &quot;payload&quot;: &quot;{\&quot;entity\&quot;:{\&quot;id\&quot;:\&quot;aa6e9174-5755-48c1-8d55-6054e57b05d2\&quot;,\&quot;konelId\&quot;:1642835460236,\&quot;sourceID\&quot;:null,\&quot;make\&quot;:\&quot;Datsun\&quot;,\&quot;model\&quot;:\&quot;Go+\&quot;,\&quot;trim\&quot;:\&quot;1.2 T Bensin\&quot;,\&quot;trimDetails\&quot;:null,\&quot;year\&quot;:2014}&quot;,
            &quot;realAgentId&quot;: 1818556319,
            &quot;tags.account&quot;: &quot;STG&quot;,
            &quot;tags.accountId&quot;: &quot;1512068&quot;,
            &quot;tags.guid&quot;: &quot;MTUxMjA2OHxBUE&quot;,
            &quot;tags.trustedAccountId&quot;: &quot;1705222&quot;,
            &quot;timestamp&quot;: 1643268880422
          }
  </code></pre>