I would like to index only a subset of the entries in a table and am not sure how to tell TS to do that (I'm quite new to TS).
In my app I have users who perform a variety of roles: some write articles, others write comments, some have admin rights, other don't etc. I would like to index only those users who have published articles. There is a users table, an articles table and - since there is a many-to-many relationship between users and articles - an articles_users join table. I need to run the following sql to find users with published articles: SELECT DISTINCT users.* FROM users, articles_users, articles WHERE users.id = articles_users.user_id AND articles.id = articles_users.article_id AND articles.published; Is there a way I can ask TS to only index those users returned by this query? - Shailen Tuli -- You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/thinking-sphinx?hl=en.
