Table in Custom Report HQL

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?

Hi @bash7,

you can find the reference on Object Model file.

PS Into the report you cant use Select statment, the query starts from FROM word

Thanks Emanuele will have a look