History > List in the Location table not showing any values for other than admin

[DNC]

Hi All 

We have added History > LIST to the location table recently. (see the screen shot in Location 3)

as shown in the 'Location 1' screenshot, the LIST is available for all the ITIL users.

But if we click the LIST from the ITIL users, it is showing some error "Number of rows removed from this list by Security constraints: 300" as shown in the "Location 2" screenshot.

For ADMIN, Data is available correctly.

can you let me know, how I can make it available to all?

[Rameswar1]

Hello Nagarjuna, Good Day!

The ITIL users do not have access to the 'sys_history_set' table records, hence that error message.

You can try the below system property and add the ITIL role to check if they get access to this:

In the property named 'List of roles (comma-separated) that can access the history of a record', (property name: glide.history.role) enter the user roles you want to access history; in this case the ITIL role.





Here is the link with more info: Control access to history


Hope this helps, Thanks!

[DNC]

Hi Rameswar

Already it is updated with the ITIL role.

other than the location table, all tables History >> LIST is available for all the ITIL users.

[DNC]

Hi Rameswar

 Thanks for your quick response.

Already it is updated with the ITIL role.

other than the location table, all tables History >> LIST is available for all the ITIL users.

[Muhammad Khan]

Hi Nagarjuna,

Create a read ACL on sys_history_set table as follows;

Hopefully this will resolve your query.