Find all posts and replies that have images inserted/attached


(Jane Jojo) #1

Related to:

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


(Jeff Atwood) #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.


(Jay Pfaffman) #3

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

Edit: But I wasn’t even close.


(Kane York) #4

I think the post_uploads table carries this relation.


(Régis Hanol) #6

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


(Jane Jojo) #7

Can I do a OR?

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

https://comments.alittlebitofspice.com/search?q=with%3Aimages%20filetype%3Ajpg%20OR%20filetype%3Ajpeg


#8

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

with:images filetype:jpg,jpeg

https://comments.alittlebitofspice.com/search?q=with%3Aimages%20filetype%3Ajpg%2Cjpeg


(system) #9

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.