JAQL TO SQL QUERIES

[Gaurav2507]

Hi All,

We are using single deployment Sisense on v1 module . I need to pull widget JAQL TO SQL , but SQL Analyser is not available.

Please suggest ways to pull SQL queries based on JAQL of widget 

Thanks

[DRay]

Hello @Gaurav2507,

Thank you for your question! I'm happy to help.

What version of Sisense are you using? The reason I ask is you should be able to see the SQL query documented here.

[Gaurav2507]

Thanks DRay for your revert.

I got SQL query using prism.debugging.GetSql(prism.activeWidget).But query is with ids... Difficult to understand. Also is this query based on data source like SQL.

Thanks

[DRay]

Hi @Gaurav2507,

What version of Sisense are you using? The reason I ask is you should be able to see the SQL query documented here.