Facet search concept problem

[Ranveer Kumar <ra...@gmail.com>]

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

Re: Facet search concept problem

[Ranveer Kumar <ra...@gmail.com>]

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 <ra...@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 <ra...@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
>
>
>
>
>

Re: Facet search concept problem

[NarasimhaRaju <ra...@yahoo.com>]

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 <ra...@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



      

Re: Facet search concept problem

[Erik Hatcher <er...@gmail.com>]

You didn't mention what your faceting parameters were, but what you  
want to do is add a field to every document that specifies its  
source.  So add a "source" (or "type" maybe a better field name) field  
specifying "news", "article", or "blog".  Then facet on that new field.

	Erik



On Feb 13, 2010, at 11:45 PM, Ranveer Kumar wrote:

> 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