Search code examples
vbahp-quality-centeralm

How to find test cases by name in QC using VBA

So i trying to find test cases by name in QC I can find test case by nodeID,Path etc. but not by name. What i am trying to do is Something like QC Menu->Edit->Find (Enter your test case name) Can this be done using OTA ?

Solution

  • Send a query using the TD connection object

    set oCommand=oTDC.Command
oCommand.CommandText="Select * from TEST where TS_NAME Like'testname'"
oRecordSet.Execute
Do until recordset.EOR=true
/Get your test case details
recordset.next
Loop