You can potentially just use a text_general field, in which case your comma separated words will be effectively a multi-valued field. I believe that will work.
As to how you want to use joins, that isn't possible. They are pseudo joins, not full joins. They will not be able to include data from the joined field in the result. Upayavira On jun 6, Advait Suhas Pandit wrote: > 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 >
