...
This is querying the history of an environment called “Development” our production environments for deployments that failed with file details not being returned. We also want the most recent failed deployment so we will be sorting by date.
| Code Block |
|---|
query reportHistoryNoFiles($where: [WhereInput], $sort: [SortInput], $page: PageInput) {
reportEnvironmentHistoryNoFileDetails(where: $where, sort: $sort, page: $page) {
items {
allFilesRequested
cmsTicketIds
endTime
environmentId
environmentName
executionStatus
folderId
instanceId
instanceName
workItemIds
objectPath
packageName
partialDeployments
pkgStatus
poScmRevision
projectId
projectName
projectVersionName
relDefinitionId
relName
relSnapshot
relSnapshotId
requestedBy
requestedOn
scmRevision
sequenceNumber
stageExecId
startTime
streamName
workflowExecutionId
workflowId
workflowRequestId
workflowType
workflowVersion
}
}
}
|
Variables
| Code Block |
|---|
{
"wheresort": [
{
"field": "environmentNamerequestedOn",
"typedirection": "eqi",desc"
}
],
"valuewhere": "development" [
{
} ], "pagefield": {"environmentName",
"limittype": "inci",
2 } } |
Response
| Code Block |
|---|
{ "datavalue": {"prod" "reportEnvironmentHistoryNoFileDetails": { "items": [ { "allFilesRequested": "N", "cmsTicketIds": null, "endTime": 1683228177100, "environmentId": 10051, "environmentName": "Development", "executionStatus": "Success", "folderId": 759142, "instanceId": 21888, "instanceName": "RESTServer", "workItemIds": null, "objectPath": null, "packageName": "", "partialDeployments": "N", "pkgStatus": null, "poScmRevision": null, "projectId": 759143, "projectName": "RESTDeployProject1", "projectVersionName": "1.0.30577", "relDefinitionId": 27201, "relName": "REST Release 1", "relSnapshot": "05-04-2023 14:22:47", "relSnapshotId": 939685, "requestedBy": "stepworker", "requestedOn": 1683228173402, "scmRevision": null,}, { "sequenceNumberfield": null, "workflowType", "stageExecIdtype": 939691, "startTime": 1683228177087"eq", "streamName"value": "trunkDEPLOY", }, "workflowExecutionId": 6115046, { "workflowIdfield": 83363, "executionStatus", "workflowRequestIdtype": 1190160"eq", "value": "Failed" "workflowType": "DEPLOY", } ], } |
Response
| Code Block |
|---|
{ "data": { "workflowVersionreportEnvironmentHistoryNoFileDetails": "1.2"{ "items": [ }, { "allFilesRequested": "N", "cmsTicketIds": null, "endTime": 16832281772331683228177100, "environmentId": 10051, "environmentName": "DevelopmentProduction2", "executionStatus": "SuccessFailed", "folderId": 759142, "instanceId": 4566421888, "instanceName": "Project Rest Test Instance 1RESTServer", "workItemIds": null, "objectPath": null, "packageName": "", "partialDeployments": "N", "pkgStatus": null, "poScmRevision": null, "projectId": 759143, "projectName": "RESTDeployProject1", "projectVersionName": "1.0.30577", "relDefinitionId": 27201, "relName": "REST Release 1", "relSnapshot": "05-04-2023 14:22:47", "relSnapshotId": 939685, "requestedBy": "stepworker", "requestedOn": 1683228173402, "scmRevision": null, "sequenceNumber": null, "stageExecId": 939691, "startTime": 16832281771881683228177087, "streamName": "trunk", "workflowExecutionId": 61150476115046, "workflowId": 83363, "workflowRequestId": 1190160, "workflowType": "DEPLOY", "workflowVersion": "1.2" } ] } } } |
...