ok thanks! I was thinking of putting the index on size, instead of product, since you can still index product attributes from size.
Thanks again! On Thu, Jun 24, 2010 at 11:35 AM, Pat Allan <[email protected]>wrote: > No worries :) > > One other thing to mention - if you really want price as a float/decimal, > then perhaps it's worth putting an index on Size, with a product_id > attribute, so you could search on Size and group by product_id (ie: limit to > one result per product). > > http://freelancing-god.github.com/ts/en/searching.html#grouping > > Cheers > > -- > Pat > > On 24/06/2010, at 1:31 PM, Jim Ruther Nill wrote: > > > Everything noted. Thanks for the fast reply! and, of course, this > wonderful app. :D > > > > On Thu, Jun 24, 2010 at 11:21 AM, Pat Allan <[email protected]> > wrote: > > Hi Jim > > > > Two things to note: > > > > * Sphinx has no concept of float arrays, only integer arrays > > * If price is/can-be an integer, then a normal filter should work, I'm > pretty sure: > > > > :with => {:size_prices => 0..10} > > > > Keep in mind the range arguments need to be integers. Also, aliases for > fields & attributes should be symbols, not strings. > > > > Cheers > > > > -- > > Pat > > > > On 24/06/2010, at 1:15 PM, Jim Ruther Nill wrote: > > > > > Hi! > > > > > > If you have a one-to-many association, > > > > > > Product - has_many :sizes > > > Size - belongs_to :product > > > > > > and a price attribute is on the Size model, how would you filter for a > particular price range? > > > > > > The define index block in the product model > > > > > > define_index do > > > has sizes(:price), :as => 'size_prices' > > > end > > > > > > Thanks! > > > > > > ------------------------------------------------------------- > > > visit my blog at http://jimlabs.heroku.com > > > > > > -- > > > 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]<thinking-sphinx%[email protected]> > . > > > For more options, visit this group at > http://groups.google.com/group/thinking-sphinx?hl=en. > > > > -- > > 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]<thinking-sphinx%[email protected]> > . > > For more options, visit this group at > http://groups.google.com/group/thinking-sphinx?hl=en. > > > > > > > > > > -- > > ------------------------------------------------------------- > > visit my blog at http://jimlabs.heroku.com > > > > -- > > 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]<thinking-sphinx%[email protected]> > . > > For more options, visit this group at > http://groups.google.com/group/thinking-sphinx?hl=en. > > -- > 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]<thinking-sphinx%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/thinking-sphinx?hl=en. > > -- ------------------------------------------------------------- visit my blog at http://jimlabs.heroku.com -- 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.
