Can you use With clause in SQL queries within ALM?

  • Questions
  • Can you use With clause in SQL queries within ALM?
Question ID: 107355
1
0

Is it possible to use SQL With clause in ALM queries? I was attempting to use it to create a temp table so I could use that temp table to store results for other reports. However the result does not work in ALM. It can work in SQL Management Studio but that does not help me with my reports via the ALM UI.

Marked as spam
Posted by (Questions: 26, Answers: 22)
Asked on January 20, 2017 3:52 pm
4 views
Answers (1)
1
Private answer

Hello,

ALM does not support adding temporary tables from within the UI. This is due to the belief that such actions can create future issues for projects (upgrades, patches). It is also worth advising that there is currently no technical document from HPE that mentions manipulating a database schema from ALM as being a supported action or actions.

Best then to avoid any SQL query actions/commands/clauses that would result in any attempts at creating temp tables for your reports and such within the ALM application.

Marked as spam
Posted by (Questions: 1, Answers: 116)
Answered on January 20, 2017 3:55 pm
I kind of figured that would be the case. I will let that idea go then.
( at January 20, 2017 3:57 pm)