Votes
Answers
Views
Question
2
1
173
I could use some help with a database query problem I'm having. The query I'm setting up is intended to generate an Excel report on the current status of a test cycle. Some history on this is that we setup our testing structure such that we keep the same folder structure in Test Lab and just assign ...
0
1
139
asked 8 years ago by prathap7475
updated 8 years ago by tclasp
Need a SQL query or any other ways to know the newly created projects in ALM in a specified month. please help me on my question.
6
2
130
asked 13 years ago by tlstockton
updated 13 years ago by sammyh
Need a SQL to see when users connect by project
1
1
121
Hello, Could you tell me what versions of ALM currently support MS SQL 2019, if any? If none when will it be supported? Thanks, HomerJ
1
3
106
asked 9 years ago by proskier
updated 9 years ago by Captain Mercury
I would like to select, not just the 'CYCL_FOLD.CF_FATHER_ID' id, but its name. SELECT RUN.RN_RUN_ID, RUN.RN_EXECUTION_DATE, RUN.RN_EXECUTION_TIME, RUN.RN_PC_VUSERS_INVOLVED, RUN.RN_DURATION, --RUN.RN_CYCLE_ID, CYCLE.CY_FOLDER_ID, CYCLE.CY_CYCLE, CYCL_FOLD.CF_ITEM_NAME, --the folders name CYCL_FOLD....
0
0
88
Be first to answer!
asked 8 years ago by scott-zillitto
When Legacy Excel Reports were enabled in ALM 11.00, I was able to create Test Plan and Test Lab reports with a column for the hierarchical folder tree path, so I could then sort the results by folder path. I Googled around and found that DQL is mostly ASNI SQL 9.2 (http://alm-help.saas.hpe.com/en/1...
0
1
83
asked 15 years ago by young-steve
updated 15 years ago by young-steve
We have just recently upgraded to SQL Server 2008 and found that there is no 'open table' option in the right click menu. This was handy for quick database edits and changes. This option has now been replaced by "select top 200 rows" and "select top 1000 rows". This is inconvenient i...
0
1
80
asked 7 years ago by neena
updated 7 years ago by bubblehead712
How can I capture a value from the XML returned, then run a SQL query against my database and compare the fields in the database record to expected results. Would I use the database functions in API testing?
0
2
80
asked 8 years ago by prathap7475
updated 8 years ago by prathap7475
SQL query to get least access project details in ALM and please help.