incubator-couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Robert Newson <rnew...@apache.org>
Subject Re: Unable to access all the documnets by 'documentType' property
Date Sat, 24 Dec 2011 12:43:29 GMT
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/dab7fbc0cd3651ad631f4bf58fffc74f 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/2bf6dff4a2977f01b6fff21a6c868aad 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/e5ac861d5e4466b8b2407417b6ff8f7e 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": "ff2fb2554682ba613c2f83c63502808a",
>>  "_rev": "4-dd559696434a402739e789ccc8c9a481",
>>  "answers": [
>>      {
>>          "answers": [
>>              "Aug 19,2011"
>>          ],
>>          "questionId": "50f3df434ae02ac7fff48c1c2bde83e4"
>>      },
>>      {
>>          "answers": [
>>              "Bechu Yadav"
>>          ],
>>          "questionId": "15504f006e58872fd94871fe0c9d32ad"
>>      },
>>      {
>>          "answers": [
>>              "35"
>>          ],
>>          "questionId": "3c447a2f5cc6ca1985ce2c81463a3c47"
>>      },
>>      {
>>          "answers": [
>>              "Male"
>>          ],
>>          "questionId": "a6df7c25602939554612ef6de762f5b9"
>>      },
>>      {
>>          "questionId": "2f66155965e60094f23f01af531d5af1",
>>          "subAnswers": [
>>              {
>>                  "questionId": "1dae2d86eef846c967254c9e369170ce"
>>              },
>>              {
>>                  "questionId": "40ffeb4d33dab1fe8d2d8b73c02ed13b"
>>              },
>>              {
>>                  "questionId": "2db1e8b6e97d5baa8935b9b31fcc9648"
>>              },
>>              {
>>                  "questionId": "0f8bb9f91ea8085b4ffb839ee8deabb5"
>>              },
>>              {
>>                  "questionId": "22a93ecb72c50ff8899f8b2937776e51"
>>              },
>>              {
>>                  "questionId": "e5106384790c2be745c952c4b867a0ff"
>>              }
>>          ]
>>
>>          "questionId": "492cf9bd41257ea478c5222fbba06616"
>>      }
>>  ],
>>  "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": "6df022f0f371752167ad4920b38e1c37",
>>   "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
>>
>> "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
View raw message