Hello everyone, I'm working with SOAP API V4.0 and trying to retrieve some TestCases with the specified CustomProperty (Integer, named "xls_row"). Here is my code (C#) : RemoteFilter[] filter = { new RemoteFilter() }; filter[0].PropertyName = "xls_row"; filter[0].IntValue = 46; RemoteTestCase[] casesFound = spiraImportExport.TestCase_Retrieve(filter, 1, 2); But, surprisingly, the RemoteFilter does not work as expected. Even the function TestCase_Retrive(...) from which I expected the return as an array with the maximal length = 2 does not work as it described in documentation (https://www.inflectra.com/SpiraDemo/Services/v4_0/ImportExport.aspx?operation=TestCase_Retrieve). It returns the array with the length 172 (it is the same in case if the RemoteFilter parameter is null). Is there any way to retrieve TestCases filtered by the value of some CustomProperty? And why I get 172 rows when it was only 2 required by the parameter? Thank you in advance. Maxim. en-US(C) Copyright 2006-2026 Inflectra Corporation.support@inflectra.com/Computers/Software/Project_Management//Computers/Software/Quality_Assurance/KronoDesksupport@inflectra.comhttp://www.inflectra.com/kronodesk/forums/threads120/Support/Forum/spiratest/issues-questions/1500.aspxthreadId=1500Maxim Baryshnikov (maxim.baryshnikov@siemens.com)filtering api Hello everyone, I'm working with SOAP API V4.0 and trying to retrieve some TestCases with the specified CustomProperty (Integer, named "xls_row"). Here is my code (C#) : RemoteFilter[] filter = { new RemoteFilter() }; filter[0].PropertyName = "xls_row"; filter[0].IntValue = 46; RemoteTestCase[] casesFound = spiraImportExport.TestCase_Retrieve(filter, 1, 2); But, surprisingly, the RemoteFilter does not work as expected. Even the function TestCase_Retrive(...) from which I expected the return as an array with the maximal length = 2 does not work as it described in documentation (https://www.inflectra.com/SpiraDemo/Services/v4_0/ImportExport.aspx?operation=TestCase_Retrieve). It returns the array with the length 172 (it is the same in case if the RemoteFilter parameter is null). Is there any way to retrieve TestCases filtered by the value of some CustomProperty? And why I get 172 rows when it was only 2 required by the parameter? Thank you in advance. Maxim. Mon, 18 Jul 2016 11:15:54 -04002016-07-18T14:04:22-04:00/Support/Forum/spiratest/issues-questions/1500.aspxmessageId=2695Maxim Baryshnikov (maxim.baryshnikov@siemens.com) OK, I found some "nasty" workaround to retrieve TestCase with CustomProperty named 'propertyName' and has the value 'propertyValue': int rowsCount = (int) spiraImportExport.TestCase_Count(null); var casesFound = spiraImportExport.TestCase_Retrieve(null, 1, rowsCount); var casesExceptFolders = casesFound.Where( somecase => !somecase.Folder ); var caseWithRequiredID = casesExceptFolders.Where( somecase => somecase.CustomProperties.Any( property => property.Definition.Name == propertyName && property.IntegerValue == propertyValue ) ); But, I'm still wondering if there is some tool in SOAP API for that... Also, it seems that the TestCase_Retrieve(..) always returns all TestCase folders in the project, am I right? Mon, 18 Jul 2016 14:04:22 -04002016-07-18T14:04:22-04:00/Support/Forum/spiratest/issues-questions/1500.aspx#reply2695