incubator-couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Keith Gable <zi...@ignition-project.com>
Subject Re: Unable to access all the documnets by 'documentType' property
Date Mon, 26 Dec 2011 14:49:54 GMT
Isn't it view_by_whatever? Then again I do use an older CouchRest.
On Dec 26, 2011 2:17 AM, "Shreekumar" <shreekumar@worlditlab.com> wrote:

> after making changes in view as follows, as u suggested
>
> function(doc) {
>  emit(doc.documentType, null);
> }
>
> I tried the command as follows
>
> Android.find_by_documentType(:**key=>'Survey')
> and
> Android.by_documentType(:key=>**'Survey')
>
> Bothe are giving Bad Request 400 error.
>
> Could you please send me an example for my problem?
>
>
> -----Original Message----- From: Robert Newson
> Sent: Saturday, December 24, 2011 6:13 PM
> To: user@couchdb.apache.org
> Subject: Re: Unable to access all the documnets by 'documentType' property
>
> function(doc) {
>  emit(doc.documentType, null);
> }
>
> would let you find *by* documentType, which appears to be what you
> intended.
>
> Query with ?key="Survey" for your example.
>
> B.
>
> On 24 December 2011 11:10, Shreekumar <shreekumar@worlditlab.com> wrote:
>
>> The Couch DB access log looks like this
>>
>> [Sat, 24 Dec 2011 11:02:34 GMT] [info] [<0.23369.58>]  - - 'GET'
>> /ashoka/_design/Android/_view/**by_documentType?reduce=false&**
>> include_docs=true&limit=1
>> 200
>> [Sat, 24 Dec 2011 11:09:09 GMT] [info] [<0.24351.58>] - - 'GET'
>> /ashoka/_local/**dab7fbc0cd3651ad631f4bf58fffc7**4f 200
>> [Sat, 24 Dec 2011 11:09:10 GMT] [info] [<0.24352.58>]  - - 'HEAD' /ashoka/
>> 200
>> [Sat, 24 Dec 2011 11:09:11 GMT] [info] [<0.24354.58>]  - - 'GET' /ashoka/
>> 200
>> [Sat, 24 Dec 2011 11:09:12 GMT] [info] [<0.24356.58>]  - - 'GET'
>> /ashoka/_local/**2bf6dff4a2977f01b6fff21a6c868a**ad 200
>> [Sat, 24 Dec 2011 11:09:12 GMT] [info] [<0.24357.58>]  - - 'HEAD' /ashoka/
>> 200
>> [Sat, 24 Dec 2011 11:09:13 GMT] [info] [<0.24359.58>]  - - 'GET' /ashoka/
>> 200
>> [Sat, 24 Dec 2011 11:09:14 GMT] [info] [<0.24361.58>]  - - 'GET'
>> /ashoka/_local/**e5ac861d5e4466b8b2407417b6ff8f**7e 200
>>
>> -----Original Message----- From: Daniel Bryan
>> Sent: Saturday, December 24, 2011 12:52 PM
>> To: user@couchdb.apache.org ; Shreekumar
>> Subject: Re: Unable to access all the documnets by 'documentType' property
>>
>>
>> With something like this I'd usually start by looking at the CouchDB
>> access
>> log to see what query Couch is receiving - that way you know whether the
>> problem is in Couch (say, in the view that's been stored) or in your Ruby
>> library. I suspect there's some nuance in the query language of the latter
>> that you're missing.
>> On Dec 24, 2011 4:52 PM, "Shreekumar" <shreekumar@worlditlab.com> wrote:
>>
>>  Good day!
>>>
>>> I’ve around 1500 documents which has documentType as a field. And each
>>> document belongs to any one of the types (i.e. “Survey”,”Response” and
>>> “Questions”). I’m using CouchRest model to access the CouchDB documents
>>> with Ruby On Rails platform.
>>>
>>> My documents looks like as follows.
>>> {
>>>  "_id": "**ff2fb2554682ba613c2f83c6350280**8a",
>>>  "_rev": "4-**dd559696434a402739e789ccc8c9a4**81",
>>>  "answers": [
>>>     {
>>>         "answers": [
>>>             "Aug 19,2011"
>>>         ],
>>>         "questionId": "**50f3df434ae02ac7fff48c1c2bde83**e4"
>>>     },
>>>     {
>>>         "answers": [
>>>             "Bechu Yadav"
>>>         ],
>>>         "questionId": "**15504f006e58872fd94871fe0c9d32**ad"
>>>     },
>>>     {
>>>         "answers": [
>>>             "35"
>>>         ],
>>>         "questionId": "**3c447a2f5cc6ca1985ce2c81463a3c**47"
>>>     },
>>>     {
>>>         "answers": [
>>>             "Male"
>>>         ],
>>>         "questionId": "**a6df7c25602939554612ef6de762f5**b9"
>>>     },
>>>     {
>>>         "questionId": "**2f66155965e60094f23f01af531d5a**f1",
>>>         "subAnswers": [
>>>             {
>>>                 "questionId": "**1dae2d86eef846c967254c9e369170**ce"
>>>             },
>>>             {
>>>                 "questionId": "**40ffeb4d33dab1fe8d2d8b73c02ed1**3b"
>>>             },
>>>             {
>>>                 "questionId": "**2db1e8b6e97d5baa8935b9b31fcc96**48"
>>>             },
>>>             {
>>>                 "questionId": "**0f8bb9f91ea8085b4ffb839ee8deab**b5"
>>>             },
>>>             {
>>>                 "questionId": "**22a93ecb72c50ff8899f8b2937776e**51"
>>>             },
>>>             {
>>>                 "questionId": "**e5106384790c2be745c952c4b867a0**ff"
>>>             }
>>>         ]
>>>
>>>         "questionId": "**492cf9bd41257ea478c5222fbba066**16"
>>>     }
>>>  ],
>>>  "createdAt": "2011-08-19T21:05:36.486+0000"**,
>>>  "createdBy": "user4",
>>>  "documentType": "Response",
>>>  "ipAddress": "42.110.85.67",
>>>  "location": {
>>>     "latitude": 26.8415613,
>>>     "longitude": 75.8222883,
>>>     "provider": "network"
>>>  },
>>>  "surveyId": "**6df022f0f371752167ad4920b38e1c**37",
>>>  "published": true
>>> }
>>>
>>> and my CouchRest (Android) class looks like this.
>>>
>>> require 'couchrest_model'
>>> class Android < CouchRest::Model::Base
>>>  property :description, String
>>>  property :_id, String
>>>  property :_rev, String
>>>  property :documentType, String
>>>  design do
>>>  view :by_documentType
>>>  end
>>> end
>>>
>>> and my view looks like this
>>>
>>> function(doc)
>>> {
>>>  if(doc.documentType=='Survey')
>>>  emit(doc._id, null);
>>> }
>>> this is very basic code and working fine, and it’s returning 19 rows.
>>> (all
>>> the documents which have documentType=’Survey’). but when I’m trying to
>>> access this code in RoR by using CouchRest model; It’s returning only
>>> last
>>> Document (19th Document).
>>>
>>> My ruby (irb)command line looks like this
>>>
>>> Android.find_by_documentType('**Survey')Please help me to solve this.
>>>
>>>
>>>
>>> -- Warm Regards
>>> Shreekumar
>>> Sr. Software Engineer
>>> World IT Lab | A division of Animika Studios Pvt. Ltd.
>>> 41, 1st Cross off Kalidasa Road, Jayalaxmipuram
>>> Mysore - 570 012
>>> [M] +91 94498 36388 | [T] +91 821 2411 577
>>> [Web] www.worlditlab.com | www.animikastudios.com
>>> [Email] mailto:shreekumar@worlditlab.**com <shreekumar@worlditlab.com>
>>>
>>> "This e-mail and any attachments to it (the "Communication") is, unless
>>> otherwise stated, confidential, may contain copyright material and is for
>>> the use only of the intended recipient. If you receive the Communication
>>> in
>>> error, please notify the sender immediately by return e-mail, delete the
>>> Communication and the return e-mail, and do not read, copy, retransmit or
>>> otherwise deal with it. Any views expressed in the Communication are
>>> those
>>> of the individual sender only, unless expressly stated to be those of
>>> Animika Studios Pvt. Ltd. Animika Studios does not accept liability in
>>> connection with the integrity of or errors in the Communication, computer
>>> virus, data corruption, interference or delay arising from or in respect
>>> of
>>> the Communication."
>>>
>>>
>>>
>>>
>>
>>
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message