Sort - Revision history

40166222 at 16:38, 18 July 2018

2018-07-18T16:38:41Z

← Older revision		Revision as of 16:38, 18 July 2018
Line 7:		Line 7:
	</div>		</div>
	<div class="q nonum" data-lang="mongo">Sort all the documents in world by continent descending, then name ascending. Show only name and continent.		<div class="q nonum" data-lang="mongo">Sort all the documents in world by continent descending, then name ascending. Show only name and continent.
	<pre class="def">		<pre class="def"><nowiki>db.world.find({}, {name: 1, continent: 1 ,_id: 0}).sort({"continent": -1, "name": 1});</nowiki></pre>
	db.world.find({},{name:1,continent:1,_id:0}).sort({"continent": -1, "name": 1})
	</pre>
	</div>		</div>

40166222 at 02:31, 6 April 2018

2018-04-06T02:31:19Z

← Older revision		Revision as of 02:31, 6 April 2018
Line 2:		Line 2:
	<div style="min-height:25em">		<div style="min-height:25em">
	<code>sort()</code> is a cursor method that orders the results of a query.<br/>		<code>sort()</code> is a cursor method that orders the results of a query.<br/>
	The aggregation framework provides the <code>$sort</code> operator, and <code>~~map_reduce~~</code> takes sort as a parameter that is applied to the input documents.<br/><br/>		The aggregation framework provides the <code>$sort</code> operator, and <code>mapReduce</code> takes sort as a parameter that is applied to the input documents.<br/><br/>
	The syntax for <code>sort()</code> is <code>sort({<field>:<value>, <field>:<value>, ...})</code> where 1 indicates ascending and -1 indicates descending.<br/>		The syntax for <code>sort()</code> is <code>sort({<field>:<value>, <field>:<value>, ...})</code> where '''1''' indicates ascending and '''-1''' indicates descending.<br/>
	The order in which fields are specified dictates which fields are sorted first.<br/><br/>		The order in which fields are specified dictates which fields are sorted first.<br/><br/>
	~~</code>~~
	</div>		</div>
	<div class="q nonum" data-lang="mongo">Sort all the documents in world by continent descending, then name ascending. Show only name and continent.		<div class="q nonum" data-lang="mongo">Sort all the documents in world by continent descending, then name ascending. Show only name and continent.

40166222: Convert old python API code to mongo shell.

2018-04-06T02:29:58Z

Convert old python API code to mongo shell.

← Older revision		Revision as of 02:29, 6 April 2018
Line 3:		Line 3:
	<code>sort()</code> is a cursor method that orders the results of a query.<br/>		<code>sort()</code> is a cursor method that orders the results of a query.<br/>
	The aggregation framework provides the <code>$sort</code> operator, and <code>map_reduce</code> takes sort as a parameter that is applied to the input documents.<br/><br/>		The aggregation framework provides the <code>$sort</code> operator, and <code>map_reduce</code> takes sort as a parameter that is applied to the input documents.<br/><br/>
	The syntax for <code>sort()</code> is <code>sort(<field>:<value>)</code> where 1 indicates ascending and -1 indicates descending.<br/>		The syntax for <code>sort()</code> is <code>sort({<field>:<value>, <field>:<value>, ...})</code> where 1 indicates ascending and -1 indicates descending.<br/>
	The order in which fields are specified dictates which fields are sorted first.<br/><br/>		The order in which fields are specified dictates which fields are sorted first.<br/><br/>
	~~Python does not store key order for dicts, so instead of the mongo shell <code>{<field1>:<value>,<field2>:<value>}</code> use <code>[(<field1>,<value>), (<field2>,<value>)]~~</code>		</code>
	</div>		</div>
	<div class="q nonum" data-lang="mongo">Sort all the documents in world by continent descending, then name ascending. Show only name and continent.		<div class="q nonum" data-lang="mongo">Sort all the documents in world by continent descending, then name ascending. Show only name and continent.
	<pre class=def>		<pre class="def">
	db.world.find({},{name:1,continent:1,_id:0}).sort([("continent",-1),("name",1)])		db.world.find({},{name:1,continent:1,_id:0}).sort({"continent": -1, "name": 1})

	</pre>		</pre>
	</div>		</div>

Andr3w at 15:22, 3 December 2015

2015-12-03T15:22:46Z

← Older revision		Revision as of 15:22, 3 December 2015
Line 7:		Line 7:
	Python does not store key order for dicts, so instead of the mongo shell <code>{<field1>:<value>,<field2>:<value>}</code> use <code>[(<field1>,<value>), (<field2>,<value>)]</code>		Python does not store key order for dicts, so instead of the mongo shell <code>{<field1>:<value>,<field2>:<value>}</code> use <code>[(<field1>,<value>), (<field2>,<value>)]</code>
	</div>		</div>
	<div class="q nonum" data-lang="~~py3~~">Sort all the documents in world by continent descending, then name ascending. Show only name and continent.		<div class="q nonum" data-lang="mongo">Sort all the documents in world by continent descending, then name ascending. Show only name and continent.
	<pre class=def>		<pre class=def>
	db.world.find({},{name:1,continent:1,_id:0}).sort([("continent",-1),("name",1)])		db.world.find({},{name:1,continent:1,_id:0}).sort([("continent",-1),("name",1)])

Andr3w at 15:22, 3 December 2015

2015-12-03T15:22:28Z

@@ Line 1: / Line 1: @@
 {{TopTenTips}}
 <div style="min-height:25em">
@@ Line 25: / Line 9: @@
 <div class="q nonum" data-lang="py3">Sort all the documents in world by continent descending, then name ascending. Show only name and continent.
 <pre class=def>
-pp.pprint(list(
+db.world.find({},{name:1,continent:1,_id:0}).sort([("continent",-1),("name",1)])
 </pre>
 </div>

40166222 at 13:27, 28 July 2015

2015-07-28T13:27:22Z

← Older revision		Revision as of 13:27, 28 July 2015
Line 23:		Line 23:
	Python does not store key order for dicts, so instead of the mongo shell <code>{<field1>:<value>,<field2>:<value>}</code> use <code>[(<field1>,<value>), (<field2>,<value>)]</code>		Python does not store key order for dicts, so instead of the mongo shell <code>{<field1>:<value>,<field2>:<value>}</code> use <code>[(<field1>,<value>), (<field2>,<value>)]</code>
	</div>		</div>
	<div class=q data-lang="py3">Sort all the documents in world by continent descending, then name ascending. Show only name and continent.		<div class="q nonum" data-lang="py3">Sort all the documents in world by continent descending, then name ascending. Show only name and continent.
	<pre class=def>		<pre class=def>
	pp.pprint(list(		pp.pprint(list(

40166222 at 11:54, 28 July 2015

2015-07-28T11:54:27Z

← Older revision		Revision as of 11:54, 28 July 2015
Line 16:		Line 16:
	</pre>		</pre>
	{{TopTenTips}}		{{TopTenTips}}
			<div style="min-height:25em">
	<code>sort()</code> is a cursor method that orders the results of a query.<br/>		<code>sort()</code> is a cursor method that orders the results of a query.<br/>
	The aggregation framework provides the <code>$sort</code> operator, and <code>map_reduce</code> takes sort as a parameter that is applied to the input documents.<br/><br/>		The aggregation framework provides the <code>$sort</code> operator, and <code>map_reduce</code> takes sort as a parameter that is applied to the input documents.<br/><br/>
Line 21:		Line 22:
	The order in which fields are specified dictates which fields are sorted first.<br/><br/>		The order in which fields are specified dictates which fields are sorted first.<br/><br/>
	Python does not store key order for dicts, so instead of the mongo shell <code>{<field1>:<value>,<field2>:<value>}</code> use <code>[(<field1>,<value>), (<field2>,<value>)]</code>		Python does not store key order for dicts, so instead of the mongo shell <code>{<field1>:<value>,<field2>:<value>}</code> use <code>[(<field1>,<value>), (<field2>,<value>)]</code>
			</div>
	<div class=q data-lang="py3">Sort all the documents in world by continent descending, then name ascending. Show only name and continent.		<div class=q data-lang="py3">Sort all the documents in world by continent descending, then name ascending. Show only name and continent.
	<pre class=def>		<pre class=def>

40166222 at 11:51, 28 July 2015

2015-07-28T11:51:24Z

← Older revision		Revision as of 11:51, 28 July 2015
Line 16:		Line 16:
	</pre>		</pre>
	{{TopTenTips}}		{{TopTenTips}}
	~~<div style="height:25em">~~
	<code>sort()</code> is a cursor method that orders the results of a query.<br/>		<code>sort()</code> is a cursor method that orders the results of a query.<br/>
	The aggregation framework provides the <code>$sort</code> operator, and <code>map_reduce</code> takes sort as a parameter that is applied to the input documents.<br/><br/>		The aggregation framework provides the <code>$sort</code> operator, and <code>map_reduce</code> takes sort as a parameter that is applied to the input documents.<br/><br/>
Line 22:		Line 21:
	The order in which fields are specified dictates which fields are sorted first.<br/><br/>		The order in which fields are specified dictates which fields are sorted first.<br/><br/>
	Python does not store key order for dicts, so instead of the mongo shell <code>{<field1>:<value>,<field2>:<value>}</code> use <code>[(<field1>,<value>), (<field2>,<value>)]</code>		Python does not store key order for dicts, so instead of the mongo shell <code>{<field1>:<value>,<field2>:<value>}</code> use <code>[(<field1>,<value>), (<field2>,<value>)]</code>

	~~</div>~~
	<div class=q data-lang="py3">Sort all the documents in world by continent descending, then name ascending. Show only name and continent.		<div class=q data-lang="py3">Sort all the documents in world by continent descending, then name ascending. Show only name and continent.
	<pre class=def>		<pre class=def>

40166222 at 13:51, 27 July 2015

2015-07-27T13:51:36Z

← Older revision		Revision as of 13:51, 27 July 2015
Line 27:		Line 27:
	<pre class=def>		<pre class=def>
	pp.pprint(list(		pp.pprint(list(
	db.world.find({},{"name":1,"continent":1,"_id":0}).sort([("continent",-1),("name",1)]):		db.world.find({},{"name":1,"continent":1,"_id":0}).sort([("continent",-1),("name",1)])
	))		))

	</pre>		</pre>
	</div>		</div>

40166222 at 13:51, 27 July 2015

2015-07-27T13:51:24Z

← Older revision		Revision as of 13:51, 27 July 2015
Line 26:		Line 26:
	<div class=q data-lang="py3">Sort all the documents in world by continent descending, then name ascending. Show only name and continent.		<div class=q data-lang="py3">Sort all the documents in world by continent descending, then name ascending. Show only name and continent.
	<pre class=def>		<pre class=def>
	~~for x in~~ db.world.find({},{"name":1,"continent":1,"_id":0}).sort([("continent",-1),("name",1)]):		pp.pprint(list(
	~~print(x~~)		db.world.find({},{"name":1,"continent":1,"_id":0}).sort([("continent",-1),("name",1)]):
			))

	</pre>		</pre>
	</div>		</div>