Hi, I am writting custom report and right now I have situation like this: if you have Business Role 1 with required: IT Role 1 and IT Role 2, permitted: IT Role 3, my report will show me in one row: Business Role | Required IT Roles | Permitted IT Roles Business Role 1 | IT Role 1, IT Role 2 | IT…

No, you cannot do this with either a Filter or HQL report type. It would be straightforward to do the three-column version in HQL (just do a join on Bundle.requirements and Bundle.permits), but the reporting engine doesn’t support HQL “UNION” queries. At best, you’d have a report that looks like …

@drosenbauer could you help me improve my code to get the report you mentioned?

Hi Alexandra, Please look at your other related thread: [image] Report from rule IIQ Discussion and Questions Hi Alexandra, Hereby the report class file: BusinessRoleReport.class (9.0 KB) Save this file to the following location: <IIQ Root Folder>/WEB-INF/classes/nl/…

Hi @Remold , Could you please share the Java Code for this report. I have a similar requirement. So, it will be helpful. Thanks

Custom Report about Roles

IdentityIQ (IIQ) IIQ Discussion and Questions

Remold (Remold Krol) November 16, 2023, 6:21pm 8

Hi @bellamkonda_vb,

The report is now shared in the tools community tools:
IIQ Business Role Report

Here you can find the link to the git-repository which holds the source file of the report.

– Remold

Topic		Replies	Views
IIQ Business Role Report Community Tools identityiq , community-developed	3	936	June 2, 2025
Report from rule IIQ Discussion and Questions rules , identityiq , roles , reports	13	1468	November 23, 2023
Business Roles Custom Report IIQ Discussion and Questions reports	5	1204	May 5, 2023
Custom Report find if Business role have IT role IIQ Discussion and Questions rules , identityiq	8	171	August 27, 2025
How to get Business Role to entitlement mapping in CSV, in IIQ 8.1 IIQ Discussion and Questions roles , reports	3	1024	May 26, 2023

Custom Report about Roles

Related topics