My automated BPT test cases use the iteration functionality. After testing I have an Excel report that tells me which test cases are not at the all iteration settings:

SELECT DISTINCT TEST.TS_TEST_ID, TEST.TS_NAME,TEST.TS_RESPONSIBLE, BC_RUNFROM_ITERATION, BC_RUNTO_ITERATION
FROM BPTEST_TO_COMPONENTS join
Test on BC_BPT_ID=TEST.TS_TEST_ID
where BC_RUNFROM_ITERATION <> -1 or BC_RUNTO_ITERATION <> -1
ORDER BY TEST.TS_NAME

This produces a large list. I would like to create a customized button that I can click in HPQC that would run an SQL to set the BC_RUNFROM_ITERATION and BC_RUNTO_ITERATION to -1 before regression testing starts. Is this something I can do? Is it too dangerous to perform something like this using SQL calls? Is there a better way of doing this?

Thanks – Judy