i have table rows this:
{ "id": "12345" "created_date": fri may 27 2016 22:06:25 gmt+00:00 , "image": true } { "id": "6789" "created_date": mon may 30 2016 07:48:35 gmt+00:00 , "video": true }{ "id": "12345" "created_date": fri may 21 2016 22:06:25 gmt+00:00 , "image": true } { "id": "6789" "created_date": mon may 6 2016 07:48:35 gmt+00:00 , "video": true } etc...
i return latest (newest, earliest date) object has "video":true
in addition want return latest object has "image":true
.
but, want in 1 query, since done on same table.
ideally answer be:
[{ "id": "12345" "created_date": fri may 27 2016 22:06:25 gmt+00:00 , "image": true }, { "id": "6789" "created_date": mon may 30 2016 07:48:35 gmt+00:00 , "video": true }]
is there anyway this?
you can combine 2 queries writing r.expr([query1, query2])
, should work.