Hi , Can someone please help to convert Sql query to HQL. Below is the sql Query. I want to use this to custom report select i.upi,i.account_name,b.display_name as [Business Role Name], (select name from identityiq.spt_bundle where id =br.child) AS [IT Role Name] from identityiq.spt_identity_entit…

Hi @poison001 , SELECT i.upi, i.accountName, b.displayName AS businessRoleName, (SELECT childBundle.name FROM Bundle childBundle WHERE childBundle.id = br.child.id) AS itRoleName FROM IdentityEntitlement ie LEFT JOIN ie.bundle b LEFT JOIN b.bundleRequirements br JOIN ie.identity i WHERE b.nam…

select i.upi,i.account_name,b.display_name as [Business Role Name] from identityiq.spt_identity_entitlement ie LEFT JOIN identityiq.spt_bundle b on ie.value = b.name LEFT JOIN identityiq.spt_bundle_requirements br on b.id=br.bundle JOIN identityiq.spt_identity i on ie.identity_id = i.id where b…

<?xml version='1.0' encoding='UTF-8'?> <!DOCTYPE TaskDefinition PUBLIC "sailpoint.dtd" "sailpoint.dtd"> <TaskDefinition executor="sailpoint.reporting.LiveReportExecutor" name="Identity Status Selected by Application" progressMode="Percentage" resultAction="Delete" subType="Extended Reports" template…

Thank you @vinnysail - This helped me

Hello @vinnysail this plugin can be used with SailPoint IdentityIQ versions 8.3, 8.4, and 8.5?

Thanks for your reply. If the query is resolved please mark the query with solution !!

SQL conversion to HQL for custom report

IdentityIQ (IIQ) IIQ Discussion and Questions

vinnysail (vinod kumar maram) July 20, 2025, 8:04am 5

Hi @poison001
you can try this open source plugin - see if helps - IDW SailPoint IIQ Query Plugin - Instrumental Identity

SQL to HQL Conversion for Report

Topic		Replies	Views
SQL to HQL Conversion for Report IIQ Discussion and Questions identityiq , reports	6	108	December 30, 2025
Custom Report not working ( SQL query is working but when tried in report it is throwing syntax error) IIQ Discussion and Questions identityiq , entitlements	5	101	March 3, 2025
Getting error when create custom report in HQL query IIQ Discussion and Questions identityiq , reports	4	193	September 17, 2024
Creating a Custom Report With HQL IIQ Discussion and Questions identityiq , reports	5	274	November 23, 2024
Table in Custom Report HQL IIQ Discussion and Questions identityiq , reports	3	129	March 17, 2025

SQL conversion to HQL for custom report

Related topics