add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Records: 1  Duplicates: 0  Warnings: 0
id JSON_PRETTY(product_logs) created_at
1 {
  "products": [
    {
      "logs": [
        {
          "log_info": "some text",
          "log_time": "2022-07-13 01:30:00",
          "log_type": "manual"
        }
      ],
      "time": "2022-07-12 01:30:00",
      "product_id": 123
    },
    {
      "logs": [],
      "time": "2022-07-13 01:31:00",
      "product_id": 124
    }
  ]
}		 2022-07-13 07:13:00
id created_at JSON_PRETTY(JSON_OBJECT('products', JSON_ARRAYAGG(jsontable.log_data)))
1 2022-07-13 07:13:00 {
  "products": [
    {
      "logs": [],
      "time": "2022-07-13 01:31:00",
      "product_id": 124
    }
  ]
}