Skip Navigation LinksHome Page > Forums > SpiraTeam Forums > SpiraTeam Issues & Questi... > VBA SOAP Remote Filter wi...

VBA SOAP Remote Filter with Requirement_Retrieve function

Tuesday, January 26, 2016

danyCB

Hi,

I am trying to filter the response with the AuthorId and it seems that the filter doesn't work. I'm using many other spirateam Import/export functions and they are all working. Is there somtething different I should do?

"<soap:Envelope xmlns:xsi=""http://www.w3.org/2001/XMLSchema-instance"" xmlns:xsd=""http://www.w3.org/2001/XMLSchema"" xmlns:soap=""http://schemas.xmlsoap.org/soap/envelope/"">" & _

"<soap:Body>" & _

"<Requirement_Retrieve xmlns=""https://www.inflectra.com/SpiraTest/Services/v4.0/"">" & _

"<remoteFilters>" & _

"<RemoteFilter>" & _

"<PropertyName>" & "AuthorId" & "</PropertyName>" & _

"<StringValue>" & "14" & "</StringValue>" & _

"</RemoteFilter>" & _

"</remoteFilters>" & _

"<startingRow>" & 1 & "</startingRow>" & _

"<numberOfRows>" & 9999 & "</numberOfRows>" & _

"</Requirement_Retrieve>" & _

"</soap:Body>" & _

"</soap:Envelope>"

1 Replies

Friday, January 29, 2016

~~inflectra.sarahx~~

re: danyCB Tuesday, January 26, 2016

Hi Dany

Thanks for asking the question,

I believe the problem is that you are filtering using the 'StringValue' attribute, I would use the 'IntValue' instead:

"<RemoteFilter>" & _

"<PropertyName>" & "AuthorId" & "</PropertyName>" & _

"<IntValue>" & "14" & "</IntValue>" & _

"</RemoteFilter>" & _

Regards

Sarah

Spira Helps You Deliver Quality Software, Faster and With Lower Risk

And if you have any questions, please email or call us at +1 (202) 558-6885

Statistics

Started: Tuesday, January 26, 2016
Last Reply: Friday, January 29, 2016
Replies: 1
Views: 1458

VBA SOAP Remote Filter with Requirement_Retrieve function

Spira Helps You Deliver Quality Software, Faster and With Lower Risk

Edit Thread

Edit Message

Search Results