01.JSON ครับ
02.{
03."select * from data where product = 'xxx' and data->> 'type'='Monitor'": [
04. {
05. "id" : 684886,
06. "product" : "xxxx",
07. "data" : "{\"id\": \"002F000C424E430220313031\", \"afr\": 14.699999809265, \"car\": \"yamaha\"}",
08. "created_at" : "2019-04-09T13:19:11Z"
09. },
10. {
11. "id" : 645534,
12. "product" : "xxxx",
13. "data" : "{\"id\": \"002F000C424E430220313031\", \"afr\": 14.699999809265, \"car\": \"yamaha\"}",
14. "created_at" : "2019-04-09T13:19:11Z"
15. },
16. {
17. "id" : 678245,
18. "product" : "xxxx",
19. "data" : "{\"id\": \"002F000C424E430220313031\", \"afr\": 14.699999809265, \"car\": \"yamaha\"}",
20. "created_at" : "2019-04-09T13:19:11Z"
21. },
22. {
23. "id" : 623452,
24. "product" : "xxxx",
25. "data" : "{\"id\": \"002F000C424E430220313031\", \"afr\": 14.699999809265, \"car\": \"yamaha\"}",
26. "created_at" : "2019-04-09T13:19:11Z"
27. }
28.]}
