After hacking into thinking sphinx source a bit, I finally came out with a dirty solution that describes a field phone_any_status to make TS join phone_numbers table, and describes phone attribute with sql fragment.
On 21 дек, 10:20, Alexey Ilyichev <[email protected]> wrote: > Now I have another task. I want to include user's phone number in the > index, but only if it was verified. PhoneNumber is associated model. > I tried this: > indexes phone_numbers(:phone) > where "(#{PhoneNumber.table_name}.status = 'Verified' OR > #{PhoneNumber.table_name}.status IS NULL)" > > but then I figured it doesn't include users who have phone numbers, > but none of them is verified. > Thought I can do it with indexes call, but I don't know how to > explicitly join phone_numbers table. > > On Dec 21, 6:56 am, Pat Allan <[email protected]> wrote: > > > Hi Alexey > > > This should be possible, albeit slightly fiddly - if you're using MySQL, > > you can do the following: > > > indexes "IF(email_verified = 1, email, '')", :as => :email > > > I'm not sure if PostgreSQL has an IF function, so you may need to find > > something equivalent that does the same job - and I'm presuming here the > > two columns are email and email_verified - adapt as necessary. > > > Cheers > > > -- > > Pat > > > On 21/12/2010, at 2:37 AM, Alexey Ilyichev wrote: > > > > Hi! > > > > I need to build an index for users table and I want email to be > > > included only for these users who have verified their email. Is it > > > possible with thinking sphinx? > > > > -- > > > 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 > > > athttp://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]. For more options, visit this group at http://groups.google.com/group/thinking-sphinx?hl=en.
