EXISTS Filter | Community
Skip to main content
Level 3
March 30, 2023
Question

EXISTS Filter

  • March 30, 2023
  • 1 reply
  • 1641 views

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.

1 reply

MoniqueEvans
Community Advisor
Community Advisor
March 30, 2023

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?

Arnab4Author
Level 3
March 30, 2023

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.

Madalyn_Destafney
Community Advisor
Community Advisor
March 31, 2023

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.

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