exists examples

[kynabaker16]

Hi Darryl,

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

Thanks!

Kyna

[DarrylMo]

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.

[DarrylMo]

Any update on this ?

[AdamMi]

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.