Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: pass (nike.apache.org: domain of kevin.r.coombes@gmail.com
 designates 209.85.214.182 as permitted sender)
Message-ID: <52FC2D73.10205@gmail.com>
Date: Wed, 12 Feb 2014 21:26:59 -0500
From: Kevin Coombes <kevin.r.coombes@gmail.com>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64;
 rv:24.0) Gecko/20100101 Thunderbird/24.3.0
MIME-Version: 1.0
To: user@couchdb.apache.org
Subject: Re: Matching docs which values ending with a specific string
References: <131147B1-EAB4-4FFB-A6BF-950877CAC74B@mac.com>
 <E59592D5-4F43-4069-9CEB-9BBE991B9C41@bearriver.com>
 <86A8E193-C6CF-41F3-9570-1A87A2AE4A9D@mac.com>
In-Reply-To: <86A8E193-C6CF-41F3-9570-1A87A2AE4A9D@mac.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Maybe you should completely describe the structure you want.

{
   "_id": "12345",
   "location": {
        "state": "California",
         "city": "Florence"
   }
}

Because (1) you can define multiple views that emit any reasonable 
combination of city and state in any order you might want to query and 
(2) some day you might want to add an entry like

{
   "_id": "98765",
   "location": {
        "country": "Italy",
        "province": "Tuscany",
         "city": "Florence"
   }
}

On 2/12/2014 6:10 PM, Tito Ciuro wrote:
> Hello,
>
> Ah! I see. Well, what if I stored the path in an array instead?:
>
> {
>    "_id" : "12345",
>    "location" : [<some_city>,<some town>]
> }
>
> If I emit (doc.location,doc._id), would I be able to write a query that matches the second element of the doc.location array?
>
> Thanks again for all the help,
>
> -- Tito
>
> On Feb 12, 2014, at 2:48 PM, Jason Winshell <jasonw@bearriver.com> wrote:
>
>> AFAIK, you're describing a CouchDB limitation. You may need to use CouchDB-Lucene to get your answers. CouchDB views match keys in an index. You can match a prefix, but not a tail. And you can't deal with case sensitivity. You might be able to generate a view in which you reverse the chars of your location and then match in reverse order (i.e. turning the problem into a prefix). I think trying to coerce Couch to do that is nutty. Just use CouchDB-Lucene.
>>
>> On Feb 12, 2014, at 2:35 PM, Tito Ciuro <tciuro@mac.com> wrote:
>>
>>> Hello,
>>>
>>> I have a database with documents with the following format:
>>>
>>> {
>>>    "_id" : "12345",
>>>    "location" : <some_city>.<some town>
>>> }
>>>
>>> I have values like:
>>>
>>> California.San Francisco
>>> California.Los Angeles
>>> Florida.Miami
>>> ...
>>> ...
>>>
>>> What I'm trying to do is to match documents that "end with" a particular string. Say I want to match all states where the town 'Anytown' exists:
>>>
>>> California.Anytown
>>> Florida.Anytown
>>> Texas.Anytown
>>>
>>> If I use the following query:
>>>
>>> curl http://127.0.0.1:5984/example/_design/test/_view/ends-with-city?key=%22California.Anytown%22
>>>
>>> It works and returns one document (as expected), but I cannot seem to make it work when I look for an "end with" string. I have seen examples where %007F is used to match "begins with". When I use it, I get a {"error":"bad_request","reason":"invalid_json"} message. So I'm not sure how to proceed.
>>>
>>> Any ideas? Thanks!
>>>
>>> -- Tito