> So a search for a product once the user logs in and searches for only the > products that he has access to Will translate to something like this . ,the > product ids are obtained form the db for a particular user and can run > into n number. > > <search term> &fq=product_id(100 10001 ......n number) > > but we are currently running into too many Boolean expansion error .We are > not able to tie the user also into roles as each user is mainly any one who > comes to site and purchases a product .
I'm wondering if new trunk Solr join functionality can help here. * http://wiki.apache.org/solr/Join In theory you can index your products (product_id, ...) and user_id-product many-to-many relation (user_product_id, user_id) into signle/different cores and then do join, like f=search terms&fq={!join from=product_id to=user_product_id}user_id:10101 But I haven't tried that, so I'm just speculating.
