AWS Cloudwatch Logs Insights: Query into array

Question

I have a Log Group with this kind of messages.

{
  "m": [
    {
      "id": "5b6973c7c86e8689368b4569",
      "ts": 1634112000.062
    },
        {
      "id": "6116d21e02e38f5045079c42",
      "ts": 1634120807.402
    },
    {
      "id": "60c368ff1085fc0d546fad52",
      "ts": 1634120807.512
    },
    {
      "id": "6053536817a46610797ed472",
      "ts": 1634120809.249
    }
  ]
}

I want to run a query over the field m.*.ts (It's an array). Something like this...

fields @message
| filter (m.*.ts > 1634112000.062 and m.*.ts < 1634120807.000 )

It's posible?

Answer 1

fields @message
  | parse @message "[*] *" as id, ts
  | filter (ts > 1634112000.062 and ts <  1634120807.000)