Return-Path: X-Original-To: apmail-couchdb-user-archive@www.apache.org Delivered-To: apmail-couchdb-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id CE2FF11C50 for ; Mon, 9 Jun 2014 16:37:13 +0000 (UTC) Received: (qmail 80697 invoked by uid 500); 9 Jun 2014 16:37:12 -0000 Delivered-To: apmail-couchdb-user-archive@couchdb.apache.org Received: (qmail 80309 invoked by uid 500); 9 Jun 2014 16:37:12 -0000 Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@couchdb.apache.org Delivered-To: mailing list user@couchdb.apache.org Received: (qmail 80298 invoked by uid 99); 9 Jun 2014 16:37:12 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 09 Jun 2014 16:37:12 +0000 X-ASF-Spam-Status: No, hits=-0.1 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_MED,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of radhika.ramanadham@emc.com designates 128.221.224.79 as permitted sender) Received: from [128.221.224.79] (HELO mailuogwdur.emc.com) (128.221.224.79) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 09 Jun 2014 16:37:08 +0000 Received: from maildlpprd51.lss.emc.com (maildlpprd51.lss.emc.com [10.106.48.155]) by mailuogwprd53.lss.emc.com (Sentrion-MTA-4.3.0/Sentrion-MTA-4.3.0) with ESMTP id s59Gakfr016955 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO) for ; Mon, 9 Jun 2014 12:36:46 -0400 X-DKIM: OpenDKIM Filter v2.4.3 mailuogwprd53.lss.emc.com s59Gakfr016955 DKIM-Signature: v=1; a=rsa-sha1; c=relaxed/relaxed; d=emc.com; s=jan2013; t=1402331806; bh=jArD+zYpsb0wL4dJoUbIiWKzFRE=; h=From:To:Date:Subject:Message-ID:Content-Type:MIME-Version; b=p0IP3EYiNNViNa7n3crhVsxV4lGiwujivpbGDL+7pR+LAhK8ohDb26chy8zF1CyOg /kS/CU82isB/CYsAwCC1ia7HCv1sRNKKnGJfZPstWSeUYpvYqOpN6us52K7tFxlPQG uC1Px2JD1aZ8TDsr0KivSFX+13HzvtSwH5Ws+/L8= X-DKIM: OpenDKIM Filter v2.4.3 mailuogwprd53.lss.emc.com s59Gakfr016955 Received: from mailusrhubprd03.lss.emc.com (mailusrhubprd03.lss.emc.com [10.253.24.21]) by maildlpprd51.lss.emc.com (RSA Interceptor) for ; Mon, 9 Jun 2014 12:36:34 -0400 Received: from mxhub02.corp.emc.com (mxhub02.corp.emc.com [10.254.141.104]) by mailusrhubprd03.lss.emc.com (Sentrion-MTA-4.3.0/Sentrion-MTA-4.3.0) with ESMTP id s59GaYiS032466 (version=TLSv1/SSLv3 cipher=AES128-SHA bits=128 verify=FAIL) for ; Mon, 9 Jun 2014 12:36:34 -0400 Received: from mx45a.corp.emc.com ([169.254.1.52]) by mxhub02.corp.emc.com ([10.254.141.104]) with mapi; Mon, 9 Jun 2014 12:36:34 -0400 From: "Ramanadham, Radhika" To: "user@couchdb.apache.org" Date: Mon, 9 Jun 2014 12:36:33 -0400 Subject: Question on views Thread-Topic: Question on views Thread-Index: Ac+D/SyE9TMSYoARRY2OoAzpiA94qA== Message-ID: <14256C9E890B874D989F0828DDB264F2C51F2C86@MX45A.corp.emc.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: acceptlanguage: en-US Content-Type: multipart/alternative; boundary="_000_14256C9E890B874D989F0828DDB264F2C51F2C86MX45Acorpemccom_" MIME-Version: 1.0 X-Sentrion-Hostname: mailusrhubprd03.lss.emc.com X-RSA-Classifications: public X-Virus-Checked: Checked by ClamAV on apache.org --_000_14256C9E890B874D989F0828DDB264F2C51F2C86MX45Acorpemccom_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi, I have a view which has 2 keys- key1 and key2: "by_server": { "map": "function(doc) { if ((doc.type =3D=3D 'performance_s= tats')) emit([key1, key2],{ 'Start_time':doc.start_time ,'CPU': doc.CPU, '= Memory': doc.Memory, 'FileSystem':doc.FileSystem }) }" }, If I want to query the view where I need all the rows for key2 and key1 bei= ng anything, how do I do it? Let's say my data is-> {"id":"server_lglod025.lss.emc.com_2014-06-09_10:24:18","key":["lglod025.ls= s.emc.com","SRMSuite_3.0.2_test1"],"value":{"Start_time":"2014-06-09 09:00:= 00","CPU":12,"Memory":98,"FileSystem":96}}, {"id":"server_lglod093.lss.emc.com_2014-06-09_11:24:18","key":["lglod093.ls= s.emc.com","SRMSuite_3.0.2_test2"],"value":{"Start_time":"2014-06-09 10:00:= 00","CPU":12,"Memory":98,"FileSystem":97}}, {"id":"server_lglod174.lss.emc.com_2014-06-04_14:01:44","key":["lglod174.ls= s.emc.com","SRMSuite_3.0.2_test2"],"value":{"Start_time":"2014-06-04 10:00:= 00","CPU":67,"Memory":97,"FileSystem":17}}, I only want the below 2 rows who have a key2 =3D SRMSuite_3.0.2_test2, how = do I do it? {"id":"server_lglod093.lss.emc.com_2014-06-09_11:24:18","key":["lglod093.ls= s.emc.com","SRMSuite_3.0.2_test2"],"value":{"Start_time":"2014-06-09 10:00:= 00","CPU":12,"Memory":98,"FileSystem":97}}, {"id":"server_lglod174.lss.emc.com_2014-06-04_14:01:44","key":["lglod174.ls= s.emc.com","SRMSuite_3.0.2_test2"],"value":{"Start_time":"2014-06-04 10:00:= 00","CPU":67,"Memory":97,"FileSystem":17}}, Thanks, Radhika --_000_14256C9E890B874D989F0828DDB264F2C51F2C86MX45Acorpemccom_--