Skip to main content
A
akr1-Visitor
1-Visitor
March 24, 2015
Question

"View as SQL" disabled under query builder

  • March 24, 2015
  • 3 replies
  • 3065 views


Hello All,

I need to generate SQL statements for some existing QML's. For some of QML reports "View as SQL" option is disabled. "View as SQL" is working for OOTB QML files and few custom QML's where limited # of tables used in join.

Is there any constraint on query size to generat SQL statements?

Thanks,

Ashwini

3 replies

B
BenPerry15-Moonstone
15-Moonstone
March 24, 2015

I generally see this after introducing soft types into the query. Is that what is happening in your situation? There are queries that the UI tool can handle, but SQL cannot. Another example is querying user information. Some is stored in the DB, but most is stored in the LDAP. So the UI tool can handle that interaction whereas straight SQL cannot.

A
akr1-VisitorAuthor
1-Visitor
March 26, 2015

Thanks for your reponse Ben. Yes I have used soft types in the query.. Is there any alternative to generate SQL command for this type of QML's.

B
BenPerry15-Moonstone
15-Moonstone
March 26, 2015

I don't think there is a work-around. I have asked PTC tech support a few times. It is just not possible generally, for multiple reasons.

MarcoTosin
MarcoTosin21-Topaz I
21-Topaz I
March 26, 2015

Maybe you can vote up this idea Possibility to load SQL statements in Query Builder Report in Windchill PDMLink

Marco
    L
    LoriSood23-Emerald II
    23-Emerald II
    April 4, 2015

    As a last resort you can always enable wt.pom.stacktrace logging to get the SQL queries run when a report is executed. However, this will output A LOT of query information and is cumbersome to go through. A possible reason for the SQL query not being generated is due to multiple queries having to be run and potential Info*Engine tasks having to be executed in order to get the data for the report.

    Terms & ConditionsAccessibility statement