You could use .compact on the results to remove nils - but using
named_scopes breaks pagination, as named_scope doesn't apply to
Sphinx, just the database calls once Thinking Sphinx knows what the
search results are and needs to load the relevant instances (I know
you're probably aware of this Alex, just repeating for others who
might not be).
Oli: your code (at least, when using a range and having the range the
right way around) should work. Hopefully we can figure out why it isn't.
--
Pat
On 05/01/2009, at 10:57 AM, Alex Caudill wrote:
>
> Currently I'm using a named_scope with this as the conditions:
>
> class Array
> def to_date_range(colname = "users.dob")
> return map{ |x|
> t = x.split("-")
> a = Date.new(t.last.to_i.years.ago.year).to_s(:db)
> b = t.first.to_i.years.ago.to_s(:db)
> "#{colname} BETWEEN '#{a}' AND '#{b}'"
> }.join(" OR ")
> end
> end
>
> It takes an array like: ["18-22", "23-27", "30-40"] and it respects
> holes
> in the age range. Yeah, it's hideous, and no error checking. It works.
>
> Then you can do:
>
> res = User.date_range(my_array.to_date_range).search conditions_hash
>
> This returns an array of Users which is then #search'd, but if an
> item in the
> date_range named scope doesn't match the search results, it becomes
> nil
> in the results. So if that date_range scope returned [1,2,3] and
> only 1 was
> a match for conditions_hash, the results would be [1,nil,nil]. I use
> a simple
> Array#delete_if block to get rid of the nils.
>
>
> On Sun, Jan 4, 2009 at 9:20 PM, Pat Allan <[email protected]>
> wrote:
>>
>> Hi Oli
>>
>> The last pastie's syntax isn't going to work, as Thinking Sphinx
>> doesn't build a big string, but has to send the attribute name and
>> range values through to Sphinx as a string and integers,
>> respectively.
>>
>> The middle one, as we've discussed on Twitter, the range elements
>> need
>> to be reversed - but it sounds like that doesn't help anyway.
>>
>> You don't need :sortable => true on any attribute - they're sortable
>> by default, it's only fields that need it.
>>
>> What's the underlying column type? datetime or date? And using MySQL?
>> or PostgreSQL?
>>
>> Cheers
>>
>> --
>> Pat
>>
>> On 05/01/2009, at 10:02 AM, Oli wrote:
>>
>>>
>>> Hi Y'all
>>>
>>> so given this model definition
>>>
>>> http://pastie.org/352604
>>>
>>> i get this
>>>
>>> http://pastie.org/352592
>>>
>>> or this
>>>
>>> http://pastie.org/352596
>>>
>>> and in that last one the ordering is completely ignored ..
>>>
>>> any suggestions?
>>>>
>>
>>
>>>
>
> >
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
