Getting nested objects with Active Record Join without includes

Question

I have an Active Record query that involves a JOIN using a SQL statement.

TableA.where(:b_id => "123")
      .joins("INNER JOIN TableB ON column1='value1' AND column2 = TableB.id")

where column1 and column2 belong to TableA

The reason I have to use SQL is because I don't have a relationship defined between the two tables (for other reasons), and haven't found a way to specify a ON clause on columns, using Active Record JOIN

Since I don't have a relationship defined, I cannot use :includes and hence do not have access to TableB's columns in the results. Is there a way to get TableB's data by modifying the above query?

Deepak Mahakale · Accepted Answer · 2018-05-30 03:41:41Z

1

You can add the columns in the select query.

TableA.select('TableA.*, TableB.column1, TableB.column2')
      .where(:b_id => "123")
      .joins("INNER JOIN TableB ON column1='value1' AND column2 = TableB.id")

NOTE: You might not see the columns in the TableA record in rails console. Use as_json to check if you got them in result

answered May 30, 2018 at 3:41

Deepak Mahakale

23.8k10 gold badges73 silver badges94 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Suh Over a year ago

Thanks, that worked! Didn't realize I could use TableB's columns in the select.

Collectives™ on Stack Overflow

Getting nested objects with Active Record Join without includes

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related