Friday 20 February 2015

mongoDB : $type : Gets the documents where field is of specific type


$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 }

Prevoius                                                 Next                                                 Home

No comments:

Post a Comment