Query for recently uploaded / attached files

support
1

I am wondering if there is possibility to view posts with uploaded / attached files.

2

This might be possible with a Data Explorer query @techAPJ?

2 Likes
3

Yes. Here is a data-explorer query for that:

SELECT posts.id AS post_id,
       uploads.url
FROM post_uploads
JOIN uploads ON uploads.id = post_uploads.upload_id
JOIN posts ON posts.id = post_uploads.post_id
ORDER BY posts.created_at DESC

@Miro Install discourse-data-explorer plugin and import this query:

post-with-uploads.dcquery.json (312 Bytes)

5 Likes
4

Thanks,
That looks as for the admin. I thought more for forum users so they can check what are the latest uploaded files.

5

No such feature exists or is planned.

1 Like
6

Ok, thanks, I can do it other way.