Skip to main content
Level 3
Mar 30, 2023 10:58 AM UTC
Question

EXISTS Filter

How to create or add EXISTS filter on document type report?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

6 replies

MoniqueEvans
Adobe Champion, Community Advisor, UG Leader
Adobe Champion, Community Advisor, UG Leader
Mar 30, 2023 12:15 PM UTC

Could you give us a little more context on what you are trying to pull in the report? This could mean a few different things and I don't want to steer you wrong. Are you trying to do a document report for a specific file type? Or a Project report that only lists projects that have specific documents?

Translate
Arnab4Author
Level 3
Mar 30, 2023 12:21 PM UTC

Hii Monique,

 

I am working a document type report with show proofs, projects and proof deadline.

recently i am working on Project status where only current and on hold project proofs will be show only report . and  also Decision made proof will not show on my report.

right now i am trying to figure out which exact filter i am use to get result. Please help.

Translate
Madalyn_Destafney
Community Advisor
Community Advisor
Mar 31, 2023 5:55 PM UTC

The word 'exists' doesn't exist in your filtering options, the word 'is not blank' or 'equals' point to that. So project status in a report is EQUALS current, on hold. Or if a decision is pending in a proof approval report, you'd use 'approver decision is pending' = true.

Translate
If this helped you, please mark correct to help others : )