How to Generate Report Using HQL or Java

Which IIQ version are you inquiring about?

Version 8.3

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

I have two different application links in my Identities. I want to compare two link attributes generate report to show only three columns in that report name and if its match the both the link attributes show true if it is not matching link attributes show unmatched attributes and its values.
is this possible to do HQL or Java Type Report any ideas or suggestions helpful

Thanks in advance!

You can easily do this with my JDBC Reporting library. It would let you write this query as SQL, which would be trivial. If you need help writing the query, let me know.

hey @laxman6 how are you?

I would use the standart “taskDefinition” reporting style for queryin information on IIQ.

You can use QueryOptions and also have a more dymaninc approach than just Plain SQL in the database. Also with the correct implementation you can use the buyiltin SP features like email , pdf or csv.

If you want i can provide you with examples.

Let me know!

Can you Please explain clearly what are the input parameters to be selected in your report and What are the output parameters and a detailed requirement so that we can suggest the best approach and how to implement the same.