Highlighted
Visitor.
649 views

Defect Dump using OTA

Jump to solution

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 ?

0 Likes
1 Solution

Accepted Solutions
Highlighted
Acclaimed Contributor.
Acclaimed Contributor.

Re: Defect Dump using OTA

Jump to solution

Try replacing the double quotes with the corresponding ASCII value:

 

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

Jan Czajkowski

[Please do not contact me off line for receiving support. Use the forum!]

View solution in original post

0 Likes
6 Replies
Highlighted
Acclaimed Contributor.
Acclaimed Contributor.

Re: Defect Dump using OTA

Jump to solution

Try replacing the double quotes with the corresponding ASCII value:

 

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

Jan Czajkowski

[Please do not contact me off line for receiving support. Use the forum!]

View solution in original post

0 Likes
Highlighted
Visitor.

Re: Defect Dump using OTA

Jump to solution

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 ?

0 Likes
Highlighted
Acclaimed Contributor.
Acclaimed Contributor.

Re: Defect Dump using OTA

Jump to solution

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

Jan Czajkowski

[Please do not contact me off line for receiving support. Use the forum!]
0 Likes
Highlighted
Visitor.

Re: Defect Dump using OTA

Jump to solution

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 )"

0 Likes
Highlighted
Acclaimed Contributor.
Acclaimed Contributor.

Re: Defect Dump using OTA

Jump to solution

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) & ")"

Jan Czajkowski

[Please do not contact me off line for receiving support. Use the forum!]
0 Likes
Highlighted
Absent Member.
Absent Member.

Re: Defect Dump using OTA

Jump to solution

Hi,

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

 

Thanks

Prachi

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.