Skip to Content (Press Enter)
UserImage.jpg
v
0Views
3Comments
Select Projects where an user doesnot have access to in the given organization
Question
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
0
0
26 Jun 2015
Copy Link
2020-09-15 13-07-23
Kilian Hekhuis
 
MVP
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.
0
0
30 Jun 2015
Copy Link
UserImage.jpg
v
Hello Kilian Hekhuis,

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

Thanks
0
0
30 Jun 2015
Copy Link
2020-09-15 13-07-23
Kilian Hekhuis
 
MVP
Hi vdha,

Good to hear you solved it.
0
0
01 Jul 2015
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.