Non-admins unable to see dot walked fields in sc_task list view

[LikeARabbit]

I've run in to an odd issue. When I go to the sc_task table I'm able to see the "Item" column without issue, which is dot walked from the RITM (Requested Item.Item). However, when a non-admin views the same list the column is present but refuses to display any values.

What I see:

List View

Personalize List Columns

----------------

What non-admins see:

List view (notice that Item and Created are both empty, both are dot walked columns)

Personalize List Columns

----------------

Non-admins can click into the sc_tasks and click up to the RITM and see all of the fields without issue, this really just seems to affect the list view. Because of that I don't think it's an ACL issue but I'm not sure what else it could be.

Anyone else run into this? Any advice?

[Jaspal Singh]

Hi,

Can you impersonate any of those non-admin users & type sc_req_item.LIST from application navigator & then check if there are or there aren't any records. If you get security constraints error then ACL of type read for sc_req_item table needs to be modified so as to make the fields visible.

Thanks,

Jaspal Singh

Hit Helpful or Correct on the impact of response.

[LikeARabbit]

Thanks for the reply Jaspal! When I impersonate a non-admin and view the list for sc_req_item I am able to see all of the expected fields, including Item, without issue. It looks the same as the list when I view it from my admin login.

[Prateek kumar]

Can you apply the same filter for both admins and non-admins and validate if the issue happens.

For non-admins you are viewing all catalog tasks but for admins you have a filter

[LikeARabbit]

Thanks for the reply Prateek! I've gone to the basic list view of sc_task with both an admin and an impersonated standard ITIL user and have the same result.

Screenshot shows the ITIL user on the left, my admin view on the right.