MongoDB Miscellaneous

Querying based on Date & Time\\

1   db.[Colletion].find ({Date:ISODate('2013-04-22T00:00:00Z')})

\\ Equivalent of Oracle's Count function\\

1   db.[Collection].find ({'FieldName':'value').length

\\ Find distinct values of a column, after Querying\\

1   db.[Collection].distinct ('ColumnName', {'SearchColumnName' : 'SearchValue'})

\\ Number of distinct values\\

1   db.[Collection].distinct ('ColumnName').length

\\ Sorting the returned result with pymongo\\

1  db.[Collection].find().sort (
2  [
3   ("FieldName1", pymongo.DESCENDING),
4   ("FieldName2", pymongo.DESCENDING),
5   ("FieldName3", pymongo.ASCENDING),
6  ])

\\ \\