Projection

2 minutes
Share the link to this page
Copied
  Completed
You need to have access to the item to view this lesson.
One-time Fee
$49.99
List Price:  $69.99
You save:  $20
€42.66
List Price:  €59.73
You save:  €17.06
£37
List Price:  £51.80
You save:  £14.80
CA$69.17
List Price:  CA$96.84
You save:  CA$27.67
A$76.25
List Price:  A$106.75
You save:  A$30.50
S$64.24
List Price:  S$89.95
You save:  S$25.70
HK$389.72
List Price:  HK$545.64
You save:  HK$155.92
CHF 39.89
List Price:  CHF 55.85
You save:  CHF 15.96
NOK kr502.23
List Price:  NOK kr703.17
You save:  NOK kr200.93
DKK kr318.49
List Price:  DKK kr445.91
You save:  DKK kr127.42
NZ$84.80
List Price:  NZ$118.73
You save:  NZ$33.92
د.إ183.58
List Price:  د.إ257.03
You save:  د.إ73.45
৳6,067.88
List Price:  ৳8,495.52
You save:  ৳2,427.63
₹4,408.44
List Price:  ₹6,172.17
You save:  ₹1,763.73
RM211.18
List Price:  RM295.67
You save:  RM84.49
₦76,484.70
List Price:  ₦107,084.70
You save:  ₦30,600
₨14,148.05
List Price:  ₨19,808.40
You save:  ₨5,660.35
฿1,602.23
List Price:  ฿2,243.26
You save:  ฿641.02
₺2,059.71
List Price:  ₺2,883.76
You save:  ₺824.05
B$270.64
List Price:  B$378.92
You save:  B$108.28
R879.25
List Price:  R1,231.03
You save:  R351.77
Лв83.50
List Price:  Лв116.90
You save:  Лв33.40
₩69,311.13
List Price:  ₩97,041.13
You save:  ₩27,730
₪167.27
List Price:  ₪234.19
You save:  ₪66.92
₱2,834.43
List Price:  ₱3,968.43
You save:  ₱1,134
¥7,368.77
List Price:  ¥10,316.87
You save:  ¥2,948.10
MX$935.57
List Price:  MX$1,309.87
You save:  MX$374.30
QR182.23
List Price:  QR255.14
You save:  QR72.90
P670.32
List Price:  P938.51
You save:  P268.18
KSh6,451.68
List Price:  KSh9,032.87
You save:  KSh2,581.18
E£2,428.51
List Price:  E£3,400.11
You save:  E£971.60
ብር7,132.08
List Price:  ብር9,985.48
You save:  ብር2,853.40
Kz45,840.83
List Price:  Kz64,180.83
You save:  Kz18,340
CLP$48,227.35
List Price:  CLP$67,522.15
You save:  CLP$19,294.80
CN¥356.57
List Price:  CN¥499.22
You save:  CN¥142.65
RD$3,153.13
List Price:  RD$4,414.63
You save:  RD$1,261.50
DA6,491.85
List Price:  DA9,089.11
You save:  DA2,597.26
FJ$112.61
List Price:  FJ$157.67
You save:  FJ$45.05
Q382.39
List Price:  Q535.38
You save:  Q152.98
GY$10,431.26
List Price:  GY$14,604.61
You save:  GY$4,173.34
ISK kr6,106.27
List Price:  ISK kr8,549.27
You save:  ISK kr2,443
DH453.12
List Price:  DH634.40
You save:  DH181.28
L836.85
List Price:  L1,171.66
You save:  L334.80
ден2,624.34
List Price:  ден3,674.28
You save:  ден1,049.94
MOP$400.70
List Price:  MOP$561.02
You save:  MOP$160.31
N$881.39
List Price:  N$1,234.02
You save:  N$352.62
C$1,834.99
List Price:  C$2,569.13
You save:  C$734.14
रु7,041.11
List Price:  रु9,858.12
You save:  रु2,817
S/175.62
List Price:  S/245.88
You save:  S/70.26
K208.10
List Price:  K291.36
You save:  K83.25
SAR187.47
List Price:  SAR262.47
You save:  SAR75
ZK1,190.37
List Price:  ZK1,666.62
You save:  ZK476.24
L216.56
List Price:  L303.21
You save:  L86.64
Kč1,040.26
List Price:  Kč1,456.45
You save:  Kč416.19
Ft16,743.47
List Price:  Ft23,442.21
You save:  Ft6,698.73
SEK kr469.67
List Price:  SEK kr657.57
You save:  SEK kr187.90
ARS$67,931.98
List Price:  ARS$95,110.21
You save:  ARS$27,178.22
Bs344.52
List Price:  Bs482.36
You save:  Bs137.83
COP$198,834.18
List Price:  COP$278,383.76
You save:  COP$79,549.58
₡25,262.59
List Price:  ₡35,369.65
You save:  ₡10,107.06
L1,306.28
List Price:  L1,828.90
You save:  L522.61
₲360,499.61
List Price:  ₲504,728.30
You save:  ₲144,228.69
$U2,007.13
List Price:  $U2,810.15
You save:  $U803.01
zł181.30
List Price:  zł253.83
You save:  zł72.53
Already have an account? Log In

Transcript

Calling the find function on a particular collection retrieves all the documents, and all the documents include all the properties. Now sometimes you may want to restrict the number of documents based on certain criteria or restrict the properties that you want to view. This is called selection and projection. The first parameter is an object representing the criteria that you want to use for selection. Now we'll come back on that in few minutes, but first we will see how to do a projection. The second parameter here is the projection.

For example, if you want to retrieve only the first name, last name and city of the people in your contact list, then you can simply say here, first name is one, last name is one, and then city is one. To insert one we can also use any nonzero number so zero represents false nonzero represents true. In fact, you can also type the JavaScript keyword true to say that include this particular property when I save this, and then execute the same thing. If I execute Mongo, and then pass on the E zero T dot j s, you will see, only certain properties are being retrieved, and especially First Name, Last Name city. Now by default, the underscore ID is always included. If you don't want that, you can come back to your command and then say underscore ID is false, or zero.

So save it and run the same command again, and you can see that we get only first name, last name and city, if it exists. If the document does not contain a specific property, that property will not be included. And if it doesn't contain any matching property, just an empty object is being written one very Important point that you have to remember is you cannot have a combination of inclusion and exclusion, except for the underscore ID. Apart from the ID if you use inclusion for the properties like one or nonzero or true, you may not be able to specify fonts for other fields. For example, if I try this, we get an error saying that projection cannot have a mix of inclusion and exclusion. So either exclude all the fields that are mentioned here and refer to the remaining ones or include only these fields and do not get any other fees from the documents.

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.