Yeah, can't think of anything better that does the same thing. If you want to
force the join without the attribute (unless you need it?), just add the
following line to your define_index block:
join phone_numbers
Cheers
--
Pat
On 23/12/2010, at 12:49 AM, Alexey Ilyichev wrote:
> Sure, here it is:
>
> has phone_numbers.phone, :as => :phone_any_status
> indexes "GROUP_CONCAT(DISTINCT IF(#{PhoneNumber.table_name}.status
> = 'Verified', #{PhoneNumber.table_name}.phone, '') SEPARATOR '
> ')", :as => :phone
>
> I copied it from config generated for
> indexes phone_numbers.phone
> and changed a little
>
> On Dec 22, 9:57 am, Pat Allan <[email protected]> wrote:
>> Hi Alexey
>>
>> Care to share what that sql fragment/field definition is?
>>
>> --
>> Pat
>>
>> On 22/12/2010, at 5:29 PM, Alexey Ilyichev wrote:
>>
>>> 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
>>> 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.
>
--
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.
