Hi Erick and thanks for the quick reply.
Well, my intend would not to index all content elements with its own list of
authorized users IDs.
I was thinking more of something like I index the contents and the users +
their friend list separatly, and then being able somehow to ask Solr to
filter results of one index depending on the other. In SQL it would be
performed with a sub-query, for instance :
SELECT a.* FROM albums a
LEFT JOIN albums_settings as ON as.album_id = a.id
WHERE as.privacy_level = 'anyone'
OR
(as.privacy_level = 'friends'
AND a.owner_id IN (
SELECT friend_id FROM friendships
WHERE user_id = :currentUserId
)
)
;
It would require some tests, but this request should return only what we
want.
I was assuming by "complex query" that Solr would be able to perform that
kind of operation.
But if it does, that raises some questions :
- Is it the best way to do that ?
- It's obvious that i need to index the registered users in Solr (because an
user can search for others), but is it clever to index friend list for each
user as well ? (if we take a look at the search box on Facebook, or other
any sexy social network, they propose auto-complete for current user
friends, so maybe it makes sense...)
Br,
Benjamin.
--
View this message in context:
http://lucene.472066.n3.nabble.com/Content-privacy-search-index-tp3873462p3874112.html
Sent from the Solr - User mailing list archive at Nabble.com.
