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.

Reply via email to