Get SQL query Zoya Pasha  2017-11-03 02:54
Status: Closed
 
I wish to get the complete SQL query defined in the query browser. The LABKEY.Query.getQueryDetails method gives information about the query, however, it does not fetch the query text as such. Is there a way to do so? Also, is there a way to add/edit/control the queries from a wiki page?
 
 
Jon (LabKey DevOps) responded:  2017-11-03 17:10
Hi Zoya,

I'm not understanding your question.

Is there any reason why you cannot just use the Schema Browser built into LabKey to view your LabKey SQL? What is the purpose of having to extract that information into a wiki?

Regards,

Jon
 
Zoya Pasha responded:  2017-11-04 03:56
Hi Jon,

I wish to get the SQL query as a text on a wiki page I create as I want to add a few things to it in the wiki page itself. I do not wish to pass the control over to the schema browser.

Thanks in advance,
Zoya
 
Jon (LabKey DevOps) responded:  2017-11-04 20:38
Hi Zoya,

I'll get this confirmed, but I do not believe this is possible via our Javascript API structure. Since the ability to view the LabKey SQL requires the query module, there would need to be significant code changes to the query module to allow this to occur.

Regards,

Jon
 
Zoya Pasha responded:  2017-11-05 20:56
Thank you Jon
 
Jon (LabKey DevOps) responded:  2017-11-06 00:13
Hi Zoya,

I've confirmed that the existing client-side APIs do not have this capability to expose the SQL that is normally accessed via the Schema Browser. It is possible to have the code in the wiki to call on the Internal API that the Schema Browser uses to access the SQL. You should be able to see the requests within a debugger like the Google Chrome debugger while the Schema Browser is running to get some insight.

However, this is not supported by LabKey, so you would need to work with the source code on your own to determine how to accomplish this.

Regards,

Jon
 
Zoya Pasha responded:  2017-11-06 22:06
Thank you!!