Hi Pascal I've heard of others using search_for_ids to get around the pagination stuff - I'm not sure how they did it though. So maybe that's an option. Beyond that, I'm not much help, sorry.
Good luck! -- Pat On 17/02/2009, at 8:15 PM, pascal wrote: > > And if i build a query similiar to this: > "firstname:whatever OR (lastname:whatever AND (friend_ids:99 OR > privacy:0)) OR description:whatever" > > (User with ID 99 is searching for "whatever", privacy = 0 -> privacy > disabled, privacy = 1 -> privacy enabled) > > > Otherwise i see following options: > - stick with what we have now (lots of LIKE staments, will not scale > as soon as we have more users and more text to search and does not > offer weights, facets and so on) > - use several queries and then merge the results > - filter the results after the are returned by TS and try to get > pagination working. maybe search_for_ids is the way to go here... > pagination would then involve only messing with a list if Integers > - try the named scope thing Alex proposed (and again... get pagination > to work) > > Pascal > > > > > On Feb 17, 9:11 am, Pat Allan <[email protected]> wrote: >> Oh, misunderstanding on my part. >> >> I'm afraid I can't think of a way to do that using Sphinx... you can >> only limit the records returned, not the text that is compared >> against >> in each record (on a case-by-case basis, that is). >> >> Unless there's other clever minds on this list who can think of a >> way? >> >> -- >> Pat >> >> On 17/02/2009, at 6:37 PM, pascal wrote: >> >> >> >>> Pat >> >>> I had a look at your example but I'm not sure it does excactly >>> what i >>> need.... >>> The privacy check should only be applied to the "Lastname" attribute >>> of the user model, not to "description" and "firstname". >> >>> How can i achieve something like that? >> >>> Thanks >> >>> Pascal >> >>>>>>>>> # This will match 0 for public users, and the user id for >>>>>>>>> private >>>>>>>>> users >>>>>>>>> User.search "whatever", :with => {:user_limit => [0, user.id]} >> >>>>>>>>> Give that a shot. >> >>>>>>>>> Cheers > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
