Resource: Search ( /api/search )
Search resource, used for retrieving the results of a TQL query.
Root Relation: Search
This resource supports the following methods: GET, POST
Methods
GET
Retrieves all (or a subset) of entities that are visible to the user. The search resource supports both standard and aggregate TQL query expressions. For long queries you can use the POST method instead.
This method supports the TQL query parameters tql, $top, $take and $inlinecount. See TQL Topic for more details.
Required Permissions
- TestManagement/View
Status Codes
These are the expected status codes returned by the service - in addition, some other status codes may be returned if either an internal error occurs or there is an authentication issue (such as an expired OAuth token).
Status | Description |
---|---|
200 - OK | Returned if the request was completed successfully. |
Searching for entities by TQL query.
Request Headers
Key | Value | Description |
---|---|---|
Accept | application/json |
Request Parameters
Key | Value | Description |
---|---|---|
tql | Name ~ 'test' | Search for all entities containing the word 'test'. |
Response Headers
Key | Value | Description |
---|---|---|
Content-Type | application/json; charset=utf-8 |
Response Body
Code Block | ||
---|---|---|
| ||
{ "Skip": 0, "Top": 1, "Total": 1, "Items": [ { "Id": "48adfe56-69a6-4832-b826-a004016a11e2", "Type": "Unit", "Name": "JUnit Test Results", "CreatedAt": "2012-02-27T08:58:15Z", "LastUpdatedAt": "2012-02-27T10:08:20Z", "CreatedById": "5b2b0ad0-5371-4abf-a661-9f410088925f", "CreatedBy": "Administrator", "LastUpdatedById": "5b2b0ad0-5371-4abf-a661-9f410088925f", "LastUpdatedBy": "Administrator", "PackageId": "d69ff488-5a76-4b8c-b604-9fde010719e1", "ProjectId": "2aa8fba4-8f0b-4c4b-a7ef-9fde010719de", "ProjectName": "Project X", "PackageName": "Script Library", "OrderNumber": 2, "Expands": [ "Assignments", "Configuration" ], "EntityType": "AutomatedTest", "Self": "http://localhost/EnterpriseTester/api/automatedtest/48adfe56-69a6-4832-b826-a004016a11e2" } } |
Status Code
200 - OK
Searching for entities by TQL query that includes dates, and pass in timezone for the query.
Request Headers
Key | Value | Description |
---|---|---|
Accept | application/json |
Request Parameters
Key | Value | Description |
---|---|---|
tql | CreatedAt >= 2012-02-1 | Search for all entities created on February 2012 and later. |
timeZone | America/New_York | Time zone used for date calculations. |
Response Headers
Key | Value | Description |
---|---|---|
Content-Type | application/json; charset=utf-8 |
Response Body
Code Block | ||
---|---|---|
| ||
{ "Skip": 0, "Top": 1, "Total": 1, "Items": [ { "Id": "48adfe56-69a6-4832-b826-a004016a11e2", "Type": "Unit", "Name": "JUnit Test Results", "CreatedAt": "2012-02-27T08:58:15Z", "LastUpdatedAt": "2012-02-27T10:08:20Z", "CreatedById": "5b2b0ad0-5371-4abf-a661-9f410088925f", "CreatedBy": "Administrator", "LastUpdatedById": "5b2b0ad0-5371-4abf-a661-9f410088925f", "LastUpdatedBy": "Administrator", "PackageId": "d69ff488-5a76-4b8c-b604-9fde010719e1", "ProjectId": "2aa8fba4-8f0b-4c4b-a7ef-9fde010719de", "ProjectName": "Project X", "PackageName": "Script Library", "OrderNumber": 2, "Expands": [ "Assignments", "Configuration" ], "EntityType": "AutomatedTest", "Self": "http://localhost/EnterpriseTester/api/automatedtest/48adfe56-69a6-4832-b826-a004016a11e2" } } |
Status Code
200 - OK
Searching for entities by TQL query (using different index) - Note: within the response the 'IndexName' is also included as a top-level property.
Request Headers
Key | Value | Description |
---|---|---|
Accept | application/json |
Request Parameters
Key | Value | Description |
---|---|---|
tql | Name ~ 'smoke' | Search for all entities containing the word 'smoke'. |
indexName | Run | Search using the Run index. |
Response Headers
Key | Value | Description |
---|---|---|
Content-Type | application/json; charset=utf-8 |
Response Body
Code Block | ||
---|---|---|
| ||
{ "Skip": 0, "Top": 1, "Total": 1, "Items": [ { "Id": "a2e642a5-bd5d-48e6-b67d-a153017a5272", "AssignedToId": null, "AssignedTo": null, "Description": null, "Name": "Smoke test integration with SAP", "Notes": null, "Number": 5, "Objective": null, "PostCondition": null, "PreCondition": null, "PriorityId": "8f8dc3ff-f98b-411c-9bd3-a14300fbebc0", "StatusId": "a15eb86a-ce86-42c7-9881-a14300fbebc4", "TypeId": "fa450444-cf62-4b1f-b9c4-a14300fbebc6", "SourceId": null, "SourceContainerId": null, "PackageId": "e4658145-e54d-4a11-8550-a14300fbebca", "OrderNumber": 0, "ProjectId": "8dfa0afa-25ee-4ce1-bc92-a14300fbebb2", "ProjectName": "Test", "PackageName": "Execution Sets", "EstimatedDuration": "", "ActualDuration": "", "ExecutionStatus": "Not Run", "AgileRunNumberReadOnly": true, "Expands": [ "FieldControls", "FieldValues", "Steps" ], "EntityType": "AgileRun", "Self": "http://localhost/EnterpriseTester/api/agilerun/a2e642a5-bd5d-48e6-b67d-a153017a5272", "Links": [ { "Href": "http://localhost/EnterpriseTester/api/agilerun/a2e642a5-bd5d-48e6-b67d-a153017a5272/relationships", "Rel": "Relationships" }, { "Href": "http://localhost/EnterpriseTester/api/agilerun/a2e642a5-bd5d-48e6-b67d-a153017a5272/allrelationships", "Rel": "AllRelationships" } ] }], "IndexName": "Run", "Self": "http://localhost:8092/EnterpriseTester/api/search?indexName=Run", "Links": [ { "Href": "http://localhost:8092/EnterpriseTester/api/search?indexName=Run&$skip=25&$top=25", "Rel": "next" }, { "Href": "http://localhost:8092/EnterpriseTester/api/search?indexName=Run&$skip=95&$top=25", "Rel": "last" } ] } } |
Status Code
200 - OK
Searching for entities by TQL query (format results flattened for grid).
Request Headers
Key | Value | Description |
---|---|---|
Accept | application/json |
Request Parameters
Key | Value | Description |
---|---|---|
tql | Name ~ 'test' | Search for all entities containing the word 'test'. |
format | grid | Format the results for rendering in a grid. |
Response Headers
Key | Value | Description |
---|---|---|
Content-Type | application/json; charset=utf-8 |
Response Body
Code Block | ||
---|---|---|
| ||
{ "Skip": 0, "Top": 1, "Total": 1, "Items": [ { "AssociatedRequirements": "", "Type": "Unit", "Name": "JUnit Test Results", "OrderNumber": 2, "Id": "48adfe56-69a6-4832-b826-a004016a11e2", "EntityType": "AutomatedTest", "Package": "Project X/Script Library", "CreatedAt": "2012-02-27T08:58:15Z", "LastUpdatedAt": "2012-02-27T10:08:20Z", "LastUpdatedBy": "Joe Bloggs (Administrator)", "CreatedBy": "Joe Bloggs (Administrator)", "EditLink": "#/automatedtest/edit/48adfe56-69a6-4832-b826-a004016a11e2", "PackageId": "d69ff488-5a76-4b8c-b604-9fde010719e1", "Project": "Project X", "ProjectId": "2aa8fba4-8f0b-4c4b-a7ef-9fde010719de" } }, |
Status Code
200 - OK
Searching for entities by TQL query (format results flattened for grid, with column metadata included in the results).
Request Headers
Key | Value | Description |
---|---|---|
Accept | application/json |
Request Parameters
Key | Value | Description |
---|---|---|
tql | Name ~ 'test' | Search for all entities containing the word 'test'. |
format | grid | Format the results for rendering in a grid. |
$expand | Columns | Returns the grid results with column metadata. |
Response Headers
Key | Value | Description |
---|---|---|
Content-Type | application/json; charset=utf-8 |
Response Body
Code Block | ||
---|---|---|
| ||
{ "Skip": 0, "Top": 1, "Total": 1, "Items": [ { "Columns": [ { "Sortable": true, "DefaultToHidden": false, "Header": "Entity Type", "Name": "EntityType", "Type": "string", "DefaultWidth": 100, "PreEncoded": false }, { "Sortable": true, "DefaultToHidden": false, "Header": "Package", "Name": "Package", "Type": "string", "DefaultWidth": 200, "PreEncoded": false }, { "Sortable": true, "DefaultToHidden": false, "Header": "Name", "Name": "Name", "Type": "string", "DefaultWidth": 50, "PreEncoded": false }, .... ], "AssociatedRequirements": "", "Type": "Unit", "Name": "JUnit Test Results", "OrderNumber": 2, "Id": "48adfe56-69a6-4832-b826-a004016a11e2", "EntityType": "AutomatedTest", "Package": "Project X/Script Library", "CreatedAt": "2012-02-27T08:58:15Z", "LastUpdatedAt": "2012-02-27T10:08:20Z", "LastUpdatedBy": "Joe Bloggs (Administrator)", "CreatedBy": "Joe Bloggs (Administrator)", "EditLink": "#/automatedtest/edit/48adfe56-69a6-4832-b826-a004016a11e2", "PackageId": "d69ff488-5a76-4b8c-b604-9fde010719e1", "Project": "Project X", "ProjectId": "2aa8fba4-8f0b-4c4b-a7ef-9fde010719de" } }, |
Status Code
200 - OK
Searching for entities by TQL query (format results flattened for grid).
Request Headers
Key | Value | Description |
---|---|---|
Accept | application/json |
Request Parameters
Key | Value | Description |
---|---|---|
tql | Name ~ 'test' | Search for all entities containing the word 'test'. |
format | grid | Format the results for rendering in a grid. |
$expand | Columns | Returns the grid results with column metadata. |
Response Headers
Key | Value | Description |
---|---|---|
Content-Type | application/json; charset=utf-8 |
Status Code
200 - OK
Return the results of an aggregated expression.
Request Headers
Key | Value | Description |
---|---|---|
Accept | application/json |
Request Parameters
Key | Value | Description |
---|---|---|
tql | GROUP BY Status { Count } as "Statuses" WHERE EntityType = Requirement | Return results of an aggregated expression. |
Response Headers
Key | Value | Description |
---|---|---|
Content-Type | application/json; charset=utf-8 |
Response Body
Code Block | ||
---|---|---|
| ||
{ "Results": { "Statuses": { "Approved": { "Count": 48 }, "Review Pending": { "Count": 4 }, "In Progress": { "Count": 10 }, "N/A": { "Count": 49 }, "No Run": { "Count": 34 }, "Not Covered": { "Count": 3 }, "Passed": { "Count": 15 }, "Requires Rework": { "Count": 1 } } } } |
Status Code
200 - OK
Return the results of an aggregated expression returning results formatted for an ExtJS style tree - this will convert entity results into edit links within ET.
Request Headers
Key | Value | Description |
---|---|---|
Accept | application/json |
Request Parameters
Key | Value | Description |
---|---|---|
tql | GROUP BY Status { Count } as "Statuses" WHERE EntityType = Requirement | Return results of an aggregated expression. |
fomat | extjstree | Output results suitable for rendering by a Sencha ExtJS tree component. |
Response Headers
Key | Value | Description |
---|---|---|
Content-Type | application/json; charset=utf-8 |
Response Body
Code Block | ||
---|---|---|
| ||
{ "Results": { "text": "Results", "expanded": true, "iconCls": "summary-results-root", "children": [ { "text": "Statuses", "expanded": true, "iconCls": "summary-results-dictionary", "children": [ { "text": "Approved", "expanded": true, "iconCls": "summary-results-dictionary", "children": [ { "text": "Count: 48", "iconCls": "summary-results-value-number", "leaf": true } ] }, { "text": "Review Pending", "expanded": true, "iconCls": "summary-results-dictionary", "children": [ { "text": "Count: 4", "iconCls": "summary-results-value-number", "leaf": true } ] }, { "text": "In Progress", "expanded": true, "iconCls": "summary-results-dictionary", "children": [ { "text": "Count: 10", "iconCls": "summary-results-value-number", "leaf": true } ] }, { "text": "N/A", "expanded": true, "iconCls": "summary-results-dictionary", "children": [ { "text": "Count: 49", "iconCls": "summary-results-value-number", "leaf": true } ] }, { "text": "No Run", "expanded": true, "iconCls": "summary-results-dictionary", "children": [ { "text": "Count: 34", "iconCls": "summary-results-value-number", "leaf": true } ] }, { "text": "Not Covered", "expanded": true, "iconCls": "summary-results-dictionary", "children": [ { "text": "Count: 3", "iconCls": "summary-results-value-number", "leaf": true } ] }, { "text": "Passed", "expanded": true, "iconCls": "summary-results-dictionary", "children": [ { "text": "Count: 15", "iconCls": "summary-results-value-number", "leaf": true } ] }, { "text": "Requires Rework", "expanded": true, "iconCls": "summary-results-dictionary", "children": [ { "text": "Count: 1", "iconCls": "summary-results-value-number", "leaf": true } ] } ] } ] } } |
Status Code
200 - OK
POST
Retrieves all (or a subset) of entities that are visible to the user. The search resource supports both standard and aggregate TQL query expressions. The parameters must be passed in using the x-www-form-urlencoded content type.
This method supports the TQL query parameters tql, $top, $take and $inlinecount. See TQL Topic for more details.
Required Permissions
- TestManagement/View
Status Codes
These are the expected status codes returned by the service - in addition, some other status codes may be returned if either an internal error occurs or there is an authentication issue (such as an expired OAuth token).
Status | Description |
---|---|
200 - OK | Returned if the request was completed successfully. |