James,
For the first type of query you can use startKey and endKey modifiers when
querying your view.
For the second, you can enable reduce, and adjust your reduce function to
only output one document ID.
Hope this helps!
-Shimon
On Tuesday, March 11, 2014 10:27:45 PM UTC-4, James McGill wrote:
>
> Here is a common use case that I haven't managed to find a solution for:
>
> Consider this document type:
>
> { "fromDate" : "2014-03-10T00:00:00.000Z", "thruDate" :
> "2014-03-11T00:00:00.000Z" }
>
> There are two main types of queries I want for this data.
>
> 1. Given a "current" time stamp, retrieve all documents where "fromDate"
> is less than or equal to "current", and where "thruDate" is either null or
> is not less than "current".
> Essentially, documents are valid for this view where our "current"
> timestamp falls within the range implied by [fromDate, thruDate).
> 2. Similar to query #1, but "distinct", meaning that no more than one
> record may be "valid" for any given "current" timestamp.
>
> Attempts to implement this design in Couchbase have been elusive. I've
> tried different approaches, such as numeric date formats and using the
> dateToArray function in various ways, but the underlying issue is that
> there isn't a good way to construct an "OR" query based on document fields.
> Finding documents based on either the "from" or "thru" timestamps is easy,
> but bounding documents where the query is "between" the from and thru
> timestamps is not.
>
> It appears that in order to accomplish this use case, the application must
> be willing to retrieve large sets of keys and then evaluate them by value,
> sorting the view by value and then evaluating the dates, eliminating rows.
> That is a poor solution when the result size becomes large.
>
> I would be encouraged by any suggestions. I'm using Couchbase Server 2.2
> and the Java Client API, and am reasonably comfortable with Design Document
> / View construction.
>
> Kind regards,
>
> James
>
>
>
--
You received this message because you are subscribed to the Google Groups
"Couchbase" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
