Deep Patel: January 2013

Monday, January 21, 2013

QC OTA code for getting Bug/Defect History

Get all the required history details of a Defect/Bug in QC using the OTA apis.

Use the below code to access the history of a defect

Dim BugFactory, BugList
Set BugFactory = QCConnection.BugFactory  
Set bugFilter = BugFactory.FilterSet BugList = bugFilter.NewList
Set Bug = BugList(0) 'gives the first bug in bug list

Set hst = Bug.history
Set hstList = hst.NewList("")
For j = 1 To hstList.Count
                Set hstRec = hstList.Item(j)
                HTMLMSg_Content = HTMLMSg_Content & " " & hstRec.FieldName
                HTMLMSg_Content = HTMLMSg_Content & "
"
                HTMLMSg_Content = HTMLMSg_Content & hstRec.ChangeDate & "
"
                HTMLMSg_Content = HTMLMSg_Content & "" & hstRec.NewValue & "
" 'Target Test Date
Next j


To get specific items from the list use if conditions as below:

Set hst = Bug.history
Set hstList = hst.NewList("")
For j = 1 To hstList.Count
                Set hstRec = hstList.Item(j)
                If hstRec.FieldName = "BG_STATUS" And hstRec.NewValue = "Ready to Test" Then
                                'HTMLMSg_Content = HTMLMSg_Content & " " & hstRec.FieldName
                                'HTMLMSg_Content = HTMLMSg_Content & "
"
                                HTMLMSg_Table2 = HTMLMSg_Table2 & "" & hstRec.ChangeDate & ""
                                'HTMLMSg_Content = HTMLMSg_Content & hstRec.ChangeDate & "
"
                                'HTMLMSg_Content = HTMLMSg_Content & "" & hstRec.NewValue & "
" 'Target Test Date
                                Exit For
                 End If
Next j

Friday, January 18, 2013

Zindagi Na Milegi Dobara - Imraan's Poems

Poem 1 - after scuba diving.

Pighlay neelam sa behta hua yeh samaan
Neeli neeli si khamoshiyaan
Na kahin hai zameen
Na kahin aasmaan
Sarsaraati huyi tehniyaan, pattiyaan
Keh rahi hain ki bas ek tum ho yahaan
Sirf main hoon meri saansein hain aur meri dhadkanein
Aisi gehraiyaan
Aisi tanhaiyaan
Aur main sirf main
Apne honay pe mujhko yaqeen aa gaya


Poem 2 - after tamatina festival(leaving Laila).

Ik baat honton tak hai jo aayi nahin
Bas ankhon say hai jhaankti
Tumse kabhi, mujhse kabhi
Kuch lafz hain woh maangti
Jinko pehanke honton tak aa jaaye woh
…Aawaaz ki baahon mein baahein daalke ithlaye woh
Lekin jo yeh ik baat hai
Ahsas hi ahsas hai
Khushboo si hai jaise hawa mein tairti
Khushboo jo be-aawaaz hai
Jiska pata tumko bhi hai
Jiski khabar mujhko bhi hai
Duniya se bhi chupta nahin
Yeh jaane kaisa raaz hai

Poem 3- After Imran meets his father, Salman Habib

Jab jab dard ka baadal chaya
Jab ghum ka saya lehraya
Jab aansoo palkon tak aya
Jab yeh tanha dil ghabraya
Humne dil ko yeh samjhaya
…Dil aakhir tu kyun rota hai
Duniya mein yunhi hota hai
Yeh jo gehre sannate hain
Waqt ne sabko hi baante hain
Thoda ghum hai sabka qissa
Thodi dhoop hai sabka hissa
Aankh teri bekaar hi nam hai
Har pal ek naya mausam hai
Kyun tu aise pal khota hai
Dil aakhir tu kyun rota hai

Poem 4- Ending. 

Dilon mein tum apni
Betaabiyan leke chal rahe ho
Toh zinda ho tum
Nazar mein khwabon ki
Bijliyan leke chal rahe ho
Toh zinda ho tum
Hawa ke jhokon ke jaise
Aazad rehno sikho
Tum ek dariya ke jaise
Lehron mein behna sikho
Har ek lamhe se tum milo
Khole apni bhaayein
Har ek pal ek naya samha
Dekhen yeh nigahaein
Jo apni aankhon mein
Hairaniyan leke chal rahe ho
Toh zinda ho tum
Dilon mein tum apni
Betaabiyan leke chal rahe ho
Toh zinda ho tum