Expand my Community achievements bar.

exists examples

Avatar

Level 2
 
Topics

Topics help categorize Community content and increase your ability to discover relevant content.

4 Replies

Avatar

Employee

Hi Darryl,

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

Thanks!

Kyna

Avatar

Level 2

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.

Avatar

Level 3

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.