search

nlight-jdev / jcouchdb

Automatically exported from code.google.com/p/jcouchdb
Other
0 stars 0 forks source link

Date Range Search In Field Value #79

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
Hello,

This is the first day am trying to use Couchbase as single server.

Can anyone help me understanding if i can query documents if one the field 
value is date timestamp.

ex:
fieldName: "updatedTime"
fieldValue: "Mon Sep 05 16:36:47 GMT+05:30 2011"

I need to fetch documents which fall in the field value ranges between two 
dates. This is necessary for my requirement.

Can anyone help me with an example query?

Thanks,
Mady

Original issue reported on code.google.com by madan...@gmail.com on 5 Sep 2011 at 1:38

GoogleCodeExporter commented 8 years ago 
That's not really related to the jcouchdb library.  If you really meant 
CouchBase, you should try contacting their IRC channel.  If you meant CouchDB, 
you will need to create a design document on your server that includes the view 
you've described.  You should very carefully choose the storage format of your 
date ... notice how your view would sort on the DOW in it's current format.

Original comment by smoye...@gmail.com on 29 Feb 2012 at 11:06