[Rails] Re: ActiveRecord query

Don't work for me.
A last I use

arreglo= Array.new
arreglo=solicituds.all(:select =>
"convenio_id").map(&:convenio_id)
arreglo<<-1
Convenio.where(["id NOT IN (?)",arreglo])
I'm not happy but works.

On 12 nov, 09:27, Tim Shaffer <timshaf...@me.com> wrote:
> On Nov 12, 6:59 am, Ich <aconsuegra2...@gmail.com> wrote:
>
> > I want all the "convenios" that don't have been requested by a
> > particular user.
>
> This is not tested, but I think something like this should get you
> what you want. May need to tweak it a little bit.
>
> Convenio.joins(:solicituds).where("solicituds.usuario_id <> ?", 1234)

--
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 rubyonrails-talk@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.