$type
selects the documents where the value of the field is the specified numeric
BSON type. Every BSON type has a number associated with it.
Type
|
Number
|
Double
|
1
|
String
|
2
|
Object
|
3
|
Array
|
4
|
Binary
data
|
5
|
Undefined
|
6
|
Object
id
|
7
|
Boolean
|
8
|
Date
|
9
|
Null
|
10
|
Regular
Expression
|
11
|
JavaScript
|
13
|
Symbol
|
14
|
JavaScript(With
scope)
|
15
|
32-bit
integer
|
16
|
Timestamp
|
17
|
64-bit
integer
|
18
|
Min
key
|
255
|
Max
key
|
127
|
Syntax
{
field: { $type: <BSON type> } }
> db.employee.find() { "_id" : 1, "firstName" : "Joel", "lastName" : "chelli", "salary" : 25000, "hobbies" : [ "watching movies", "playing games" ] } { "_id" : 2, "firstName" : "Ananad", "lastName" : "Bandaru", "salary" : 200000, "hobbies" : [ "car drivinig", "watching movies" ] } { "_id" : 3, "firstName" : "Gopi", "lastName" : "Battu", "salary" : 65000, "hobbies" : [ "climbing hills", "dancing", "singing" ] } { "_id" : 4, "firstName" : "Ritwik", "lastName" : "Mohenthy", "salary" : 50000, "hobbies" : [ "watching movies", "watching movies", "watching movies" ] } { "_id" : 5, "firstName" : "RamaKrishna", "lastName" : "Gurram", "salary" : 150000, "hobbies" : [ "hackning sites", "Reading books", "listening music" ] } { "_id" : 6, "firstName" : "BalaKrishna", "lastName" : "Gurram", "salary" : 80000, "hobbies" : [ "roaming around", "eating food" ] } { "_id" : ObjectId("54ba2de1f1c8f2149c000740"), "name" : "Krishna", "project" : "A350" } { "_id" : ObjectId("54ba2dfcf1c8f2149c000741"), "name" : "Krishna", "project" : 4 }
1.Get all documents
where field “project” is of type string.
> db.employee.find({"project": {$type: 2}}) { "_id" : ObjectId("54ba2de1f1c8f2149c000740"), "name" : "Krishna", "project" : "A350" }
2.Get all documents
where field “project” is of type Double.
> db.employee.find({"project": {$type: 1}}) { "_id" : ObjectId("54ba2dfcf1c8f2149c000741"), "name" : "Krishna", "project" : 4 }
No comments:
Post a Comment