Jump to content

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

Kunal Kavthekar

Recommended Posts

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


Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...