exists examples | Community
Skip to main content
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

kynabaker16
Adobe Employee
Adobe Employee
May 29, 2020

Hi Darryl,

Can you expound on your question a little bit so we can try to get you the answers you need?

Thanks!

Kyna

DarrylMoAuthor
Level 2
June 8, 2020

I have the following exist statement on a program report

DE:Status=InFlight Placeholder Planning Requested

DE:Status_Mod=in

EXISTS:a:$$EXISTSMOD=EXISTS

EXISTS:a:$$OBJCODE=PROJ

EXISTS:a:ownerID=$$USER.ID

EXISTS:a:ownerID_Mod=in

EXISTS:a:programID=FIELD:ID

EXISTS:b:$$EXISTSMOD=EXISTS

EXISTS:b:$$OBJCODE=PROJ

EXISTS:b:programID=FIELD:ID

EXISTS:b:status=DED CPL NON ONH

EXISTS:b:status_Mod=notin

portfolioID=5ce2713001690ea5f48d7e3b37a42b9c 5d37274600155fb86931bfaf8ad975d4 5d37374a0022fdc96650de4519852da4

portfolioID_Mod=in

This is working but its also showing false positives. Im looking to bring back projects, within programs that are assigned to the logged on user, but are not set to DED CPL NON ONH, but only in programs that are in Placeholder Planning Requested. Its ignoring the project status and returning all projects assigned to that user regardless of the project status within the program.

Level 3
June 11, 2020

Thanks for raising this issue, I've submitted a case on your behalf. Your ASE will reach out to you shortly to help in troubleshooting this issue.