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.
]}