I have this in the database
id, npi, location_id, latitude, longitude
having the npi, lat and long as attributes in the index definition.
sample records
1, 12345, 12, 39.2903848, -76.6121893
2, 12345, 13, 49.2133434, -123.9499228
3, 12345, 17, 21.8477377, -89.8488202
*{:group_by => :npi , with: {geodist: 0.0..50_000.0}}*
so I get one matching record if any of the three falls within 50 mile
radius of my current location.
When I do this, I alway get the *record id 1*, no matter what location
matches withe distance criteria. this is because *group_by npi* clause.
how do get the correct record for the matched record? I am looking for
something like *having min(geodist), *but don't know how. please help.
Thanks
Ravi Ada
--
You received this message because you are subscribed to the Google Groups
"Thinking Sphinx" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/thinking-sphinx.
For more options, visit https://groups.google.com/d/optout.
