getRecordListForTableWithQuery

Retrieve a list of records for a specific item type and use a JSON query to limit the results. A SOAP error envelope is returned if the operation fails.

Parameters

Parameter	Type	Description
cookie	long	Session cookie returned by projectLogon.
tablename	string	Table name to retrieve information from. Valid values: Defect, Test Case, Test Run, Requirement, and Requirement Document. Use getTableList to retrieve a list of available tables.
filtername	string	Filter name to apply to the results. Set as an empty string to use no filter. Use getFilterListForTable to retrieve a list of filters for the table. Interactive filters are not supported.
query	string	JSON query string with restrictions to filter the results. See Creating and validating JSON queries for the getRecordListForTableWithQuery operation.
columnlist	CTableColumn[]	List of columns in the table to retrieve information from. Limits the returned data to specific columns and you can apply a filter. Use the "Record ID" column name (case sensitive) to retrieve the record ID for a list of items.

Return value

Value	Type
recordlist	CRecordListSoap

Example

string[] columnNames = {"Number", "Status", "Summary"};

 

CTableColumn[] columns = new CTableColumn[columnNames.Length];

 

for (int x = 0; x < columns.Length; x++)

{

}

 

string query = "{'Type': ['Crash - Data Loss', 'Crash - No Data Loss']}";

CRecordListSoap recList = ttsdk. getRecordListForTableWithQuery(cookie, "Defect", "", query, columns);