Find all posts and replies that have images inserted/attached

Product Support

AI-generated summary

The discussion revolves around finding posts and replies with images. Jane_Jojo initiated the conversation, referencing a related topic on Meta Discourse. codinghorror suggested implementing an advanced search operator for posts with at least one image. pfaffman and riking proposed possible solutions using the Data Explorer plugin and the post_uploads table.

zogstrip revealed that the advanced search operator “with:images” can be used to find posts with images, along with specific file extensions like filetype:jpg. Jane_Jojo asked about combining search terms with an “OR” operator, and xrav3nz provided the solution by joining file types with a comma, e.g., with:images filetype:jpg,jpeg.

1

Related to:

https://meta.discourse.org/t/don-t-see-uploaded-images-404ing-and-uploads-tar-gz-does-not-show-them/93429

Title says it all: Is it possible to list all posts and responses that have images associated with it?

2

Hmm this is a good point @zogstrip do we have an advanced search operator for “post has at least one image”? That could be quite handy if it’s not nightmarishly difficult to implement.

3

I think that now you’d need the data Explorer plugin and search raw for upload://

Edit: But I wasn’t even close.

4

I think the post_uploads table carries this relation.

6

Yup, we have “with:images” which is generic and “filetype:jpg” which looks for a specific upload extension.

7

Can I do a OR?

“with:images filetype:jpg OR filetype:jpeg”

8

You can join the file types with a comma to achieve an OR, i.e.

with:images filetype:jpg,jpeg