Question
Capgemini Norge AS
NO
Last activity: 20 Jan 2022 3:43 EST
Showing if a role/access group list is longer than x in report
I've got an application where an operator can have one or several roles, or belong to several access groups. In a report I want to show user information including whether they belong to one or more access groups. The access groups are stored in a value list, pyAccessGroupsAdditional in Data-Admin-Operator-ID, and in the report I want to be able to have a "Yes" to whether the user has several access groups or not. I've tried pxCaseWhenNULLInput\t[Check for NULL]\t[Return this if null] by checking if the list is null when the user has no additional access groups, but it's not and I can't find any other solution. Any suggestions is highly appreciated!
Updated: 19 Jan 2022 19:08 EST
Maantic Inc
US
option #1
select pylabel, count(pyaccessgroupadditional) from pegadata.pr_index_operators where pyaccessgroupadditional is not null group by pylabel;
option #2
by having above query create or update existing report in index-operator class
if the count is more than one, the operator tagged with more than one access group.
Ernst & Young LLP
MT
- Create a sub report on class Index-Operator to return user id (pyLabel) and unique count of pyAccessGroupAdditional.
- Create your report on Data-Admin-Operator-ID class where you need to join with this sub report on Subreport.pyLabel = .pyUserIdentifier. (pyLabel on Index table holds operator ID).
- Either write a Function alias or a HTML to convert Subreport.Count to Yes/No (I don't find any appropriate OOTB function alias or Control rule to use here)
Hope it helps.