Hi,
I am able to get data for
Select META(d).id from DeliveryAdapter d UNNEST d.vanTripDetail O order by O.departureTime asc LIMIT 4
data is as below
[
{
“id”: “2639_3684_2017-03-07”
},
{
“id”: “2639_4115_2017-03-09”
},
{
“id”: “2639_4141_2017-03-09”
},
{
“id”: “2639_3684_2017-03-13”
}
]
I want a subquery to delete these 4 rows
i tried with
Delete from DeliveryAdapter r where Meta®.id in (
Select META(d).id from DeliveryAdapter d UNNEST d.vanTripDetail O order by O.departureTime asc LIMIT 4)
but it’s not deleting.
How to get the query to delete
Thanks,
Vinay J