Hi, I have a very simple user table with the following fields:

1. Name
2. Date of Birth
3. Sex
4. Location
5. Latitude
6. Longitude


Now I want to find out all the male users whose age is in between 20
to 50 and are within 50 miles of a given coordinate. To filter by sex
and age, I plan to use meta_search but to filter by distance I plan to
use Sphinx. So it is possible to chain metasearch and thinking sphinx
and then do offset nad limit. I am thinking of something like this:

User.search({"sex_eq" => 'M', "dob_gte" => 2011-..., "dob_lte" =>
2011-01-01"}).sphinx_search("", :geodist => [@lat, @lng], :order =>
"@geodist...).page(1).per(10)


Ritesh

-- 
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.

Reply via email to