IdentityIQ Custom Report Results are different between "Save and Preview" and "Save and Execute"

IdentityIQ (IIQ) IIQ Discussion and Questions
,
1

Which IIQ version are you inquiring about?

8.4p2

Share all details about your problem, including any error messages you may have received.

We have written a custom report which utilizes a HQL Data Source, when the report is executed using the “Save and Preview” feature, the results produced match our expected report results, at least in terms of the count of records. When the very same report, with the very same filters is run with “Save And Execute” the number of results is significantly less than when run with Save and Preview. I’ve also run the HQL via the IQ console, and the list of results returned matches our expected results.

The query isn’t all the complex, below is the HQL provided in the report. Basically joining the IdentityEntitlements to ManagedAttributes and Classifications.

from IdentityEntitlement ie left join ManagedAttribute ma on ma.value = ie.value and ma.application.id = ie.application.id and ma.attribute = ie.name left join ObjectClassification oc on oc.ownerId = ma.id and oc.ownerType = ‘ManagedAttribute’ left join Classification cls on cls.id = oc.classification where ie.application.id in(‘0aa444168cf11b63818cf10cf185005f’)

2

I’ve figured out the issue here, it seems that although a certain HQL query may be used that lists inner joins or left joins, that when a column config “chains” properties together (i.e. ie.identity.manager.name) that the column config is introducing new INNER joins. I’ve had to enhance the HQL to make is so that I do not need to chain items that may require outer joins in the column configs.

3

Hi @kevinwoodbury,

its not a issue, its the normal behavior.

“Save and Preview“ generates a Preview where you can see the results before the execution. IIQ doesnt generate all results, only a part. You can use it to check if the reports works or to check the columns, etc….

1 Like
4

@kevinwoodbury Preview provides limited information from the result. It is a subset of the entire data that SailPoint identifies.