I have simple situation: Program ---< CustomerProgram >--- Statecustomer
In ProgramsController list action I want to show virtual column named :last_statecustomer_name. So: In my ProgramsController: ... config.columns[:last_statecustomer_name].includes = [:customer_programs] ... In Program model: ... def last_statecustomer_name customer_programs.last(:order => :date, :include => [:statecustomer]).try(:statecustomer).try(:name) end And I'm getting N+1: Dcp Load (0.6ms) SELECT `programs`.* FROM `programs` WHERE ((`programs`.`parent_id` IS NULL)) AND ( (`programs`.`type` = 'Dcp' ) ) ORDER BY `programs`.`name` ASC LIMIT 0, 30 CustomerProgram Load (0.3ms) SELECT `customer_programs`.* FROM `customer_programs` WHERE (`customer_programs`.program_id IN (29,10,12,24,20,15,13,26,11,28,14,16,25,19,30,21,23,32,17,27,18,8,22,9,80,129,1,31,130)) CustomerProgram Columns (1.4ms) SHOW FIELDS FROM `customer_programs` Rendering template within layouts/application Rendering list Rendered _list_header (42.5ms) Rendered _list_column_headings (36.4ms) Rendered _messages (2.7ms) Rendered _list_messages (43.3ms) CustomerProgram Load (0.3ms) SELECT * FROM `customer_programs` WHERE (`customer_programs`.program_id = 29) ORDER BY date DESC LIMIT 1 Statecustomer Columns (1.6ms) SHOW FIELDS FROM `customers` Statecustomer Load (0.2ms) SELECT * FROM `customers` WHERE (`customers`.`id` = 8) AND ( (`customers`.`type` = 'Statecustomer' ) ) Rendered _list_record_columns (67.0ms) Rendered _list_actions (103.8ms) Rendered _list_record (199.3ms) CustomerProgram Load (0.2ms) SELECT * FROM `customer_programs` WHERE (`customer_programs`.program_id = 10) ORDER BY date DESC LIMIT 1 Statecustomer Load (0.2ms) SELECT * FROM `customers` WHERE (`customers`.`id` = 1) AND ( (`customers`.`type` = 'Statecustomer' ) ) Rendered _list_record_columns (27.5ms) Rendered _list_actions (28.3ms) Rendered _list_record (58.0ms) CustomerProgram Load (0.3ms) SELECT * FROM `customer_programs` WHERE (`customer_programs`.program_id = 12) ORDER BY date DESC LIMIT 1 CACHE (0.0ms) SELECT * FROM `customers` WHERE (`customers`.`id` = 8) AND ( (`customers`.`type` = 'Statecustomer' ) ) Rendered _list_record_columns (26.2ms) Rendered _list_actions (27.3ms) Rendered _list_record (55.7ms) CustomerProgram Load (0.2ms) SELECT * FROM `customer_programs` WHERE (`customer_programs`.program_id = 24) ORDER BY date DESC LIMIT 1 Statecustomer Load (0.2ms) SELECT * FROM `customers` WHERE (`customers`.`id` = 4) AND ( (`customers`.`type` = 'Statecustomer' ) ) Rendered _list_record_columns (26.9ms) Rendered _list_actions (27.8ms) Rendered _list_record (56.9ms) CustomerProgram Load (0.2ms) SELECT * FROM `customer_programs` WHERE (`customer_programs`.program_id = 20) ORDER BY date DESC LIMIT 1 Statecustomer Load (0.2ms) SELECT * FROM `customers` WHERE (`customers`.`id` = 9) AND ( (`customers`.`type` = 'Statecustomer' ) ) What am I doing wrong? -- You received this message because you are subscribed to the Google Groups "ActiveScaffold : Ruby on Rails plugin" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/activescaffold?hl=en.
