Check Users defined in Business Rules

0

Hi all,

I'm implementing an application for user management taking the guide done by Webcon: https://community.webcon.com/posts/post/checking-user-and-group-privileges/258/3

So far, I'm able to check Applications and Processes privileges but when it comes to the Business Rules, I get an error for the column they use as Users (users . BRD_Users) :

select users . BRD_ID
, isnull ( DEF_Name, '<Global>' ) as DEF_Name
, usage. BRD_Name
, usage. BRD_Documentation
from WFBusinessRuleDefinitions as users
join WFBusinessRuleDefinitions as usage on usage . BRD_ID = users . BRD_BRDID
left join WFDefinitions on DEF_ID = usage . BRD_DEFID
where dbo . ClearWFElemIDAdv ( users . BRD_Users ) like '% {formFieldID}%'
and users. BRD_ReturnedValueType = 5
and users. BRD_IsLocal = 1

If I comment all those where conditions, I don't have any value for the User part neither in the WFBusinessRuleDefinitions in the column people (which I'm assuming that is the one saving the user info).

Does anyone tried to configure something like this?

Thank you