How to get the Spotfire generated SQL query used by a particular Information Link from Spotfire Library Database (metadata tables like Lib_*)

[Kunal Kavthekar]

Hi Team,

 

I am trying to write a SQL query/program to extract the SQL queries generated and used by Tibco Spotfire when creating a new information link via the Information Designer.

I want to get the queries that were auto-generated by Spotfire, possibly from the Library DB.

Currently, I am able to see the values stored for the query items (in the Lib_Data table) but the data does not contain the actual query

 

P.S. I tried this linkbut it only works if the query was modified, I wantto retrieve the queries that were auto-generated at the time of information link creation.

 

Thanks in advance

Kunal