Defect Dump using OTA

[qc_naive]

I have written OTA code for pulling the defect dump from HPQC . Code works when there is no space in defect status ( New, Open, Reopen etc ) but when there is a space ( 01-New, 02-Open , 03- Reopen), its not working. I included the double quotes because of which there is no issue in code but the values are retrieved as "0" . Can someone help me out ?

[Jan Czajkowski · Accepted solution]

Try replacing the double quotes with the corresponding ASCII value:

 Chr(34) & "03- Reopen" & Chr(34)

[qc_naive]

Thanks Jan . That worked perfectly well.

 Now i have another issue

BugFilter.Filter("BG_STATUS") = "NOT(12 - Closed or 09 - Deferred or 10 - Rejected )" .  Its not considering the defect status condition  and pulling the count of entire defects. Should i use anything else to do it ?

[Jan Czajkowski]

Try the same approach and add ASCII characters for quotation marks around the values that contain space characters.

[qc_naive]

Jan ,

I tried the following and its still not working . It is pulling everything (all defects count)

a= Chr(34) & "12 - Closed" & Chr(34)

b= Chr(34) & "09 - Deferred" & Chr(34)

c= Chr(34) & "10 - Rejected" & Chr(34)

BugFilter.Filter("BG_STATUS") = "NOT( a or b or c )"

[Jan Czajkowski]

Try putting it all in one line:

BugFilter.Filter("BG_STATUS") = "NOT (" &  Chr(34) & "12 - Closed" & Chr(34) & " OR " & Chr(34) & "09 - Deferred" & Chr(34)  & " OR " &  Chr(34) & "10 - Rejected" & Chr(34) & ")"

[Prachi_8]

Hi,

Can you please let me know how did you pull the defects .

Thanks

Prachi