How would you model this? We have a table of news items that people can view in their news stream and comment on. Users have the ability to "mute" item so they never see them in their feed or search results.
>From what I can see there are a couple ways to accomplish this. 1 - Post process the results and do not render any muted news items. The downside of the pagination become problematic. Its possible we may forgo pagination because of this but for now assume that pagination is a requirement. 2 - Whenever we query for a given user we append a clause that excludes all muted items. I assume in Solr we'd need to do something like -item_id(1 AND 2 AND 3). Obviously this doesn't scale very well. 3 - Have a multi-valued property in the index that contains all ids of users who have muted the item. Being new to Solr I don't even know how (or if its possible) to run a query that says "user id not this multivalued property". Can this even be done (sample query please)? Again, I know this doesn't scale very well. Any other suggestions? Thanks in advance for the help. -- View this message in context: http://lucene.472066.n3.nabble.com/MultiValue-Exclusion-tp870173p870173.html Sent from the Solr - User mailing list archive at Nabble.com.
