Get file uploads from a joined table

Hi sykomac,

The 'leftJoin' option doesn't yet support loading uploads for the joined table.

So, it could be a bit tricky. You could try doing a separate getRecords() call for 'program_addresses' with a where that loaded the records you wanted based on some criteria from the previous table you loaded.

How many programs are you displaying on a page?

Dave,

Thanks for the info.

I only need to display one program with the upload at a time on the page so I guess I'll just have to do a second search.

Thanks

Any idea when this functionality will be available?

Hi tmudford,

We don't have any current plans for further automatic support of joins or loading of uploads.

If you're already doing a custom mysql query with a join you can always just do another query to get the uploads.

If you have records from a single table, or just want to reference some MySQL code for loading uploads, you could take a look at the functions addUploadsToRecords(), and addUploadsToRecord() in /lib/upload_functions.php

Hope that helps!