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.