Ahoy Ruby on Rails- join tables (Visit and Event)

Question

I am using Ahoy for tracking in my web app. I find events with this:

@events = Ahoy::Event.where_properties(title: params[:token])

and I want to get all Visits having visit ID that the above relation, @events, has.

I can join the two tables using Visit.joins(:ahoy_events) but Visit.joins(:@events) gives an error, as expected. How do I do this?

Since we're only querying by ID, there's no need to even `join` here. — Tom Lord, Jan 04 '18 at 12:49
@TomLord that gives "PG::UndefinedColumn: ERROR: column visits.visit_id does not exist". — a3y3, Jan 04 '18 at 14:10

score 0 · Accepted Answer · answered Jan 04 '18 at 12:54

I think I got it. Variables are not allowed in a joins() query, hence I used this

def show
    @events = Ahoy::Event.where_properties(title: params[:token])
    @visits = Visit.joins(:ahoy_events).where(:ahoy_events=>{:properties => {title: params[:token]}})
end

And it seems to be working.

Ahoy Ruby on Rails- join tables (Visit and Event)

1 Answers1