Votes
Answers
Views
Question
12
votes
2
answers
40
views
Hi there, I need to generate excel report from dashboard in QC that shows all test instances under certain folder. For example, I set a parameter in excel report like Root\\Testing\\Claims and report generate the list of all test instances in folder 'Claims' and all subfolders. Thanks!
0
votes
1
answer
63
views
How would I write an sql to test a list of the tests in the test plan including the whole folder structure and in the order I see in the test plan module?
7
votes
1
answer
67
views
asked 12 years ago by derlweldon
updated 12 years ago by sammyh
Does anyone have a SQL to list requirements including the Parent/Child relationships? Thanks in Advance. DW
0
votes
0
answers
27
views
Be first to answer!
asked 13 years ago by qctester2
Help, I need a query to calculate the numbers of days it took for a defect to go from 'Open' status to 'Ready to Test' status.
7
votes
1
answer
23
views
asked 13 years ago by tlstockton
updated 13 years ago by sammyh
We are getting ready for a scheduled network outage. Our organization does not have an exchange group defined for Quality Center users. I know how to email all the connected users, that is not what I am looking for. We need a method to email all Quality Center users across all projects to inform the...
0
votes
1
answer
16
views
How can you Query SQL on QC 10 to determine when a QC account is created? We are trying to determine how many users have been added to Quality Center after a specific date. Do you have any suggestions? **Thanks.**
6
votes
2
answers
130
views
asked 13 years ago by tlstockton
updated 13 years ago by sammyh
Need a SQL to see when users connect by project
1
vote
1
answer
334
views
Hi All, I am trying to pass a path to the folder in Test Lab as a parameter in SQL query, for example @path@='ST\\Automation\\Cycle1\\Auto\\BankService\\Release2'. What I need is a CF_ITEM_PATH of the last folder in this path. I need to do it only using SQL query in QC. Thank You
0
votes
2
answers
34
views
Hi All, I understood that for generating reports and troubleshooting in QC we can use SQL queries from backend of the QC 10.0. Please guide me through any any tutorial websites,cookbook's or workbook's which will explain how to write queries for different scenarios on the QC 10.0. I have downloaded ...