Hej,
I’m facing an issue when trying to retrieve values using an SQL query inside the Get Alternative Report hook.
The report has multiple variants, and based on a business requirement, I need to dynamically select a specific report variant within this hook. However, the SQL query does not return any data from the report reference table when executed in Get Alternative Report.
The same SQL query works correctly when used in calculated fields
Could you please confirm whether executing SQL queries is supported in the Get Alternative Report hook?
If there are any limitations or recommended alternatives for this use case, I’d appreciate your guidance.
Thank you in advance for your help.
Mulugeta
