ansaurus

Question

Answer 1

A:

I don't believe it is possible to do it directly, but as finding one record is only a single query, why not do it outside the include?

e.g

first_photo = Photo.find(records.first.photo_id)

After your main find

DanSingerman 2009-09-29 09:40:17

i'm sure this would work find, but if I have 50 entries it'll have to do it 50 different times. It works fine right now with the include, it's just pulling into memory more info than I need. ;-(

holden 2009-09-29 09:45:42

Can you clarify what you want in your question? You either want 1record or 50, but it is not clear what you are trying to do.

DanSingerman 2009-09-29 09:47:28

Sorry, I changed it a little. But basically I'm retrieving a list of items, and each item has multiple images and ratings. I want all the ratings included, but I only need one image for each item, basically a preview.

holden 2009-09-29 09:56:33

Is there any ordering to the photos for each item?

DanSingerman 2009-09-29 10:06:20

no, just the date they get added, which doesn't matter.

holden 2009-09-29 10:10:01

i suppose using :include on photos isn't a huge footprint, i just thought there might be an easy way to limit it.

holden 2009-09-29 10:29:24

No easy way I think. It must be possible using SQL aggregate functions (using the AR :select and :group options) but can not quite get my head round it now.

DanSingerman 2009-09-29 10:29:53

Answer 2

A:

I'm not going to investigate the detailed query, but I'm thinking find_by_sql is in order for this particular case.

Barry Hess 2009-09-29 13:40:47

Answer 3

A:

Any body have any luck with this problem?

Daniel 2009-12-16 13:12:20

ansaurus

tags:

views:

answers:

rails include with options

related questions