Joins with comma separated values

[Advait Suhas Pandit]

Hi,

We have some master data and some content data. Master data would be things 
like userid, name, email id etc.
Our content data for example is a blog.
The blog has certain fields which are comma separated ids that point to the 
master data.
E.g. UserIDs of people who have commented on a particular blog can be found in 
the blog "table" in a comma separated field of userids. Similarly userids of 
people who have liked the blog can be found in a comma separated field of 
userids.

How do I join this comma separated list of userids with the master data so that 
I can get the other details of the user such as name, email, picture etc?

Thanks,
Advait

Joins with comma separated values

[Advait Suhas Pandit]

Hi,

We have some master data and some content data. Master data would be things 
like userid, name, email id etc.
Our content data for example is a blog.
The blog has certain fields which are comma separated ids that point to the 
master data.
E.g. UserIDs of people who have commented on a particular blog can be found in 
the blog "table" in a comma separated field of userids. Similarly userids of 
people who have liked the blog can be found in a comma separated field of 
userids.

How do I join this comma separated list of userids with the master data so that 
I can get the other details of the user such as name, email, picture etc?

Thanks,
Advait

Suggester for text array

[Advait Suhas Pandit]

Hi,

We run an ecommerce company and would like to use SOLR for our product database 
searches.

We have products along with the categories that they belong to. In case the 
product belongs to more than 1 category, we have a comma separated field of 
categories. 

How do we do auto complete on -
1. Multiple fields - product name, category
2. On categories which are not first in the list in the case of the comma 
separated values
E.g. If a product belongs to Hair Care Products, Personal Care Products how do 
we ensure that the suggester will even suggest if someone starts typing in 
Personal Care. Also, how do we show only Personal Care in the auto complete and 
not as Hair Care Products, Personal Care Products.

Thanks,
Advait