cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
xyd
Helper II
Helper II

CDS View Filer "Owner is current user or his reporting hierarchy" not working

I have custom entity "TS".

Users have manager and position fields are setup.

But the CDS views only returning records matches the current user, but nothing from the people who is reporting to that current user.

The "Owner is current user or his teams or his reporting hierarchy and their teams" only returns the current users record too.

 

note: the current user has a security role that can read all records of this entity in the same Business Unit. And there is only the default BU.

What have I missed? I hope this doesn't requires to switch on the "Hierarchy Security" model in the environment? or?

Many thanks in adv


Xun

1 ACCEPTED SOLUTION

Accepted Solutions

well the Hierarchy Security model wasn't switched on as I stated in my original post...

Therefor the hierarchy depth is irrelevant...

Regarding the data, there is only 1 level depth I am expecting to see in the view (I am logged in as a line manager, and I am expecting to see all records own by the users who are reporting directly to me...)

 

Anyhow I have now tested it by switch on the Hierarchy security model, and guess what. that make the view filter working.

a bit annoying that this is not stated anywhere on the documentation regarding these view filters...or on the documentation regarding hierarchy security model...

View solution in original post

5 REPLIES 5
Satish-Reddy
Continued Contributor
Continued Contributor

 Have you mapped users to different Positions after you created them?  (Assuming you are using the Position hierarchy)

 

...........

Please mark it as answer if my post helps.

Thanks
Satish Reddy
https://pascalcase.com

Hi @Satish-Reddy ,

Yes, if you mean the Position field is filled in on users record.

 

I guess the question is are these view filters relying on anything else to be setup?...

 

cheers

xyd
Helper II
Helper II

Further to the above.

I have tried to use the related entity in the view filter see attached png.

This does return all records that owned by the current user as well as the anyone who's manager is the current user.

 

But still, this is not good enough. more later

Satish-Reddy
Continued Contributor
Continued Contributor

What is the depth of hierarchy ?

well the Hierarchy Security model wasn't switched on as I stated in my original post...

Therefor the hierarchy depth is irrelevant...

Regarding the data, there is only 1 level depth I am expecting to see in the view (I am logged in as a line manager, and I am expecting to see all records own by the users who are reporting directly to me...)

 

Anyhow I have now tested it by switch on the Hierarchy security model, and guess what. that make the view filter working.

a bit annoying that this is not stated anywhere on the documentation regarding these view filters...or on the documentation regarding hierarchy security model...

View solution in original post

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

secondImage

Power Apps Community Call

Please join us on Wednesday, October 20th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (2,079)