Query Data
Directly from Your IIQ Database
Learn Why Your IIQ Filters Behave the Way They Do and So Much More
About the Plugin
Test a SailPoint filter or HQL query before you used it in a role membership rule.
Learn why your IIQ Filters behave the way they do.
Filter String when you have a CompositeFilter XML, or vice versa.
The plugin provides an input area where you can enter a SQL script, an HQL query, or a SailPoint filter (in either Filter String or XML format).
The results can be further filtered dynamically in the table or exported to a CSV file for offline processing.
The Query Plugin can also invoke SailPoint’s Filter compilation classes to retrieve the HQL and SQL rendition of a Filter. This is commonly used for a few purposes:
- You can debug why certain Filters produce unintuitive results.
- You can also use the resulting SQL query to tune a common Filter by applying indexes to your tables.
- You can translate a Filter String directly to a CompositeFilter XML, which can be copied into the Role Membership screen or an XML artifact in your build. This is very useful in combination with Advanced Analytics.
The following screenshot shows the translation of a Filter on first name and department.
