

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
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 ?
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Try replacing the double quotes with the corresponding ASCII value:
Chr(34) & "03- Reopen" & Chr(34)
[Please do not contact me off line for receiving support. Use the forum!]

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Try replacing the double quotes with the corresponding ASCII value:
Chr(34) & "03- Reopen" & Chr(34)
[Please do not contact me off line for receiving support. Use the forum!]


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
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 ?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Try the same approach and add ASCII characters for quotation marks around the values that contain space characters.
[Please do not contact me off line for receiving support. Use the forum!]


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
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 )"

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
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) & ")"
[Please do not contact me off line for receiving support. Use the forum!]

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Hi,
Can you please let me know how did you pull the defects .
Thanks
Prachi