I want to do that. But if i understand correctly in solr it would store the field like this:
p_value: "Pramod" "Raj" p_type: "Client" "Supplier" When i search p_value:"Pramod" AND p_type:"Supplier" it would give me result as document 1. Which is incorrect, since in document 1 Pramod is a Client and not a Supplier. On Fri, Jul 23, 2010 at 11:52 PM, Nagelberg, Kallin < knagelb...@globeandmail.com> wrote: > I think you just want something like: > > p_value:"Pramod" AND p_type:"Supplier" > > no? > -Kallin Nagelberg > > -----Original Message----- > From: Pramod Goyal [mailto:pramod.go...@gmail.com] > Sent: Friday, July 23, 2010 2:17 PM > To: solr-user@lucene.apache.org > Subject: help with a schema design problem > > 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 >
