How to exclude one specific file type in CQL?

[Manuel]

Hi all,

I'm trying to exclude one certain file type (*.json) from the CQL search results. I already looked up here, but did'n find any working solution:

https://developer.atlassian.com/server/confluence/advanced-searching-using-cql/

https://confluence.atlassian.com/doc/confluence-search-syntax-158720.html

https://confluence.atlassian.com/conf72/confluence-search-fields-982323357.html

Has anyone an idea?

Thank you!

[SMS · Accepted solution]

Hello Manuel,

Happy to try and help you with this!

According to How to Search Specific Attachment Type in Confluence, you can use the following to narrow down a specific attachment:

/.*<attachment type>.*/ 

I then used the information from Confluence Search Syntax to negate that, by putting a minus (-) sign in front of that attachment type. It returned all files that were NOT the attachment type.

Thus, I think this would work for you:

-/.*json.*/

Can you give that a try and let me know how that goes?

Shannon

[Manuel]

Hello Shannon,

that's exactly what I was looking for! Works perfectly fine for me!

Thank you!

Manuel

PS: Just use a "NOT" instead of a "-" (minus). ;-)

[SMS]

Manuel,

Both NOT and minus (-) should work, but whichever one is easiest for you! I tested and can confirm both.

Glad to hear it helped, and have a pleasant rest of your week.

Take care,

Shannon