Hi Pat! Thank you for this. Can I merge the results from both searches?
Kind regards, Miha On Fri, May 15, 2015 at 2:10 AM, Pat Allan <[email protected]> wrote: > Hi Miha > > While Sphinx can have arrays of integers, it can’t have arrays of floats - > and even if it could, there’s no link between one item in one array (e.g. a > price) and one item in another array (e.g. a currency). > > The best approach here is to add a Sphinx index for AdPrice, and search > from that perspective instead. > > AdPrice.search :with => { > :currency_id => params[:c_currency_id].to_i, > :price => params[:price_from].to_f..params[:price_to].to_f > } > > Cheers > > — > Pat > > > On 15 May 2015, at 2:04 am, Treeninja <[email protected]> wrote: > > > > Hi guys! > > > > I am using TS 2.0. > > > > I have an Ad which has many prices, all in different currency. I am > using Fixer API to convert a price to other prices and store them in DB. I > would like to index column price and currency_id from the ad_prices table: > > > > # id :integer not null, primary key > > # ad_id :integer > > # currency_id :integer > > # price :decimal(8, 2) > > # is_up_or_down :integer > > # is_default :boolean default(FALSE) > > # created_at :datetime not null > > # updated_at :datetime not null > > > > In the ad model I have define_index section: > > > > has ad_prices.price, :as => :price, :type => :float > > has ad_prices.currency_id, :as => :c_currency_id > > > > How can I force the sphinx to use combination of prices and currencies > at the same time. For example if user sets param[c_currency_id]=1, how can > sphinx filter only the prices in selected currency? I have a range filter > for prices: price_from, price_to, c_curency_id > > > > Thank you very much for the support! > > > > Kind regards, Miha > > > > -- > > 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. > > -- > 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. > -- 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.
