我有一个arangodb集合中的产品数据库,其中一个产品有多个尺寸。问题是,对于每个尺寸,相同的产品都是重复的。但每个产品都有一个共同的组号。如下所示:
{"name": "product1", "description": "someDescription", size: 5,price: 12 groupNumber: 12}
{"name": "product1", "description": "someDescription", size: 15, price: 26, groupNumber: 12}
{"name": "product1", "description": "someDescription", size: 25, price: 84, groupNumber: 12}
{"name": "product1", "description": "someDescription", size: 35, price: 106, groupNumber: 12}
{"name": "product2", "description": "someDescription", size: 5, price: 12, groupNumber: 11}
{"name": "product2", "description": "someDescription", size: 15, price: 22, groupNumber: 11}
{"name": "product2", "description": "someDescription", size: 25, price: 32, groupNumber: 11}
{"name": "product2", "description": "someDescription", size: 35, price: 43, groupNumber: 11}
我现在必须显示产品列表(在网页中),但每个产品应该只出现一次,每个产品的大小和价格都以数组形式显示,如下所示:
product1 someDescription sizes: 5,15,25,35, prices: 12,26,84,106
product2 someDescription sizes: 5,15,25,35, prices: 12,22,32,43
...
我该怎么做?
1条答案
按热度按时间c86crjj01#
忽略
groupNumber
并按name
分组,查询如下所示:给定(已更正的)示例数据,查询将返回:
分组后的值没有排序,但是尺码和价格的位置是对应的,你可以将这些值压缩到尺码-价格图中,以缓解这个问题:
屈服: