Return-Path: Delivered-To: apmail-lucene-solr-user-archive@minotaur.apache.org Received: (qmail 49902 invoked from network); 23 Jul 2010 18:17:37 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 23 Jul 2010 18:17:37 -0000 Received: (qmail 25905 invoked by uid 500); 23 Jul 2010 18:17:35 -0000 Delivered-To: apmail-lucene-solr-user-archive@lucene.apache.org Received: (qmail 25726 invoked by uid 500); 23 Jul 2010 18:17:34 -0000 Mailing-List: contact solr-user-help@lucene.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: solr-user@lucene.apache.org Delivered-To: mailing list solr-user@lucene.apache.org Received: (qmail 25718 invoked by uid 99); 23 Jul 2010 18:17:34 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 23 Jul 2010 18:17:34 +0000 X-ASF-Spam-Status: No, hits=2.2 required=10.0 tests=FREEMAIL_FROM,HTML_MESSAGE,SPF_PASS,T_TO_NO_BRKTS_FREEMAIL X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of pramod.goyal@gmail.com designates 209.85.215.48 as permitted sender) Received: from [209.85.215.48] (HELO mail-ew0-f48.google.com) (209.85.215.48) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 23 Jul 2010 18:17:26 +0000 Received: by ewy10 with SMTP id 10so291736ewy.35 for ; Fri, 23 Jul 2010 11:17:06 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:received:date:message-id :subject:from:to:content-type; bh=l1+E+l3dCOy0l+7FIVoUVq/f6h2mXQzGFxltkT+5hh4=; b=rEMMUTAV/mb6/0I/VGlSaab5vR/tu0pj9Z6dap8FnEGApb4sJgUonyu39pv645K17y /eas64+ACOMQcgMHMxKs1SidQHB/rcgc+Eifmp+SV91nnTYrNW7+tvvHAT62dX9Lh3o3 cx3FNqw/3vIesZBxvRGV/dKM4K279793IRQmo= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type; b=mF11aSO3r9/CUo+InYyTt8LtZ5QyWZzTqopyRVRrN9P6KvUZ+JLzGnphGPpUZbAo0/ Tx2Ux/jBiEow1P0UjtOTwKoLKAj/kbZeZDXx1sbRo8uCrqWjDXe0H614uIvgK3jbj72l qKnXLj7Bqj56RDTc/SOyIXC2S78AN1zntt/WU= MIME-Version: 1.0 Received: by 10.213.77.75 with SMTP id f11mr907313ebk.15.1279909025442; Fri, 23 Jul 2010 11:17:05 -0700 (PDT) Received: by 10.14.37.142 with HTTP; Fri, 23 Jul 2010 11:17:05 -0700 (PDT) Date: Fri, 23 Jul 2010 23:47:05 +0530 Message-ID: Subject: help with a schema design problem From: Pramod Goyal To: solr-user@lucene.apache.org Content-Type: multipart/alternative; boundary=00c09f7b25efce8c48048c120a5b X-Virus-Checked: Checked by ClamAV on apache.org --00c09f7b25efce8c48048c120a5b Content-Type: text/plain; charset=ISO-8859-1 Hi, Lets say i have table with 3 columns document id Party Value and Party Type. In this table i have 3 rows. 1st row Document id: 1 Party Value: Pramod Party Type: Client. 2nd row: Document id: 1 Party Value: Raj Party Type: Supplier. 3rd row Document id:2 Party Value: Pramod Party Type: Supplier. Now in this table if i use SQL its easy for me find all document with Party Value as Pramod and Party Type as Client. I need to design solr schema so that i can do the same in Solr. If i create 2 fields in solr schema Party value and Party type both of them multi valued and try to query +Pramod +Supplier then solr will return me the first document, even though in the first document Pramod is a client and not a supplier Thanks, Pramod Goyal --00c09f7b25efce8c48048c120a5b--