Hi Eric, Raju Thanks for reply..
It means I need to index separate table data (news, article and blog), currently I am joining the table and making a single rows for all three table. One other thing I want to know that, in this case (if i indexing table data separately then) some column of the table is not common. so it will go blank while indexing for other table. for example: news and article have some other column like, city which is not common and not in the other table, if I am indexing other table then this column will go blank. is this ok to leaving blank field? also in this case no. of column will increase so is there any limitation in solr regarding no. of column? thanks On Mon, Feb 15, 2010 at 2:57 PM, NarasimhaRaju <rajux...@yahoo.com> wrote: > Hi, > you should have a new field in your index say 'type' which will have values > 'news','article' and 'blog' for documents news,article and blog > respectively. > when searching with facet's elabled make use of this 'type' field then you > will get what you wanted. > > Regards, > P.N.Raju, > > > > > > ________________________________ > From: Ranveer Kumar <ranveer.s...@gmail.com> > To: solr-user@lucene.apache.org > Sent: Sun, February 14, 2010 5:45:54 AM > Subject: Facet search concept problem > > Hi All, > > My concept still not clear about facet search. > > I am trying to search using facet query. I am indexing data from three > table, following is the detail of table: > > table name: news > news_id > news_details > > table name : article > article_id > article_details > > table name: blog > blog_id > blog_details > > I am indexing above tables as: > id > news_id > news_details > article_id > article_details > blog_id > blog_details > > Now I want, when user search by "soccer game" and search match in all field > news(5), article(4) and blog(2), > then it should be list like: > news(5) > article(4) > blog(2) > > currently facet listing like: > soccer(5) > game(6) > > please help me.. > thanks > > > > >
