Query
{
"group": {
"into": "cat",
"by": "p.category"
},
"as": "p",
"from": "Products",
"select": {
"category": "cat.key",
"products": "cat"
}
}
Results
[
{
"category": "Beverages",
"products": [
{
"category": "Beverages",
"unitsInStock": 39,
"productName": "Chai",
"unitPrice": 18.0,
"productId": 1
},
{
"category": "Beverages",
"unitsInStock": 17,
"productName": "Chang",
"unitPrice": 19.0,
"productId": 2
},
{
"category": "Beverages",
"unitsInStock": 20,
"productName": "Guaran\u00c3\u00a1 Fant\u00c3\u00a1stica",
"unitPrice": 4.5,
"productId": 24
},
{
"category": "Beverages",
"unitsInStock": 111,
"productName": "Sasquatch Ale",
"unitPrice": 14.0,
"productId": 34
},
{
"category": "Beverages",
"unitsInStock": 20,
"productName": "Steeleye Stout",
"unitPrice": 18.0,
"productId": 35
},
{
"category": "Beverages",
"unitsInStock": 17,
"productName": "C\u00c3\u00b4te de Blaye",
"unitPrice": 263.5,
"productId": 38
},
{
"category": "Beverages",
"unitsInStock": 69,
"productName": "Chartreuse verte",
"unitPrice": 18.0,
"productId": 39
},
{
"category": "Beverages",
"unitsInStock": 17,
"productName": "Ipoh Coffee",
"unitPrice": 46.0,
"productId": 43
},
{
"category": "Beverages",
"unitsInStock": 52,
"productName": "Laughing Lumberjack Lager",
"unitPrice": 14.0,
"productId": 67
},
{
"category": "Beverages",
"unitsInStock": 15,
"productName": "Outback Lager",
"unitPrice": 15.0,
"productId": 70
},
{
"category": "Beverages",
"unitsInStock": 125,
"productName": "Rh\u00c3\u00b6nbr\u00c3\u00a4u Klosterbier",
"unitPrice": 7.75,
"productId": 75
},
{
"category": "Beverages",
"unitsInStock": 57,
"productName": "Lakkalik\u00c3\u00b6\u00c3\u00b6ri",
"unitPrice": 18.0,
"productId": 76
}
]
},
{
"category": "Condiments",
"products": [
{
"category": "Condiments",
"unitsInStock": 13,
"productName": "Aniseed Syrup",
"unitPrice": 10.0,
"productId": 3
},
{
"category": "Condiments",
"unitsInStock": 53,
"productName": "Chef Anton's Cajun Seasoning",
"unitPrice": 22.0,
"productId": 4
},
{
"category": "Condiments",
"unitsInStock": 0,
"productName": "Chef Anton's Gumbo Mix",
"unitPrice": 21.35,
"productId": 5
},
{
"category": "Condiments",
"unitsInStock": 120,
"productName": "Grandma's Boysenberry Spread",
"unitPrice": 25.0,
"productId": 6
},
{
"category": "Condiments",
"unitsInStock": 6,
"productName": "Northwoods Cranberry Sauce",
"unitPrice": 40.0,
"productId": 8
},
{
"category": "Condiments",
"unitsInStock": 39,
"productName": "Genen Shouyu",
"unitPrice": 15.5,
"productId": 15
},
{
"category": "Condiments",
"unitsInStock": 27,
"productName": "Gula Malacca",
"unitPrice": 19.45,
"productId": 44
},
{
"category": "Condiments",
"unitsInStock": 113,
"productName": "Sirop d'\u00c3\u00a9rable",
"unitPrice": 28.5,
"productId": 61
},
{
"category": "Condiments",
"unitsInStock": 24,
"productName": "Vegie-spread",
"unitPrice": 43.9,
"productId": 63
},
{
"category": "Condiments",
"unitsInStock": 76,
"productName": "Louisiana Fiery Hot Pepper Sauce",
"unitPrice": 21.05,
"productId": 65
},
{
"category": "Condiments",
"unitsInStock": 4,
"productName": "Louisiana Hot Spiced Okra",
"unitPrice": 17.0,
"productId": 66
},
{
"category": "Condiments",
"unitsInStock": 32,
"productName": "Original Frankfurter gr\u00c3\u00bcne So\u00c3\u0178e",
"unitPrice": 13.0,
"productId": 77
}
]
},
{
"category": "Produce",
"products": [
{
"category": "Produce",
"unitsInStock": 15,
"productName": "Uncle Bob's Organic Dried Pears",
"unitPrice": 30.0,
"productId": 7
},
{
"category": "Produce",
"unitsInStock": 35,
"productName": "Tofu",
"unitPrice": 23.25,
"productId": 14
},
{
"category": "Produce",
"unitsInStock": 26,
"productName": "R\u00c3\u00b6ssle Sauerkraut",
"unitPrice": 45.6,
"productId": 28
},
{
"category": "Produce",
"unitsInStock": 20,
"productName": "Manjimup Dried Apples",
"unitPrice": 53.0,
"productId": 51
},
{
"category": "Produce",
"unitsInStock": 4,
"productName": "Longlife Tofu",
"unitPrice": 10.0,
"productId": 74
}
]
},
{
"category": "Meat/Poultry",
"products": [
{
"category": "Meat/Poultry",
"unitsInStock": 29,
"productName": "Mishi Kobe Niku",
"unitPrice": 97.0,
"productId": 9
},
{
"category": "Meat/Poultry",
"unitsInStock": 0,
"productName": "Alice Mutton",
"unitPrice": 39.0,
"productId": 17
},
{
"category": "Meat/Poultry",
"unitsInStock": 0,
"productName": "Th\u00c3\u00bcringer Rostbratwurst",
"unitPrice": 123.79,
"productId": 29
},
{
"category": "Meat/Poultry",
"unitsInStock": 0,
"productName": "Perth Pasties",
"unitPrice": 32.8,
"productId": 53
},
{
"category": "Meat/Poultry",
"unitsInStock": 21,
"productName": "Tourti\u00c3\u00a8re",
"unitPrice": 7.45,
"productId": 54
},
{
"category": "Meat/Poultry",
"unitsInStock": 115,
"productName": "P\u00c3\u00a2t\u00c3\u00a9 chinois",
"unitPrice": 24.0,
"productId": 55
}
]
},
{
"category": "Seafood",
"products": [
{
"category": "Seafood",
"unitsInStock": 31,
"productName": "Ikura",
"unitPrice": 31.0,
"productId": 10
},
{
"category": "Seafood",
"unitsInStock": 24,
"productName": "Konbu",
"unitPrice": 6.0,
"productId": 13
},
{
"category": "Seafood",
"unitsInStock": 42,
"productName": "Carnarvon Tigers",
"unitPrice": 62.5,
"productId": 18
},
{
"category": "Seafood",
"unitsInStock": 10,
"productName": "Nord-Ost Matjeshering",
"unitPrice": 25.89,
"productId": 30
},
{
"category": "Seafood",
"unitsInStock": 112,
"productName": "Inlagd Sill",
"unitPrice": 19.0,
"productId": 36
},
{
"category": "Seafood",
"unitsInStock": 11,
"productName": "Gravad lax",
"unitPrice": 26.0,
"productId": 37
},
{
"category": "Seafood",
"unitsInStock": 123,
"productName": "Boston Crab Meat",
"unitPrice": 18.4,
"productId": 40
},
{
"category": "Seafood",
"unitsInStock": 85,
"productName": "Jack's New England Clam Chowder",
"unitPrice": 9.65,
"productId": 41
},
{
"category": "Seafood",
"unitsInStock": 5,
"productName": "Rogede sild",
"unitPrice": 9.5,
"productId": 45
},
{
"category": "Seafood",
"unitsInStock": 95,
"productName": "Spegesild",
"unitPrice": 12.0,
"productId": 46
},
{
"category": "Seafood",
"unitsInStock": 62,
"productName": "Escargots de Bourgogne",
"unitPrice": 13.25,
"productId": 58
},
{
"category": "Seafood",
"unitsInStock": 101,
"productName": "R\u00c3\u00b6d Kaviar",
"unitPrice": 15.0,
"productId": 73
}
]
},
{
"category": "Dairy",
"products": [
{
"category": "Dairy Products",
"unitsInStock": 22,
"productName": "Queso Cabrales",
"unitPrice": 21.0,
"productId": 11
},
{
"category": "Dairy Products",
"unitsInStock": 86,
"productName": "Queso Manchego La Pastora",
"unitPrice": 38.0,
"productId": 12
},
{
"category": "Dairy Products",
"unitsInStock": 0,
"productName": "Gorgonzola Telino",
"unitPrice": 12.5,
"productId": 31
},
{
"category": "Dairy Products",
"unitsInStock": 9,
"productName": "Mascarpone Fabioli",
"unitPrice": 32.0,
"productId": 32
},
{
"category": "Dairy Products",
"unitsInStock": 112,
"productName": "Geitost",
"unitPrice": 2.5,
"productId": 33
},
{
"category": "Dairy Products",
"unitsInStock": 79,
"productName": "Raclette Courdavault",
"unitPrice": 55.0,
"productId": 59
},
{
"category": "Dairy Products",
"unitsInStock": 19,
"productName": "Camembert Pierrot",
"unitPrice": 34.0,
"productId": 60
},
{
"category": "Dairy Products",
"unitsInStock": 26,
"productName": "Gudbrandsdalsost",
"unitPrice": 36.0,
"productId": 69
},
{
"category": "Dairy Products",
"unitsInStock": 26,
"productName": "Flotemysost",
"unitPrice": 21.5,
"productId": 71
},
{
"category": "Dairy Products",
"unitsInStock": 14,
"productName": "Mozzarella di Giovanni",
"unitPrice": 34.8,
"productId": 72
}
]
},
{
"category": "Confections",
"products": [
{
"category": "Confections",
"unitsInStock": 29,
"productName": "Pavlova",
"unitPrice": 17.45,
"productId": 16
},
{
"category": "Confections",
"unitsInStock": 25,
"productName": "Teatime Chocolate Biscuits",
"unitPrice": 9.2,
"productId": 19
},
{
"category": "Confections",
"unitsInStock": 40,
"productName": "Sir Rodney's Marmalade",
"unitPrice": 81.0,
"productId": 20
},
{
"category": "Confections",
"unitsInStock": 3,
"productName": "Sir Rodney's Scones",
"unitPrice": 10.0,
"productId": 21
},
{
"category": "Confections",
"unitsInStock": 76,
"productName": "NuNuCa Nu\u00c3\u0178-Nougat-Creme",
"unitPrice": 14.0,
"productId": 25
},
{
"category": "Confections",
"unitsInStock": 15,
"productName": "Gumb\u00c3\u00a4r Gummib\u00c3\u00a4rchen",
"unitPrice": 31.23,
"productId": 26
},
{
"category": "Confections",
"unitsInStock": 49,
"productName": "Schoggi Schokolade",
"unitPrice": 43.9,
"productId": 27
},
{
"category": "Confections",
"unitsInStock": 36,
"productName": "Zaanse koeken",
"unitPrice": 9.5,
"productId": 47
},
{
"category": "Confections",
"unitsInStock": 15,
"productName": "Chocolade",
"unitPrice": 12.75,
"productId": 48
},
{
"category": "Confections",
"unitsInStock": 10,
"productName": "Maxilaku",
"unitPrice": 20.0,
"productId": 49
},
{
"category": "Confections",
"unitsInStock": 65,
"productName": "Valkoinen suklaa",
"unitPrice": 16.25,
"productId": 50
},
{
"category": "Confections",
"unitsInStock": 17,
"productName": "Tarte au sucre",
"unitPrice": 49.3,
"productId": 62
},
{
"category": "Confections",
"unitsInStock": 6,
"productName": "Scottish Longbreads",
"unitPrice": 12.5,
"productId": 68
}
]
},
{
"category": "Grains/Cereals",
"products": [
{
"category": "Grains/Cereals",
"unitsInStock": 104,
"productName": "Gustaf's Kn\u00c3\u00a4ckebr\u00c3\u00b6d",
"unitPrice": 21.0,
"productId": 22
},
{
"category": "Grains/Cereals",
"unitsInStock": 61,
"productName": "Tunnbr\u00c3\u00b6d",
"unitPrice": 9.0,
"productId": 23
},
{
"category": "Grains/Cereals",
"unitsInStock": 26,
"productName": "Singaporean Hokkien Fried Mee",
"unitPrice": 14.0,
"productId": 42
},
{
"category": "Grains/Cereals",
"unitsInStock": 38,
"productName": "Filo Mix",
"unitPrice": 7.0,
"productId": 52
},
{
"category": "Grains/Cereals",
"unitsInStock": 21,
"productName": "Gnocchi di nonna Alice",
"unitPrice": 38.0,
"productId": 56
},
{
"category": "Grains/Cereals",
"unitsInStock": 36,
"productName": "Ravioli Angelo",
"unitPrice": 19.5,
"productId": 57
},
{
"category": "Grains/Cereals",
"unitsInStock": 22,
"productName": "Wimmers gute Semmelkn\u00c3\u00b6del",
"unitPrice": 33.25,
"productId": 64
}
]
}
]