:joins help

rubyonrails-talk
1

Dear all

@policy_logs = PolicyLog.find(:all,:joins => "INNER JOIN po licy_logs_receiver"

                                     )

when i inspect the @policy_logs variable it doesnot show the joined table fields...

how can i get all the fields? Thanks for nay help

2

Dear all

@policy_logs = PolicyLog.find(:all,:joins => "INNER JOIN po licy_logs_receiver"

                                 \)

when i inspect the @policy_logs variable it doesnot show the joined table fields...

the select clause is select policy_logs.* by default. In addition the output of inspect() (which is what you see in the console) only ever shows the columns from the table itself.

Fred

3

Thanks for the reply... Then how can i get associated field also....

4

It's just the output of inspect that is limited - every else works fine (provided you change the select clause via the :select option)

Fred

5

Just in case... you know :include don't you?

6

Does Using :joins => "" requires association between the tables line belongs_to ,hasmany like that ....?

7

only if you want to use the shorthand form ( eg Person.find :all, :join => :orders)

Fred

8

Thanks for the reply... after only associating i got the associated table fields.

kindly look the below code

@policy_logs = PolicyLog.find(:all,       :joins =>" join policy_logs_receiver as plr on policy_logs.id =       plr.policy_logs_id")