By drupler on

Is there a way to sort file attachments? Either manually or by the uploaded order/date? I have a page where users can attach files, and I want the newest ones to always be on the top.

⋅ Categories: Drupal 5.x

Comments

vm’s picture

vm commented

write custom DB query, or investigate the views.module and build a query with it.

another method would be to create a taxonomy for this uploads and list them by term: more info on this found in the handbooks -> core modules -> taxonomy section.

dberard’s picture

dberard commented

I know this post is old so maybe this helps someone.
I was able to sort file attachments by most recent file added via the upload.module located in /modules/upload. Around line 846 is a select statement SELECT * FROM {files} f INNER JOIN {file_revisions} r ON f.fid = r.fid WHERE r.vid = %d ORDER BY f.fid add DESC to the end so it reads SELECT * FROM {files} f INNER JOIN {file_revisions} r ON f.fid = r.fid WHERE r.vid = %d ORDER BY f.fid DESC.