Sign-up our Newsletter  Register on our LinkedIn  Follow us on Twitter  Check out our Facebook  Follow us on Google+
Follow

Search based on "Ready for automated run" or "Ready for manual run" flags

The "Ready for automated run" or "Ready for manual run" flags are not yet available in the Search feature. It currently mostly rely on custom fields search.

 

This is something we probably have to add.

 However, you can use a SQL report to find what you need.

  

2 SQL query example:

SELECT DISTINCT CONCAT('[T_', table_test.test_id, ']') AS Test_Id,
test_name AS Test_Name,
CONCAT('[TC_', table_case.case_id, ']') AS Testcase_Id,
testcase_name AS Testcase_Name
FROM table_test, table_case
WHERE table_test.test_id=table_case.test_id
AND testcase_dev_completed=1

 

and

SELECT DISTINCT CONCAT('[T_', table_test.test_id, ']') AS Test_Id,
test_name AS Test_Name
FROM table_test, table_case
WHERE table_test.test_id=table_case.test_id
AND testcase_dev_completed=1

 You just need to go to the SQL Report module and create the query and execute it.

 

 

You will also be able to export the list to Excel if you need.

 

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.