Hi shauna,
Try changing the following part.
.includes(:rsvp_sessions).includes(:event_sessions)
to
.includes([:rsvp_sessions, :event_sessions])
I think you are getting the error because the second call of "includes"
overridden the first one.
Thanks,
Genta
On Saturday, May 7, 2016 at 3:26:23 PM UTC-10, shauna wrote:
>
> Accessing a PostgreSQL 9.4.4 database, I have code like:
>
> previous_rsvps = Rsvp
> .select('rsvp.user_id', 'event_sessions.name')
> .where(user_id:
> selected_attendees).includes(:rsvp_sessions).includes(:event_sessions)
> .where("event_sessions.event_id IS NOT NULL")
> .where("event_sessions.name ~* ? OR event_sessions.name !~* ?",
> "Workshop", "Installfest")
>
> I believe this retrieves the expected records, because if I follow it with
> a command:
> previous_rsvps.pluck('event_sessions.name').uniq.sort
> then the correct names are listed.
>
> However, if I give the command:
> previous_rsvps.count
> then I get the error message:
> ActiveRecord::StatementInvalid: PG::UndefinedTable: ERROR: missing
> FROM-clause entry for table "rsvp".
>
> Of course, I'm looking to do more with the previous_rsvps object, but this
> example captures the error. What causes this error and how do I get around
> it?
>
--
You received this message because you are subscribed to the Google Groups "Ruby
on Rails: Talk" 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].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rubyonrails-talk/a889d0e3-5107-49c8-930a-75949955ba50%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
