Hi,
I want to get entire document using N1ql
I tried with below 2 query but getting only OrderDetails details
select d.* from Delivery.OrderDetails d where d.orderId in [‘114156723’]
select d.*,Delivery.OrderLines from Delivery.OrderDetails d where d.orderId in [‘114156723’]
Delivery is my bucket Name
Below is the document
Please help me in writing a query to get entire document
{
“OrderDetails”: {
“orderType”: “Delivery”,
“isCorelineSubstituted”: “N”,
“orderId”: “114156737”,
“vanNumber”: “5J”,
“EPurseName”: " Gift Card",
“orderStatus”: “Checked Out”,
“voucherPromotionName”: “Computers for Schools”,
“customerNumber”: “85516242”,
“storeId”: “5031”,
“customerSupportNumber”: “0800 323 4040”,
“shortOrderNumber”: “4692”,
“isStoredOrder”: false,
“deliveryDate”: “08/01/2016”,
“VoucherName”: “Clubcard Voucher”
},
“OrderLines”: {
“Product”: [
{
“isApplicableForVat”: “N”,
“productQuantity”: “6”,
“productId”: “52599951”,
“pickingZone”: “CH”,
“productTotalPrice”: “7.8000”,
“productSubGroup”: “F51CA”,
“productUnitPrice”: “1.30”,
“productType”: “Chilled”,
“productDescription”: "Ni Pstrd S/Skimmed Milk 3ltr "
},
{
“isApplicableForVat”: “Y”,
“productQuantity”: “1”,
“productId”: “55771771”,
“pickingZone”: “FZ”,
“productTotalPrice”: “2.4900”,
“productSubGroup”: “F76DC”,
“productUnitPrice”: “2.49”,
“productType”: “Frozen”,
“productDescription”: “Dale Farm Vanilla Ice Cream 1ltr *”
}
]
},
“DeliveryDetails”: {
“deliverySlotStartTime”: “20:00”,
“deliverySlotEndTime”: “21:00”
},
“ClubCardStatements”: {
“totalPoints”: “118”,
“totalPointsTillDate”: “675”,
“clubCardDigits”: “7202”,
“regularPoints”: “118”,
“greenPoints”: “0”
},
“ECoupons”: {
“coupon”: “0.0000”
},
“_class”: “com.model.CustomerReceipt”,
“OutOfStockProducts”: {},
}