How can I turn JAQL query into a SQL query?
currently we are using JAQL to query data that we use to create some reports.. but now we want to get the same data by using SQL so I looking for a way to convert our JAQL queries into an equivalent ...
Forum Discussion
Hey asael,
If i am not mistaken there is an api that does exactly this. If you need to automate the process this could be the way.
If it is more a one of kind of thing , then you can edit the widget , hit the three dots and select sql query. It will give you the sql code
Hamza
Hi HamzaJ​
What is that API?
I was seeking for something like that but I have not found it..
Actually I am not using any widget of Sisense.. we just use the data that we get form our datasource using JAQL and with that data we create our report (the report is created by us- coding)... maybe in the future we could use some widgets but now we are trying is to convert the JAQL query into a SQL..
can you share to me the API name?
