Skip to main content
New Participant
March 30, 2023

EXISTS Filter

  • March 30, 2023
  • 1 reply
  • 1642 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
New Participant
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
New Participant
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
New Participant
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 : )