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 <http://dev.mysql.com/doc/refman/5.0/en/case.html> 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.
