Forum Discussion

Gaurav2507's avatar
Gaurav2507
Data Storage
02-21-2024

JAQL TO SQL QUERIES

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 ...
DRay's avatar
DRay
Admin
02-22-2024

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's avatar
Gaurav2507
Data Storage
02-23-2024

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's avatar
    DRay
    Admin
    03-04-2024

    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.