I have these sql code in postgresql "SELECT * from convenios where id NOT IN (SELECT convenio_id from solicituds where usuario_id=?"
but don't find a way of used it in rails except find_by_sql. There is a another way?? class Usuario < ActiveRecord::Base belongs_to :persona has_many :solicituds, :dependent => :destroy has_many :convenios, :through => :solicituds has_many :nivelesacceso has_one :nomina end class Convenio < ActiveRecord::Base has_many :solicituds, :dependent => :destroy has_many :personas, :through => :solicituds validates_presence_of :nombre, :serie, :descripcion validates_uniqueness_of :serie validates_format_of :serie, :with => /cci|cue/ validates_length_of :serie, :is => 8 end class Solicitud < ActiveRecord::Base belongs_to :convenio belongs_to :usuario end -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" 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/rubyonrails-talk?hl=en.
