Which IIQ version are you inquiring about?
[Replace this text with your version of IIQ. The more specific you can be (7.1, 8.3, 8.X), the more people can help. If you do not know, put Unsure.]
8.3
Please share any images or screenshots, if relevant.
[Please insert images here, otherwise delete this section]
Please share any other relevant files that may be required (for example, logs).
[Please insert files here, otherwise delete this section]
Share all details about your problem, including any error messages you may have received.
Here is the revised text and its translation in English:
Hello, I am currently developing custom reports.
I started with the Java datasource.
Currently, I have decided to continue with the HQL datasource.
However, I am facing a challenge:
Where can I find the tables and attributes?
For example, with the Java datasource, I know that the tables correspond to the schema of the database.
Here is an example of a query:
SELECT A.name AS applicationName, U.display_name AS userName
FROM identityiq.spt_application AS A
In this example, identityiq.spt_application
is in the database schema.
But for HQL,
the table would be Application
, as far as I understand.
So we would use FROM Application
instead of FROM identityiq.spt_application
.
Where can I find Application
?
If I want to use, for example, the table identityiq.spt_identity_assigned_roles
, where can I find this information in HQL?