Property used in Access control policy cant not be used in RD filter even though access when true
We have a requirement to mask few properties for certain users ,we have created access control policy & access control policy condition for masking .its working fine for the users which need masking of data ,but its not working for other users where the property used in policy condition is used as filter condition in report definition .Is it like even though the access when becomes true still the property can't be used in report filter
error :This property can be displayed, but it cannot be used to filter, sort, group, or rank query results, or in SQL functions.
Pegasystems Inc.
ES
@SmrutiS4 based on the SSA mission for 8.5, you can retrieve this property in a report and you can use as a filter but only with Is Equal and Is Not Equal comparisons. You cannot do any other things with it.
Hope this helps,
Iñigo.
Deloitte
IN
@VEIGIThank you for the response .
I used Is Equal in report filter ,still it gives error [MSG][An error occured during resolving the report definition - A ReadProperty access control policy is defined on property '.XYX'. This property can be displayed, but it cannot be used to filter, sort, group, or rank query results, or in SQL functions.][STACK][com.pega.pegarules.data.internal.rd.resolve.UserResolveReportException: A ReadProperty access control policy is defined on property '.XYZ'. This property can be displayed, but it cannot be used to filter, sort, group, or rank query results, or in SQL functions. at com.pega.pegarules.data.internal.rd.utils.ValidationUtils.throwPropertySecurityException(ValidationUtils.java:508) at
Pegasystems Inc.
ES
@SmrutiS4 what about if you remove from the filter? works?
Maybe you want to open an SR with PEGA Directly and they can help you with this.
Cheers,
Iñigo.