Which DB table can provide SQL query for certain report?

Steven Sun shared this question ago

Answered

Hi Team,

May I if there is a database table from backend which can provide the SQL query of each report?

Thanks and Regards

Replies (3)

Steven Sun ●

Hi Simon,

Thank you for the prompt response!

I think I can locate the SQL now in the backend.

May I know why for some report, there is no SQL tab of the information module? I attached one example.

which kind of report I cannot check the SQL from Yellowfin frontend?

Thanks and regards

Files:

Reply URL

Steven Sun ●

Hi Simon,

Please confirm if my understanding is correct or not.

We can only get the SQL script of certain report after running it for at least once from frontend;

at backend, some reports were encrypted, that's why SQLtext shows null? If so, May I know how to encrypt the report SQL?

Thank you!

Reply URL

Steven Sun ●

Hi Simon,

I think I'm clear with this part now, much appreciate your patient explanation?

Please leave this topic as closed.

Regards

Reply URL