Has many association with finder_sql

rubyonrails-talk
1

Hi, I have a customer and conversation model. A conversation is between 2 customers. Here is my association in customer. has_many :conversations, :class_name => "Conversation", :order => 'updated_at DESC', :finder_sql => 'SELECT * FROM conversations c WHERE (c.started_by = #{id} OR c.with = #{id})' do     def with(cust_id)      all(:conditions => ["conversations.started_by = ? OR conversations.with = ?", cust_id, cust_id])     end   end

Inside the association block I made a method which filters on the second customer of the conversation.

But when I do: myCustomer.conversations.with(someoneelseID)

I get the following error.

ActiveRecord::StatementInvalid (Mysql::Error: Operand should contain 1 column(s): SELECT * FROM `conversations` WHERE (conversations.started_by = 1 OR conversations.with = 1) AND (SELECT * FROM conversations c WHERE (c.started_by = 1 OR c.with = 1)) ORDER BY updated_at DESC)

How can i make Rails build a correct sql request? Greg

2

Greg Ma wrote in post #971151:

ActiveRecord::StatementInvalid (Mysql::Error: Operand should contain 1 column(s): SELECT * FROM `conversations` WHERE (conversations.started_by = 1 OR conversations.with = 1) AND (SELECT * FROM conversations c WHERE (c.started_by = 1 OR c.with = 1)) ORDER BY updated_at DESC)

Are you sure you really need :finder_sql? I didn't see anything here that :condtions and :order couldn't handle.