如何在mogodb php查询中进行排序和选择不同

本文介绍了如何在mogodb php查询中进行排序和选择不同的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述 29岁程序员，3月因学历无情被辞！ 我有一个具有聚合框架工作的mongo php查询，现在我想对该查询添加排序并选择不同的条件，请不要在没有这两个条件的情况下我的查询就可以完美地工作，i have a mongo php query with aggregate frame work, now i want to add sorting and select distinct criteria to that query, please not that my query is working perfectly without these two criterias,看看$result = $collection->aggregate(array(array('$match' => array( 'Details.Model' =>"AUDI", 'Details.Color' => "RED", "Category" =>"Car" ) ), array('$unwind' => '$Details' ), array('$match' => array( 'Details.Model' =>"AUDI", 'Details.Color' => "RED", "Category" =>"Car" )), array( '$project' => array( 'Pvalue' => '$Details.Price', "Ovalue" =>'$Details.OwnerNameFirst', "Cvalue"=>''$Category" ), ) ));我想要的是在 Details.Price 中排序升序，以及 Catagory 和 Details.OwnerNameFirst 选择不同what i want is to sort Details.Price in descending order, also Catagory and Details.OwnerNameFirst as Select Distinct请帮助这是结果，$ result的值this is the result, value of $result[{"_id":{"$id":"537dbca305a7d12f06000001"},"Pvalue":"60000","Ovalue":"jason","Cvalue":"Car"},{"_id": {"$id":"537dbca305a7d12f06000001"},"Pvalue":"59000","Ovalue":"george","Cvalue":"Jeep"},{"_id":{"$id":"537dbca305a7d12f06000001"},"Pvalue":"61000","Ovalue":"rahul""Cvalue":"Car"}]推荐答案似乎大多数都在那儿，但是问题是，如果我们正在分组（这意味着与众不同），那么这意味着价格有多个值。Seems mostly there, but the question is that if we are "grouping" ( which means distinct ) then that implies there are more than one value here for "price".那么您想要哪个？ $ min $ max $ first $ last 或 $ avg ？So which do you want? $min $max $first $last or $avg ?我将使用 $ avg 作为示例，但根据满足您的需要：I'll use $avg as the example, but replace according to your needs:$result = $collection->aggregate(array( array( '$match' => array( 'Details.Model' =>"AUDI", 'Details.Color' => "RED", "Category" =>"Car" ) ), array( '$unwind' => '$Details' ), array( '$match' => array( 'Details.Model' =>"AUDI", 'Details.Color' => "RED", "Category" =>"Car" ) ), array( '$group' => array( '_id' => array( "Ovalue" =>'$Details.OwnerNameFirst', "Cvalue"=>''$Category" ), 'Pvalue' => array( '$avg' => '$Details.Price' ) ) ), array( '$sort' => array( 'Pvalue' => -1, ) )));因此，一旦您通过各个键获得一个值，则您可以必须添加 $ sort 阶段。但请选择您真正想要的组运算符。So once you have a value by the distinct keys then you just add a $sort stage. But pick which of the group operators you actually want. 这篇关于如何在mogodb php查询中进行排序和选择不同的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！ 上岸，阿里云！