Hi Misha When you’re putting SQL statements in attributes or fields, then that *is* real SQL, not Sphinx’s equivalent. Hence, you probably want to compare item_photo_id against NULL (or you can use a CASE statement if you wish).
Cheers — Pat On 4 Nov 2014, at 11:59 pm, Misha Slyusarev <[email protected]> wrote: > Ok, I'll try. Meanwhile, can you take a look on this > > has > 'IF(item_variations.item_photo_id=0,items.picked_at,item_variations.picked_at)', > as: :combined_picked_at, type: :datetime > > I was able to create combined_picked_at attribute and sort by it. But for > some reason only item_variations.picked_at goes to that calculated field and > items.picked_at are ignored. Is this definition correct? Maybe I'm missing > something here? > > On Monday, 3 November 2014 18:37:00 UTC+2, Misha Slyusarev wrote: > I would like to be able ordering by a calculated field. Which is constructed > from a field in current table and if it's empty use a field from a associated > table. > > I used to use case when in my regular Rails requests. > > items.joins('left join item_variations iv on iv.item_id=items.id'). > select('case when iv.item_photo_id is not null then iv.picked_at else > items.picked_at end as combined_picked_at') > Now I'm looking for a way to use similar technique in Sphinx. Is it possible? > > > -- > 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.
