Find - Revision history

40166222 at 13:14, 17 October 2018

2018-10-17T13:14:39Z

← Older revision		Revision as of 13:14, 17 October 2018
Line 1:		Line 1:
	{{TopTenTips}}		{{TopTenTips}}
	<~~code~~>find()</~~code~~> is used to filter and project.<br/>		<syntaxhighlight lang="JavaScript" inline>find()</syntaxhighlight> is used to filter and project.<br/>
	By default <~~code~~>find()</~~code~~> returns a cursor containing all the documents in the collection it is used on. This is the same as <~~code~~>find({})</~~code~~>.<br /><br/>		By default <syntaxhighlight lang="JavaScript" inline>find()</syntaxhighlight> returns a cursor containing all the documents in the collection it is used on. This is the same as <syntaxhighlight lang="JavaScript" inline>find({})</syntaxhighlight>.<br /><br/>
	To get all the documents with a certain value, <~~code~~>find(<field>:{"$eq": <value>}})</~~code~~> can be used, this can be simplified to <~~code~~>find(<field>: <value>})</~~code~~>.<br/>		To get all the documents with a certain value, <syntaxhighlight lang="JavaScript" inline>find(<field>:{"$eq": <value>}})</syntaxhighlight> can be used, this can be simplified to <syntaxhighlight lang="JavaScript" inline>find(<field>: <value>})</syntaxhighlight>.<br/>
	~~<code>~~$eq~~</code>~~ can be replaced with other conditional operators such as ~~<code>~~$lt~~</code>~~, ~~<code>~~$gt~~</code>~~ to perform less than or greater than comparisons.<br/><br/>		'''$eq''' can be replaced with other conditional operators such as '''$lt''', '''$gt''' to perform less than or greater than comparisons.<br/><br/>
	To query nested documents, [http://docs.mongodb.org/manual/core/document/#document-dot-notation dot notation] can be used, e.g. <~~code~~>parent.child.field</~~code~~>.<br/><br/>		To query nested documents, [http://docs.mongodb.org/manual/core/document/#document-dot-notation dot notation] can be used, e.g. <syntaxhighlight lang="JavaScript" inline>parent.child.field</syntaxhighlight>.<br/><br/>
	The second parameter selects what fields to include. If the second parameter is not present the default action is to include all the fields in the result documents.<br/>		The second parameter selects what fields to include.<br/>
	To hide a field, <~~code~~><field>: 0</~~code~~> is used. The other fields won't be removed.<br/>		If the second parameter is not present the default action is to include all the fields in the result documents.<br/><br/>
	Using <~~code~~><field>: 1</~~code~~> will include that field and hide all the others except the ~~<code>~~_id~~</code>~~ and other fields set to '''1'''.<br/>		To hide a field, <syntaxhighlight lang="JavaScript" inline><field>: 0</syntaxhighlight> is used. The other fields won't be removed.<br/>
	Passing an empty (<~~code~~>{}</~~code~~>) second parameter hides all fields except the ~~<code>~~_id~~</code>~~ field, to hide ~~<code>~~_id~~</code>~~ it has to be explicitly set to '''0'''.<br/><br/>		Using <syntaxhighlight lang="JavaScript" inline><field>: 1</syntaxhighlight> will include that field and hide all the others except the '''_id''' and other fields set to '''1'''.<br/>
	<~~code~~>.findOne()</~~code~~> limits the result to one document and also applies the <~~code~~>.pretty()</~~code~~> operation.		Passing an empty (<syntaxhighlight lang="JavaScript" inline>{}</syntaxhighlight>) second parameter hides all fields except the '''_id''' field, to hide '''_id''' it has to be explicitly set to '''0'''.<br/><br/>
			<syntaxhighlight lang="JavaScript" inline>.findOne()</syntaxhighlight> limits the result to one document and also applies the <syntaxhighlight lang="JavaScript" inline>.pretty()</syntaxhighlight> operation.

	<div class="q nonum" data-lang="mongo">		<div class="q nonum" data-lang="mongo">

40166222 at 19:47, 21 June 2018

2018-06-21T19:47:57Z

← Older revision		Revision as of 19:47, 21 June 2018
Line 13:		Line 13:
	<div class="q nonum" data-lang="mongo">		<div class="q nonum" data-lang="mongo">
	<p class="strong">Show the name and capital for every country of "South America"</p>		<p class="strong">Show the name and capital for every country of "South America"</p>
	<pre class=def>		<pre class="def"><nowiki>
	db.world.find(		db.world.find(
	{continent:"South America"},		{continent: "South America"},
	{"_id":0, name:1, capital:1}		{"_id": 0, name: 1, capital: 1}
	)</pre>		);</nowiki></pre>
	</div>		</div>

40166222 at 23:05, 8 April 2018

2018-04-08T23:05:37Z

← Older revision		Revision as of 23:05, 8 April 2018
Line 10:		Line 10:
	Passing an empty (<code>{}</code>) second parameter hides all fields except the <code>_id</code> field, to hide <code>_id</code> it has to be explicitly set to '''0'''.<br/><br/>		Passing an empty (<code>{}</code>) second parameter hides all fields except the <code>_id</code> field, to hide <code>_id</code> it has to be explicitly set to '''0'''.<br/><br/>
	<code>.findOne()</code> limits the result to one document and also applies the <code>.pretty()</code> operation.		<code>.findOne()</code> limits the result to one document and also applies the <code>.pretty()</code> operation.
	~~</div>~~

	<div class="q nonum" data-lang="mongo">		<div class="q nonum" data-lang="mongo">

40166222 at 19:40, 7 April 2018

2018-04-07T19:40:49Z

← Older revision		Revision as of 19:40, 7 April 2018
Line 1:		Line 1:
	{{TopTenTips}}		{{TopTenTips}}
	~~<div style="min-height:25em">~~
	<code>find()</code> is used to filter and project.<br/>		<code>find()</code> is used to filter and project.<br/>
	By default <code>find()</code> returns a cursor containing all the documents in the collection it is used on. This is the same as <code>find({})</code>.<br /><br/>		By default <code>find()</code> returns a cursor containing all the documents in the collection it is used on. This is the same as <code>find({})</code>.<br /><br/>

40166222: Missing periods.

2018-03-21T17:00:01Z

Missing periods.

← Older revision		Revision as of 17:00, 21 March 2018
Line 1:		Line 1:
	{{TopTenTips}}		{{TopTenTips}}
	<div style="min-height:25em">		<div style="min-height:25em">
	<code>find()</code> is used to filter and project<br/>		<code>find()</code> is used to filter and project.<br/>
	By default <code>find()</code> returns a cursor containing all the documents in the collection it is used on. This is the same as <code>find({})</code><br /><br/>		By default <code>find()</code> returns a cursor containing all the documents in the collection it is used on. This is the same as <code>find({})</code>.<br /><br/>
	To get all the documents with a certain value, <code>find(<field>:{"$eq": <value>}})</code> can be used, this can be simplified to <code>find(<field>: <value>})</code><br/>		To get all the documents with a certain value, <code>find(<field>:{"$eq": <value>}})</code> can be used, this can be simplified to <code>find(<field>: <value>})</code>.<br/>
	<code>$eq</code> can be replaced with other conditional operators such as <code>$lt</code>, <code>$gt</code> to perform less than or greater than comparisons.<br/><br/>		<code>$eq</code> can be replaced with other conditional operators such as <code>$lt</code>, <code>$gt</code> to perform less than or greater than comparisons.<br/><br/>
	To query nested documents, [http://docs.mongodb.org/manual/core/document/#document-dot-notation dot notation] can be used, e.g. <code>parent.child.field</code><br/><br/>		To query nested documents, [http://docs.mongodb.org/manual/core/document/#document-dot-notation dot notation] can be used, e.g. <code>parent.child.field</code>.<br/><br/>
	The second parameter selects what fields to include. If the second parameter is not present the default action is to include all the fields in the result documents.<br/>		The second parameter selects what fields to include. If the second parameter is not present the default action is to include all the fields in the result documents.<br/>
	To hide a field, <code><field>: 0</code> is used. The other fields won't be removed.<br/>		To hide a field, <code><field>: 0</code> is used. The other fields won't be removed.<br/>

40166222: Markup corrections, presentation improvements, replaced old python library method with mongo shell (find_one -> findOne).

2018-03-21T16:58:14Z

Markup corrections, presentation improvements, replaced old python library method with mongo shell (find_one -> findOne).

← Older revision		Revision as of 16:58, 21 March 2018
Line 3:		Line 3:
	<code>find()</code> is used to filter and project<br/>		<code>find()</code> is used to filter and project<br/>
	By default <code>find()</code> returns a cursor containing all the documents in the collection it is used on. This is the same as <code>find({})</code><br /><br/>		By default <code>find()</code> returns a cursor containing all the documents in the collection it is used on. This is the same as <code>find({})</code><br /><br/>
	To get all the documents with a certain value, <code>find(<field>:{"$eq":<value>}})</code> can be used, this can be simplified to <code>find(<field>:<value>})</code><br/>		To get all the documents with a certain value, <code>find(<field>:{"$eq": <value>}})</code> can be used, this can be simplified to <code>find(<field>: <value>})</code><br/>
	<code>$eq</code> can be replaced with other conditional operators such as <code>$lt</code>, <code>$gt</code> to perform less than or greater than comparisons.<br/><br/>		<code>$eq</code> can be replaced with other conditional operators such as <code>$lt</code>, <code>$gt</code> to perform less than or greater than comparisons.<br/><br/>
	To query nested documents, [http://docs.mongodb.org/manual/core/document/#document-dot-notation dot notation] can be used, e.g. <code>parent.child.field</code><br/><br/>		To query nested documents, [http://docs.mongodb.org/manual/core/document/#document-dot-notation dot notation] can be used, e.g. <code>parent.child.field</code><br/><br/>

	The second parameter selects what fields to include. If the second parameter is not present the default action is to include all the fields in the result documents.<br/>		The second parameter selects what fields to include. If the second parameter is not present the default action is to include all the fields in the result documents.<br/>
	To hide a field, <code><field>:0</code> is used. The other fields won't be removed.<br/>		To hide a field, <code><field>: 0</code> is used. The other fields won't be removed.<br/>
	Using <code><field>:1</code> will include that field and hide all the others except the <code>_id</code> and other fields set to 1.<br/>		Using <code><field>: 1</code> will include that field and hide all the others except the <code>_id</code> and other fields set to '''1'''.<br/>
	Passing an empty (<code>{}</code>) second parameter hides all fields except the <code>_id</code> field, to hide <code>_id</code> it has to be explicitly set to 0.<br/><br/>		Passing an empty (<code>{}</code>) second parameter hides all fields except the <code>_id</code> field, to hide <code>_id</code> it has to be explicitly set to '''0'''.<br/><br/>
	<code>~~find_one~~()</code> limits the result to one document.		<code>.findOne()</code> limits the result to one document and also applies the <code>.pretty()</code> operation.
	</div>		</div>

	<div class="q nonum" data-lang="mongo">		<div class="q nonum" data-lang="mongo">
	<p class="strong>Show the name and capital for every country of "South America"</p>		<p class="strong">Show the name and capital for every country of "South America"</p>
	<pre class=def>		<pre class=def>
	db.world.find({continent:"South America"},{"_id":0,name:1,capital:1})		db.world.find(
	</pre>		{continent:"South America"},
			{"_id":0, name:1, capital:1}
			)</pre>
	</div>		</div>

Andr3w at 15:25, 3 December 2015

2015-12-03T15:25:11Z

← Older revision		Revision as of 15:25, 3 December 2015
Line 1:		Line 1:
	{{TopTenTips}}		{{TopTenTips}}
	<div style="min-height:25em">		<div style="min-height:25em">
	<code>find()</code> is used to ~~query documents. It takes a <code>query</code> parameter~~ and ~~an optional <code>projecetion</code> parameter, and returns a [http://docs.mongodb.org/manual/reference/glossary/#term-cursor cursor].~~<br/>		<code>find()</code> is used to filter and project<br/>
	By default <code>find()</code> returns a cursor containing all the documents in the collection it is used on. This is the same as <code>find({})</code><br /><br/>		By default <code>find()</code> returns a cursor containing all the documents in the collection it is used on. This is the same as <code>find({})</code><br /><br/>
	To get all the documents with a certain value, <code>find(<field>:{"$eq":<value>}})</code> can be used, this can be simplified to <code>find(<field>:<value>})</code><br/>		To get all the documents with a certain value, <code>find(<field>:{"$eq":<value>}})</code> can be used, this can be simplified to <code>find(<field>:<value>})</code><br/>
Line 14:		Line 14:
	</div>		</div>
	<div class="q nonum" data-lang="mongo">		<div class="q nonum" data-lang="mongo">
	<p class="strong>Show the capital ~~city and population~~ of ~~France~~</p>		<p class="strong>Show the name and capital for every country of "South America"</p>
	<pre class=def>		<pre class=def>
	db.world.~~findOne~~({~~"name"~~:"~~France~~"},{"_id":0,~~"population"~~:1,"capital":1})		db.world.find({continent:"South America"},{"_id":0,name:1,capital:1})
	</pre>		</pre>
	</div>		</div>

Andr3w at 15:21, 3 December 2015

2015-12-03T15:21:36Z

← Older revision		Revision as of 15:21, 3 December 2015
Line 1:		Line 1:
	~~<pre class=setup>~~
	~~#ENCODING~~
	~~import io~~
	~~import sys~~
	~~sys.stdout = io.TextIOWrapper(sys.stdout.buffer, encoding='utf-16')~~
	~~#MONGO~~
	~~from pymongo import MongoClient~~
	~~client = MongoClient()~~
	~~client.progzoo.authenticate('scott','tiger')~~
	~~db = client['progzoo']~~
	~~#PRETTY~~
	~~import pprint~~
	~~pp = pprint.PrettyPrinter(indent=4)~~
	~~#CODE~~
	~~from bson.code import Code~~
	~~</pre>~~
	{{TopTenTips}}		{{TopTenTips}}
	<div style="min-height:25em">		<div style="min-height:25em">
Line 29:		Line 13:
	<code>find_one()</code> limits the result to one document.		<code>find_one()</code> limits the result to one document.
	</div>		</div>
	<div class="q nonum" data-lang="~~py3~~">		<div class="q nonum" data-lang="mongo">
	<p class="strong>Show the capital city and population of France</p>		<p class="strong>Show the capital city and population of France</p>
	<pre class=def>		<pre class=def>
	~~print(~~db.world.~~find_one~~({"name":"France"},{"_id":0,"population":1,"capital":1}))		db.world.findOne({"name":"France"},{"_id":0,"population":1,"capital":1})
	</pre>		</pre>
	</div>		</div>

40166222 at 13:27, 28 July 2015

2015-07-28T13:27:03Z

← Older revision		Revision as of 13:27, 28 July 2015
Line 29:		Line 29:
	<code>find_one()</code> limits the result to one document.		<code>find_one()</code> limits the result to one document.
	</div>		</div>
	<div class=q data-lang="py3">		<div class="q nonum" data-lang="py3">
	<p class="strong>Show the capital city and population of France</p>		<p class="strong>Show the capital city and population of France</p>
	<pre class=def>		<pre class=def>

40166222 at 11:54, 28 July 2015

2015-07-28T11:54:05Z

← Older revision		Revision as of 11:54, 28 July 2015
Line 16:		Line 16:
	</pre>		</pre>
	{{TopTenTips}}		{{TopTenTips}}
			<div style="min-height:25em">
	<code>find()</code> is used to query documents. It takes a <code>query</code> parameter and an optional <code>projecetion</code> parameter, and returns a [http://docs.mongodb.org/manual/reference/glossary/#term-cursor cursor].<br/>		<code>find()</code> is used to query documents. It takes a <code>query</code> parameter and an optional <code>projecetion</code> parameter, and returns a [http://docs.mongodb.org/manual/reference/glossary/#term-cursor cursor].<br/>
	By default <code>find()</code> returns a cursor containing all the documents in the collection it is used on. This is the same as <code>find({})</code><br /><br/>		By default <code>find()</code> returns a cursor containing all the documents in the collection it is used on. This is the same as <code>find({})</code><br /><br/>
Line 27:		Line 28:
	Passing an empty (<code>{}</code>) second parameter hides all fields except the <code>_id</code> field, to hide <code>_id</code> it has to be explicitly set to 0.<br/><br/>		Passing an empty (<code>{}</code>) second parameter hides all fields except the <code>_id</code> field, to hide <code>_id</code> it has to be explicitly set to 0.<br/><br/>
	<code>find_one()</code> limits the result to one document.		<code>find_one()</code> limits the result to one document.
			</div>
	<div class=q data-lang="py3">		<div class=q data-lang="py3">
	<p class="strong>Show the capital city and population of France</p>		<p class="strong>Show the capital city and population of France</p>