Select Projects where an user doesnot have access to in the given organization

Select Projects where an user doesnot have access to in the given organization

  
I am trying to use aggregates for Select list of Projects where an user doesnot have access to in the given organization.


On Condition

With Filters


But here it lists all the Projects within the given organization.  If I give this condition

ProjectParticipant.UserId = Session.Report_ProjectwithoutAccess_UserId

It lists all the projects which the user have access to under given organization. But it is not working the other way. Help me with this please.Thanks
Hi vhda,

What you are selecting is all projects that all users have access to except the user you're targeting. The list you get should have many of the same projects, provided that multiple users have access. You really must rethink what you're doing, this is about basic programming, not about the platform.
Hello Kilian Hekhuis,

I figured out that was a mistake with the query, and got it solved.

Thanks
Hi vdha,

Good to hear you solved it.