KPIs Supplier Highways Jobs by Priority
This hub widget is included in the Highways package.
Description
This widget is a template, so it's offered by the From template menu when a user adds a widget to a hub.
Properties
This widget has the following properties.
| Property | Value |
|---|---|
| Name | KPIs Supplier Highways Jobs by Priority |
| Item ID | 6878e94b6c571718fb6b8236 |
| Type | Standard |
| Collection | Template |
| Context | Package |
| Show percentage bars | No |
| Default app | Not specified, each data point opens in the most suitable app for its type |
Data points
This widget has 11 data points, each querying the items below.
| Data point | Source | Targets | Icon | Colour |
|---|---|---|---|---|
| This year's Supplier Highways Jobs late and not completed | Query | Highways Jobs | icon-resource-job | #e9225b |
| This year's Supplier Highways Jobs completed on time | Query | Highways Jobs | icon-resource-job | #8dc349 |
| This year's Supplier Highways Jobs completed late | Query | Highways Jobs | icon-resource-job | #ed592a |
| This year's Urgent Priority Supplier Highways Jobs completed on time | Query | Highways Jobs | icon-resource-job | #7bba6d |
| This year's Urgent Priority Supplier Highways Jobs completed late | Query | Highways Jobs | icon-resource-job | #ed592a |
| This year's High Priority Supplier Highways Jobs completed on time | Query | Highways Jobs | icon-resource-job | #7bba6d |
| This year's High Priority Supplier Highways Jobs completed late | Query | Highways Jobs | icon-resource-job | #e9225b |
| This year's Medium Priority Supplier Highways Jobs completed on time | Query | Highways Jobs | icon-resource-job | #7bba6d |
| This year's Medium Priority Supplier Highways Jobs completed late | Query | Highways Jobs | icon-resource-job | #ed592a |
| This year's Low Priority Supplier Highways Jobs completed late | Query | Highways Jobs | icon-resource-job | #ed592a |
| This year's Low Priority Supplier Highways Jobs completed on time | Query | Highways Jobs | icon-resource-job | #7bba6d |
Configuration
The full configuration of this widget, including each data point's query.
Show configuration (1704 lines)
{
"hasBars": false,
"type": "Standard",
"dataPoints": [
{
"id": "010c6bf0-62fb-11f0-86f5-0deca73b6c70",
"name": "This year's Supplier Highways Jobs late and not completed",
"style": {
"icon": "icon-resource-job",
"colour": "#e9225b"
},
"type": "CustomQuery",
"aqs": {
"type": "Query",
"properties": {
"attributes": [
"attributes_tasksWithTaskTypesTaskType",
"attributes_tasksIdentifierAssetReferece",
"attributes_tasksIdentifierTaskLocation",
"attributes_tasksStatus",
"attributes_tasksPriority",
"attributes_tasksTeam",
"attributes_tasksTeamMember",
"attributes_tasksRaisedTime",
"attributes_tasksEstimatedStartTime",
"attributes_tasksEstimatedEndTime",
"attributes_tasksCompletionTime",
"attributes_tasksTargetTime",
"attributes_jobsJobNumber",
"attributes_jobsTotalEstimatedWorkItemCost",
"attributes_jobsTotalActualWorkItemCost"
],
"collectionCode": "Live",
"dodiCode": "designInterfaces_highwaysJobs_67e6472bcb15029b2c49ab4a",
"parameters": [
{
"name": "currentUserId",
"type": "AlloyId",
"title": "Current user ID"
}
]
},
"children": [
{
"type": "And",
"children": [
{
"type": "NotEquals",
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_taskStatusesStatusType",
"path": "root.attributes_tasksStatus"
}
},
{
"type": "AlloyId",
"properties": {
"value": [
"5baa06686753092c3c858b07",
"5baa06706753092c3c858b08",
"5baa06736753092c3c858b09",
"5baa06796753092c3c858b0a"
]
}
}
]
},
{
"type": "GreaterThan",
"children": [
{
"type": "RelativeDateTime",
"properties": {
"relativeTo": "Now",
"value": [
"0.00:00:00.000"
]
}
},
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksTargetTime"
}
}
]
},
{
"type": "ConnectedTo",
"children": [
{
"type": "Item",
"properties": {
"path": "root.attributes_tasksTeam.attributes_assignedSupplierAccountsSupplierAccount"
}
}
]
}
]
}
]
}
},
{
"id": "1722ad60-62fa-11f0-86f5-0deca73b6c70",
"name": "This year's Supplier Highways Jobs completed on time",
"style": {
"icon": "icon-resource-job",
"colour": "#8dc349"
},
"type": "CustomQuery",
"aqs": {
"type": "Query",
"properties": {
"attributes": [
"attributes_tasksWithTaskTypesTaskType",
"attributes_tasksIdentifierAssetReferece",
"attributes_tasksIdentifierTaskLocation",
"attributes_tasksStatus",
"attributes_tasksPriority",
"attributes_tasksTeam",
"attributes_tasksTeamMember",
"attributes_tasksRaisedTime",
"attributes_tasksEstimatedStartTime",
"attributes_tasksEstimatedEndTime",
"attributes_tasksCompletionTime",
"attributes_tasksTargetTime",
"attributes_jobsJobNumber",
"attributes_jobsTotalEstimatedWorkItemCost",
"attributes_jobsTotalActualWorkItemCost"
],
"collectionCode": "Live",
"dodiCode": "designInterfaces_highwaysJobs_67e6472bcb15029b2c49ab4a",
"parameters": [
{
"name": "currentUserId",
"type": "AlloyId",
"title": "Current user ID"
}
]
},
"children": [
{
"type": "And",
"children": [
{
"type": "Equals",
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_taskStatusesStatusType",
"path": "root.attributes_tasksStatus"
}
},
{
"type": "AlloyId",
"properties": {
"value": [
"5baa06686753092c3c858b07",
"5baa06706753092c3c858b08",
"5baa06736753092c3c858b09"
]
}
}
]
},
{
"type": "LessThan",
"properties": {
"inclusive": true
},
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksCompletionTime"
}
},
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksTargetTime"
}
}
]
},
{
"type": "GreaterThan",
"properties": {
"inclusive": true
},
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksTargetTime"
}
},
{
"type": "RelativeDateTime",
"properties": {
"relativeTo": "StartOfYear",
"value": [
"0.00:00:00.000"
]
}
}
]
},
{
"type": "LessThan",
"properties": {
"inclusive": true
},
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksTargetTime"
}
},
{
"type": "RelativeDateTime",
"properties": {
"relativeTo": "EndOfYear",
"value": [
"0.00:00:00.000"
]
}
}
]
},
{
"type": "ConnectedTo",
"children": [
{
"type": "Item",
"properties": {
"path": "root.attributes_tasksTeam.attributes_assignedSupplierAccountsSupplierAccount"
}
}
]
}
]
}
]
}
},
{
"id": "2a579210-62ff-11f0-86f5-0deca73b6c70",
"name": "This year's Supplier Highways Jobs completed late",
"style": {
"icon": "icon-resource-job",
"colour": "#ed592a"
},
"type": "CustomQuery",
"aqs": {
"type": "Query",
"properties": {
"attributes": [
"attributes_tasksWithTaskTypesTaskType",
"attributes_tasksIdentifierAssetReferece",
"attributes_tasksIdentifierTaskLocation",
"attributes_tasksStatus",
"attributes_tasksPriority",
"attributes_tasksTeam",
"attributes_tasksTeamMember",
"attributes_tasksRaisedTime",
"attributes_tasksEstimatedStartTime",
"attributes_tasksEstimatedEndTime",
"attributes_tasksCompletionTime",
"attributes_tasksTargetTime",
"attributes_jobsJobNumber",
"attributes_jobsTotalEstimatedWorkItemCost",
"attributes_jobsTotalActualWorkItemCost"
],
"collectionCode": "Live",
"dodiCode": "designInterfaces_highwaysJobs_67e6472bcb15029b2c49ab4a",
"parameters": [
{
"name": "currentUserId",
"type": "AlloyId",
"title": "Current user ID"
}
]
},
"children": [
{
"type": "And",
"children": [
{
"type": "Equals",
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_taskStatusesStatusType",
"path": "root.attributes_tasksStatus"
}
},
{
"type": "AlloyId",
"properties": {
"value": [
"5baa06686753092c3c858b07",
"5baa06706753092c3c858b08",
"5baa06736753092c3c858b09"
]
}
}
]
},
{
"type": "GreaterThan",
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksCompletionTime"
}
},
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksTargetTime"
}
}
]
},
{
"type": "GreaterThan",
"properties": {
"inclusive": true
},
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksTargetTime"
}
},
{
"type": "RelativeDateTime",
"properties": {
"relativeTo": "StartOfYear",
"value": [
"0.00:00:00.000"
]
}
}
]
},
{
"type": "LessThan",
"properties": {
"inclusive": true
},
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksTargetTime"
}
},
{
"type": "RelativeDateTime",
"properties": {
"relativeTo": "EndOfYear",
"value": [
"0.00:00:00.000"
]
}
}
]
},
{
"type": "ConnectedTo",
"children": [
{
"type": "Item",
"properties": {
"path": "root.attributes_tasksTeam.attributes_assignedSupplierAccountsSupplierAccount"
}
}
]
}
]
}
]
}
},
{
"id": "49b54d50-62fa-11f0-86f5-0deca73b6c70",
"name": "This year's Urgent Priority Supplier Highways Jobs completed on time",
"style": {
"icon": "icon-resource-job",
"colour": "#7bba6d"
},
"type": "CustomQuery",
"aqs": {
"type": "Query",
"properties": {
"attributes": [
"attributes_tasksWithTaskTypesTaskType",
"attributes_tasksIdentifierAssetReferece",
"attributes_tasksIdentifierTaskLocation",
"attributes_tasksStatus",
"attributes_tasksPriority",
"attributes_tasksTeam",
"attributes_tasksTeamMember",
"attributes_tasksRaisedTime",
"attributes_tasksEstimatedStartTime",
"attributes_tasksEstimatedEndTime",
"attributes_tasksCompletionTime",
"attributes_tasksTargetTime",
"attributes_jobsJobNumber",
"attributes_jobsTotalEstimatedWorkItemCost",
"attributes_jobsTotalActualWorkItemCost"
],
"collectionCode": "Live",
"dodiCode": "designInterfaces_highwaysJobs_67e6472bcb15029b2c49ab4a",
"parameters": [
{
"name": "currentUserId",
"type": "AlloyId",
"title": "Current user ID"
}
]
},
"children": [
{
"type": "And",
"children": [
{
"type": "Equals",
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_taskStatusesStatusType",
"path": "root.attributes_tasksStatus"
}
},
{
"type": "AlloyId",
"properties": {
"value": [
"5baa06686753092c3c858b07",
"5baa06706753092c3c858b08",
"5baa06736753092c3c858b09"
]
}
}
]
},
{
"type": "LessThan",
"properties": {
"inclusive": true
},
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksCompletionTime"
}
},
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksTargetTime"
}
}
]
},
{
"type": "GreaterThan",
"properties": {
"inclusive": true
},
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksTargetTime"
}
},
{
"type": "RelativeDateTime",
"properties": {
"relativeTo": "StartOfYear",
"value": [
"0.00:00:00.000"
]
}
}
]
},
{
"type": "LessThan",
"properties": {
"inclusive": true
},
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksTargetTime"
}
},
{
"type": "RelativeDateTime",
"properties": {
"relativeTo": "EndOfYear",
"value": [
"0.00:00:00.000"
]
}
}
]
},
{
"type": "ConnectedTo",
"children": [
{
"type": "Item",
"properties": {
"path": "root.attributes_tasksTeam.attributes_assignedSupplierAccountsSupplierAccount"
}
}
]
},
{
"type": "Equals",
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksPriority"
}
},
{
"type": "AlloyId",
"properties": {
"value": [
"67b5d018aa325c4da95f83c4"
]
}
}
]
}
]
}
]
}
},
{
"id": "52fbc6a0-62ff-11f0-86f5-0deca73b6c70",
"name": "This year's Urgent Priority Supplier Highways Jobs completed late",
"style": {
"icon": "icon-resource-job",
"colour": "#ed592a"
},
"type": "CustomQuery",
"aqs": {
"type": "Query",
"properties": {
"attributes": [
"attributes_tasksWithTaskTypesTaskType",
"attributes_tasksIdentifierAssetReferece",
"attributes_tasksIdentifierTaskLocation",
"attributes_tasksStatus",
"attributes_tasksPriority",
"attributes_tasksTeam",
"attributes_tasksTeamMember",
"attributes_tasksRaisedTime",
"attributes_tasksEstimatedStartTime",
"attributes_tasksEstimatedEndTime",
"attributes_tasksCompletionTime",
"attributes_tasksTargetTime",
"attributes_jobsJobNumber",
"attributes_jobsTotalEstimatedWorkItemCost",
"attributes_jobsTotalActualWorkItemCost"
],
"collectionCode": "Live",
"dodiCode": "designInterfaces_highwaysJobs_67e6472bcb15029b2c49ab4a",
"parameters": [
{
"name": "currentUserId",
"type": "AlloyId",
"title": "Current user ID"
}
]
},
"children": [
{
"type": "And",
"children": [
{
"type": "Equals",
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_taskStatusesStatusType",
"path": "root.attributes_tasksStatus"
}
},
{
"type": "AlloyId",
"properties": {
"value": [
"5baa06686753092c3c858b07",
"5baa06706753092c3c858b08",
"5baa06736753092c3c858b09"
]
}
}
]
},
{
"type": "GreaterThan",
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksCompletionTime"
}
},
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksTargetTime"
}
}
]
},
{
"type": "GreaterThan",
"properties": {
"inclusive": true
},
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksTargetTime"
}
},
{
"type": "RelativeDateTime",
"properties": {
"relativeTo": "StartOfYear",
"value": [
"0.00:00:00.000"
]
}
}
]
},
{
"type": "LessThan",
"properties": {
"inclusive": true
},
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksTargetTime"
}
},
{
"type": "RelativeDateTime",
"properties": {
"relativeTo": "EndOfYear",
"value": [
"0.00:00:00.000"
]
}
}
]
},
{
"type": "ConnectedTo",
"children": [
{
"type": "Item",
"properties": {
"path": "root.attributes_tasksTeam.attributes_assignedSupplierAccountsSupplierAccount"
}
}
]
},
{
"type": "Equals",
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksPriority"
}
},
{
"type": "AlloyId",
"properties": {
"value": [
"67b5d018aa325c4da95f83c4"
]
}
}
]
}
]
}
]
}
},
{
"id": "846f6200-62ff-11f0-86f5-0deca73b6c70",
"name": "This year's High Priority Supplier Highways Jobs completed on time",
"style": {
"icon": "icon-resource-job",
"colour": "#7bba6d"
},
"type": "CustomQuery",
"aqs": {
"type": "Query",
"properties": {
"attributes": [
"attributes_tasksWithTaskTypesTaskType",
"attributes_tasksIdentifierAssetReferece",
"attributes_tasksIdentifierTaskLocation",
"attributes_tasksStatus",
"attributes_tasksPriority",
"attributes_tasksTeam",
"attributes_tasksTeamMember",
"attributes_tasksRaisedTime",
"attributes_tasksEstimatedStartTime",
"attributes_tasksEstimatedEndTime",
"attributes_tasksCompletionTime",
"attributes_tasksTargetTime",
"attributes_jobsJobNumber",
"attributes_jobsTotalEstimatedWorkItemCost",
"attributes_jobsTotalActualWorkItemCost"
],
"collectionCode": "Live",
"dodiCode": "designInterfaces_highwaysJobs_67e6472bcb15029b2c49ab4a",
"parameters": [
{
"name": "currentUserId",
"type": "AlloyId",
"title": "Current user ID"
}
]
},
"children": [
{
"type": "And",
"children": [
{
"type": "Equals",
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_taskStatusesStatusType",
"path": "root.attributes_tasksStatus"
}
},
{
"type": "AlloyId",
"properties": {
"value": [
"5baa06686753092c3c858b07",
"5baa06706753092c3c858b08",
"5baa06736753092c3c858b09"
]
}
}
]
},
{
"type": "LessThan",
"properties": {
"inclusive": true
},
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksCompletionTime"
}
},
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksTargetTime"
}
}
]
},
{
"type": "GreaterThan",
"properties": {
"inclusive": true
},
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksTargetTime"
}
},
{
"type": "RelativeDateTime",
"properties": {
"relativeTo": "StartOfYear",
"value": [
"0.00:00:00.000"
]
}
}
]
},
{
"type": "LessThan",
"properties": {
"inclusive": true
},
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksTargetTime"
}
},
{
"type": "RelativeDateTime",
"properties": {
"relativeTo": "EndOfYear",
"value": [
"0.00:00:00.000"
]
}
}
]
},
{
"type": "ConnectedTo",
"children": [
{
"type": "Item",
"properties": {
"path": "root.attributes_tasksTeam.attributes_assignedSupplierAccountsSupplierAccount"
}
}
]
},
{
"type": "Equals",
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksPriority"
}
},
{
"type": "AlloyId",
"properties": {
"value": [
"67b5d044e11c843c841e272d"
]
}
}
]
}
]
}
]
}
},
{
"id": "b4e822a0-62ff-11f0-86f5-0deca73b6c70",
"name": "This year's High Priority Supplier Highways Jobs completed late",
"style": {
"icon": "icon-resource-job",
"colour": "#e9225b"
},
"type": "CustomQuery",
"aqs": {
"type": "Query",
"properties": {
"attributes": [
"attributes_tasksWithTaskTypesTaskType",
"attributes_tasksIdentifierAssetReferece",
"attributes_tasksIdentifierTaskLocation",
"attributes_tasksStatus",
"attributes_tasksPriority",
"attributes_tasksTeam",
"attributes_tasksTeamMember",
"attributes_tasksRaisedTime",
"attributes_tasksEstimatedStartTime",
"attributes_tasksEstimatedEndTime",
"attributes_tasksCompletionTime",
"attributes_tasksTargetTime",
"attributes_jobsJobNumber",
"attributes_jobsTotalEstimatedWorkItemCost",
"attributes_jobsTotalActualWorkItemCost"
],
"collectionCode": "Live",
"dodiCode": "designInterfaces_highwaysJobs_67e6472bcb15029b2c49ab4a",
"parameters": [
{
"name": "currentUserId",
"type": "AlloyId",
"title": "Current user ID"
}
]
},
"children": [
{
"type": "And",
"children": [
{
"type": "Equals",
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_taskStatusesStatusType",
"path": "root.attributes_tasksStatus"
}
},
{
"type": "AlloyId",
"properties": {
"value": [
"5baa06686753092c3c858b07",
"5baa06706753092c3c858b08",
"5baa06736753092c3c858b09"
]
}
}
]
},
{
"type": "GreaterThan",
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksCompletionTime"
}
},
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksTargetTime"
}
}
]
},
{
"type": "GreaterThan",
"properties": {
"inclusive": true
},
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksTargetTime"
}
},
{
"type": "RelativeDateTime",
"properties": {
"relativeTo": "StartOfYear",
"value": [
"0.00:00:00.000"
]
}
}
]
},
{
"type": "LessThan",
"properties": {
"inclusive": true
},
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksTargetTime"
}
},
{
"type": "RelativeDateTime",
"properties": {
"relativeTo": "EndOfYear",
"value": [
"0.00:00:00.000"
]
}
}
]
},
{
"type": "ConnectedTo",
"children": [
{
"type": "Item",
"properties": {
"path": "root.attributes_tasksTeam.attributes_assignedSupplierAccountsSupplierAccount"
}
}
]
},
{
"type": "Equals",
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksPriority"
}
},
{
"type": "AlloyId",
"properties": {
"value": [
"67b5d044e11c843c841e272d"
]
}
}
]
}
]
}
]
}
},
{
"id": "f2d1b740-6302-11f0-86f5-0deca73b6c70",
"name": "This year's Medium Priority Supplier Highways Jobs completed on time",
"style": {
"icon": "icon-resource-job",
"colour": "#7bba6d"
},
"type": "CustomQuery",
"aqs": {
"type": "Query",
"properties": {
"attributes": [
"attributes_tasksWithTaskTypesTaskType",
"attributes_tasksIdentifierAssetReferece",
"attributes_tasksIdentifierTaskLocation",
"attributes_tasksStatus",
"attributes_tasksPriority",
"attributes_tasksTeam",
"attributes_tasksTeamMember",
"attributes_tasksRaisedTime",
"attributes_tasksEstimatedStartTime",
"attributes_tasksEstimatedEndTime",
"attributes_tasksCompletionTime",
"attributes_tasksTargetTime",
"attributes_jobsJobNumber",
"attributes_jobsTotalEstimatedWorkItemCost",
"attributes_jobsTotalActualWorkItemCost"
],
"collectionCode": "Live",
"dodiCode": "designInterfaces_highwaysJobs_67e6472bcb15029b2c49ab4a",
"parameters": [
{
"name": "currentUserId",
"type": "AlloyId",
"title": "Current user ID"
}
]
},
"children": [
{
"type": "And",
"children": [
{
"type": "Equals",
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_taskStatusesStatusType",
"path": "root.attributes_tasksStatus"
}
},
{
"type": "AlloyId",
"properties": {
"value": [
"5baa06686753092c3c858b07",
"5baa06706753092c3c858b08",
"5baa06736753092c3c858b09"
]
}
}
]
},
{
"type": "LessThan",
"properties": {
"inclusive": true
},
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksCompletionTime"
}
},
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksTargetTime"
}
}
]
},
{
"type": "GreaterThan",
"properties": {
"inclusive": true
},
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksTargetTime"
}
},
{
"type": "RelativeDateTime",
"properties": {
"relativeTo": "StartOfYear",
"value": [
"0.00:00:00.000"
]
}
}
]
},
{
"type": "LessThan",
"properties": {
"inclusive": true
},
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksTargetTime"
}
},
{
"type": "RelativeDateTime",
"properties": {
"relativeTo": "EndOfYear",
"value": [
"0.00:00:00.000"
]
}
}
]
},
{
"type": "ConnectedTo",
"children": [
{
"type": "Item",
"properties": {
"path": "root.attributes_tasksTeam.attributes_assignedSupplierAccountsSupplierAccount"
}
}
]
},
{
"type": "Equals",
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksPriority"
}
},
{
"type": "AlloyId",
"properties": {
"value": [
"67b5d07aaa325c4da95f83d1"
]
}
}
]
}
]
}
]
}
},
{
"id": "cff02610-62ff-11f0-86f5-0deca73b6c70",
"name": "This year's Medium Priority Supplier Highways Jobs completed late",
"style": {
"icon": "icon-resource-job",
"colour": "#ed592a"
},
"type": "CustomQuery",
"aqs": {
"type": "Query",
"properties": {
"attributes": [
"attributes_tasksWithTaskTypesTaskType",
"attributes_tasksIdentifierAssetReferece",
"attributes_tasksIdentifierTaskLocation",
"attributes_tasksStatus",
"attributes_tasksPriority",
"attributes_tasksTeam",
"attributes_tasksTeamMember",
"attributes_tasksRaisedTime",
"attributes_tasksEstimatedStartTime",
"attributes_tasksEstimatedEndTime",
"attributes_tasksCompletionTime",
"attributes_tasksTargetTime",
"attributes_jobsJobNumber",
"attributes_jobsTotalEstimatedWorkItemCost",
"attributes_jobsTotalActualWorkItemCost"
],
"collectionCode": "Live",
"dodiCode": "designInterfaces_highwaysJobs_67e6472bcb15029b2c49ab4a",
"parameters": [
{
"name": "currentUserId",
"type": "AlloyId",
"title": "Current user ID"
}
]
},
"children": [
{
"type": "And",
"children": [
{
"type": "Equals",
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_taskStatusesStatusType",
"path": "root.attributes_tasksStatus"
}
},
{
"type": "AlloyId",
"properties": {
"value": [
"5baa06686753092c3c858b07",
"5baa06706753092c3c858b08",
"5baa06736753092c3c858b09"
]
}
}
]
},
{
"type": "GreaterThan",
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksCompletionTime"
}
},
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksTargetTime"
}
}
]
},
{
"type": "GreaterThan",
"properties": {
"inclusive": true
},
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksTargetTime"
}
},
{
"type": "RelativeDateTime",
"properties": {
"relativeTo": "StartOfYear",
"value": [
"0.00:00:00.000"
]
}
}
]
},
{
"type": "LessThan",
"properties": {
"inclusive": true
},
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksTargetTime"
}
},
{
"type": "RelativeDateTime",
"properties": {
"relativeTo": "EndOfYear",
"value": [
"0.00:00:00.000"
]
}
}
]
},
{
"type": "ConnectedTo",
"children": [
{
"type": "Item",
"properties": {
"path": "root.attributes_tasksTeam.attributes_assignedSupplierAccountsSupplierAccount"
}
}
]
},
{
"type": "Equals",
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksPriority"
}
},
{
"type": "AlloyId",
"properties": {
"value": [
"67b5d07aaa325c4da95f83d1"
]
}
}
]
}
]
}
]
}
},
{
"id": "061b75c0-6303-11f0-86f5-0deca73b6c70",
"name": "This year's Low Priority Supplier Highways Jobs completed late",
"style": {
"icon": "icon-resource-job",
"colour": "#ed592a"
},
"type": "CustomQuery",
"aqs": {
"type": "Query",
"properties": {
"attributes": [
"attributes_tasksWithTaskTypesTaskType",
"attributes_tasksIdentifierAssetReferece",
"attributes_tasksIdentifierTaskLocation",
"attributes_tasksStatus",
"attributes_tasksPriority",
"attributes_tasksTeam",
"attributes_tasksTeamMember",
"attributes_tasksRaisedTime",
"attributes_tasksEstimatedStartTime",
"attributes_tasksEstimatedEndTime",
"attributes_tasksCompletionTime",
"attributes_tasksTargetTime",
"attributes_jobsJobNumber",
"attributes_jobsTotalEstimatedWorkItemCost",
"attributes_jobsTotalActualWorkItemCost"
],
"collectionCode": "Live",
"dodiCode": "designInterfaces_highwaysJobs_67e6472bcb15029b2c49ab4a",
"parameters": [
{
"name": "currentUserId",
"type": "AlloyId",
"title": "Current user ID"
}
]
},
"children": [
{
"type": "And",
"children": [
{
"type": "Equals",
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_taskStatusesStatusType",
"path": "root.attributes_tasksStatus"
}
},
{
"type": "AlloyId",
"properties": {
"value": [
"5baa06686753092c3c858b07",
"5baa06706753092c3c858b08",
"5baa06736753092c3c858b09"
]
}
}
]
},
{
"type": "GreaterThan",
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksCompletionTime"
}
},
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksTargetTime"
}
}
]
},
{
"type": "GreaterThan",
"properties": {
"inclusive": true
},
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksTargetTime"
}
},
{
"type": "RelativeDateTime",
"properties": {
"relativeTo": "StartOfYear",
"value": [
"0.00:00:00.000"
]
}
}
]
},
{
"type": "LessThan",
"properties": {
"inclusive": true
},
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksTargetTime"
}
},
{
"type": "RelativeDateTime",
"properties": {
"relativeTo": "EndOfYear",
"value": [
"0.00:00:00.000"
]
}
}
]
},
{
"type": "ConnectedTo",
"children": [
{
"type": "Item",
"properties": {
"path": "root.attributes_tasksTeam.attributes_assignedSupplierAccountsSupplierAccount"
}
}
]
},
{
"type": "Equals",
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksPriority"
}
},
{
"type": "AlloyId",
"properties": {
"value": [
"67b5d08eaa325c4da95f83e8"
]
}
}
]
}
]
}
]
}
},
{
"id": "27c10be0-6303-11f0-86f5-0deca73b6c70",
"name": "This year's Low Priority Supplier Highways Jobs completed on time",
"style": {
"icon": "icon-resource-job",
"colour": "#7bba6d"
},
"type": "CustomQuery",
"aqs": {
"type": "Query",
"properties": {
"attributes": [
"attributes_tasksWithTaskTypesTaskType",
"attributes_tasksIdentifierAssetReferece",
"attributes_tasksIdentifierTaskLocation",
"attributes_tasksStatus",
"attributes_tasksPriority",
"attributes_tasksTeam",
"attributes_tasksTeamMember",
"attributes_tasksRaisedTime",
"attributes_tasksEstimatedStartTime",
"attributes_tasksEstimatedEndTime",
"attributes_tasksCompletionTime",
"attributes_tasksTargetTime",
"attributes_jobsJobNumber",
"attributes_jobsTotalEstimatedWorkItemCost",
"attributes_jobsTotalActualWorkItemCost"
],
"collectionCode": "Live",
"dodiCode": "designInterfaces_highwaysJobs_67e6472bcb15029b2c49ab4a",
"parameters": [
{
"name": "currentUserId",
"type": "AlloyId",
"title": "Current user ID"
}
]
},
"children": [
{
"type": "And",
"children": [
{
"type": "Equals",
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_taskStatusesStatusType",
"path": "root.attributes_tasksStatus"
}
},
{
"type": "AlloyId",
"properties": {
"value": [
"5baa06686753092c3c858b07",
"5baa06706753092c3c858b08",
"5baa06736753092c3c858b09"
]
}
}
]
},
{
"type": "LessThan",
"properties": {
"inclusive": true
},
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksCompletionTime"
}
},
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksTargetTime"
}
}
]
},
{
"type": "GreaterThan",
"properties": {
"inclusive": true
},
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksTargetTime"
}
},
{
"type": "RelativeDateTime",
"properties": {
"relativeTo": "StartOfYear",
"value": [
"0.00:00:00.000"
]
}
}
]
},
{
"type": "LessThan",
"properties": {
"inclusive": true
},
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksTargetTime"
}
},
{
"type": "RelativeDateTime",
"properties": {
"relativeTo": "EndOfYear",
"value": [
"0.00:00:00.000"
]
}
}
]
},
{
"type": "ConnectedTo",
"children": [
{
"type": "Item",
"properties": {
"path": "root.attributes_tasksTeam.attributes_assignedSupplierAccountsSupplierAccount"
}
}
]
},
{
"type": "Equals",
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksPriority"
}
},
{
"type": "AlloyId",
"properties": {
"value": [
"67b5d08eaa325c4da95f83e8"
]
}
}
]
}
]
}
]
}
}
]
}