Identification of test suite iteration in the external Database
I've a question about External database use for reporting. I have a testsuite which is launched every night by 10 PM for ~5 hours. Results are logged in database correctly, but I have not found a way to identify (**differentiate**) each iteration of the test suite, in the database. In testreport table, I see that there is column called testgroup and another one called testsubgroup, but they are always empty. Have you any solution or idea to deal with that? Using iTest v. 4.2
Following scenario could help you to achieve your requirement. 1. I have created a command session test-case Main.fftc which runs under job new_job.ffjd. 2. Then I have passed the value to --group option in iTestRt command based on the time-stamp of new test-case Main.fftc which executes the test-suite under second_job.ffjd in iTestRt. The scenario is like this. new_job.ffjd->Main.fftc->which runs second_job.ffjd in rt(which has the test-suite). Please find the attached test-case and screen shot for your reference. ![alt text] [link text] : /storage/temp/3504-itestrt.png : /storage/temp/3505-main.fftc Please let me know how it goes.
I believe adding group value to the database is not available in iTest GUI.But we can do this using itestRT feature. Following are the steps to insert group value into test-report table.
1.In itestRT Run the test-suit by connecting to External database as shown in the screenshot.Which will create a **group my** in the reports table for all the test-cases under test-suit. itestrt --itar "c:\Users\PAXTERRA\Desktop" --licenseServer Xx.xx.xx.xx --dbtype MySQL --ipaddr localhost --catalog itestdb1 --trdb.user root --trdb.password ******* --group my --job project://my_project/testbeds/new_job.ffjd ![alt text] 2.Then issue a query in the database to fetch the reports under the group **my** as shown in the below screenshot. ![alt text] : /storage/temp/3501-itestrt.png : /storage/temp/3502-database.png Hope this will help you.