Thread

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

VBA SOAP Remote Filter with Requirement_Retrieve function RSS Feed

Tuesday, January 26, 2016
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=""http://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
Sarah T.Sarah T.
re: Dany Courbron-Bouchard on Tuesday, January 26, 2016
Friday, January 29, 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
Tagged
Statistics
  • Started: 1/26/2016
  • Last Reply: 1/29/2016
  • Replies: 1
  • Views: 126
Powered by KronoDesk v1.1.0.15 | © Copyright Inflectra Corporation 2011-2016 | Licensed to Inflectra Corporation.