Click HERE to see how Saviynt Intelligence is transforming the industry. |
08/26/2024 01:12 AM
Hi All,
While running a query in 'Intelligence' report Saviynt is throwing below error:
DataTables warning (table id = 'analyticsDetailsList'): Requested unknown parameter 'No. of users in group' from the data source for row 0
The same query is running fine in data analyzer and showing the records, the error is appearing only in intelligence report.
Query:
select "JDoeApplication" AS 'Application Name', ev.entitlement_value AS 'Group Name', COUNT(ae1.accountkey) AS 'No. of users in group' from account_entitlements1 ae1 right join entitlement_values ev on ae1.ENTITLEMENT_VALUEKEY=ev.ENTITLEMENT_VALUEKEY left join entitlement_types et on ev.ENTITLEMENTTYPEKEY=et.ENTITLEMENTTYPEKEY left join entitlement_owners eo on ev.ENTITLEMENT_VALUEKEY=eo.ENTITLEMENT_VALUEKEY left join users u on eo.userkey=u.userkey where et.endpointkey = 57 GROUP BY ev.entitlement_value
Appreciate any feedback or resolution. Please note all relevant data is present in Saviynt, and same query is running all good in Data analyzer.
To test change the '57' in et.endpointkey = 57 as per your data
Solved! Go to Solution.
08/26/2024 01:25 AM
Hi @varunakarnia just to check .. can you create a new report and see if it gives any error.
08/26/2024 01:42 AM
Hi @NM ,
Meaning with same query only?
08/26/2024 01:55 AM
@varunakarnia yes
08/26/2024 02:31 AM
Hi @varunakarnia can you just use 'Number of users' instead of 'No. of users in group' and check once?
Regards,
Indra
08/26/2024 03:15 AM
Hi @indra_hema_95 ,
It worked. Interesting, it seems the dot in 'No.' is treated as an operator rather than a string in backend.
Thank you
08/26/2024 03:29 AM
@varunakarnia correct.