Work items are not showing up in release notes #2171

drahcir9000 · 2025-12-18T15:48:21Z

drahcir9000
Dec 18, 2025

I am fairly new to azure devops pipelines and handlebars. A search and various threads did not bring me any closer to a working solution so any help is appreciated.
Goal is to generate release notes with the latest version of XplatGenerateReleaseNotes@4 that contain the changed files and also general info of the work items referenced in the commit messages.

The task goes through and release notes are generated but they lack the work items referenced in the commits/PRs

The repo and the pipeline are located in the "ManagerService" Project. The work items are in another project within the same organisation and it is called "DevBoard".

Due to the two projects I thought I should write a wiqlWhereClause.

I commit my changes like this "#8795 #8794 Test PR for RN generation Test ". After some hours of trying I am not getting closer to to my goal. I commited changes with and without PRs that are also displayed in devops but they do not show in the release notes.

I will try to include all needed information. To begin with here is my task:

`- task: XplatGenerateReleaseNotes@4
displayName: 'Generate Release Notes'
env:
SYSTEM_ACCESSTOKEN: $(System.AccessToken)
inputs:
outputFile: '$(Build.Repository.LocalPath)\releasenotes_$(Build.BuildId).md'
templateLocation: 'Inline'
dumpPayloadToConsole: true
replaceFile: true
dumpPayloadToFile: true
dumpPayloadFileName: '$(Build.Repository.LocalPath)\dump.txt'
checkForManuallyLinkedWI: true
getPRDetails: true
wiqlWhereClause: |
[System.TeamProject] = 'DevBoard'
AND [System.ChangedDate] >= @today - 7
inlineTemplate: |
## Build {{buildDetails.buildNumber}}
Branch: {{buildDetails.sourceBranch}}
Author: {{buildDetails.requestedFor.displayName}}
Commit: {{buildDetails.sourceVersion}}

  ## Build {{buildDetails.buildNumber}}
  * **Branch**: {{buildDetails.sourceBranch}}
  * **Tags**: {{buildDetails.tags}}
  * **Completed**: {{buildDetails.finishTime}}
  * **Previous Build**: {{compareBuildDetails.buildNumber}}
  
  ## Associated Pull Requests ({{pullRequests.length}})
  {{#forEach pullRequests}}
  * **[{{this.pullRequestId}}]({{replace (replace this.url "_apis/git/repositories" "_git") "pullRequests" "pullRequest"}})** {{this.title}}
  
    * Associated Work Items
    {{#forEach this.associatedWorkitems}}
      {{#with (lookup_a_work_item ../../relatedWorkItems this.url)}}
      - [{{this.id}}]({{replace this.url "_apis/wit/workItems" "_workitems/edit"}}) - {{lookup this.fields 'System.Title'}}
      {{/with}}
    {{/forEach}}
  
    * Associated Commits (this includes commits on the PR source branch not associated directly with the build)
    {{#forEach this.associatedCommits}}
      - [{{this.commitId}}]({{this.remoteUrl}}) - {{this.comment}}
    {{/forEach}}
  {{/forEach}}
  
  # Global list of WI with PRs, parents and children
  {{#forEach this.workItems}}
  {{#if isFirst}}
  ### WorkItems
  {{/if}}
  
  * **{{this.id}}** {{lookup this.fields 'System.Title'}}
    - **WIT** {{lookup this.fields 'System.WorkItemType'}}
    - **Tags** {{lookup this.fields 'System.Tags'}}
    - **Assigned**
      {{#with (lookup this.fields 'System.AssignedTo')}}{{displayName}}{{/with}}
    - **Description**
      {{{lookup this.fields 'System.Description'}}}
  
    - **PRs**
    {{#forEach this.relations}}
      {{#if (contains this.attributes.name 'Pull Request')}}
        {{#with (lookup_a_pullrequest ../../pullRequests this.url)}}
        - {{this.pullRequestId}} - {{this.title}}
        {{/with}}
      {{/if}}
    {{/forEach}}
  
    - **Parents**
    {{#forEach this.relations}}
      {{#if (contains this.attributes.name 'Parent')}}
        {{#with (lookup_a_work_item ../../relatedWorkItems this.url)}}
        - {{this.id}} - {{lookup this.fields 'System.Title'}}
          {{#forEach this.relations}}
            {{#if (contains this.attributes.name 'Parent')}}
              {{#with (lookup_a_work_item ../../../../relatedWorkItems this.url)}}
              - {{this.id}} - {{lookup this.fields 'System.Title'}}
              {{/with}}
            {{/if}}
          {{/forEach}}
        {{/with}}
      {{/if}}
    {{/forEach}}
  
    - **Children**
    {{#forEach this.relations}}
      {{#if (contains this.attributes.name 'Child')}}
        {{#with (lookup_a_work_item ../../relatedWorkItems this.url)}}
        - {{this.id}} - {{lookup this.fields 'System.Title'}}
        {{/with}}
      {{/if}}
    {{/forEach}}
  
    - **Tested By**
    {{#forEach this.relations}}
      {{#if (contains this.attributes.name 'Tested By')}}
        {{#with (lookup_a_work_item ../../testedByWorkItems this.url)}}
        - {{this.id}} - {{lookup this.fields 'System.Title'}}
        {{/with}}
      {{/if}}
    {{/forEach}}
  {{/forEach}}
  
  # Global list of CS ({{commits.length}})
  {{#forEach commits}}
  {{#if isFirst}}
  ### Associated commits
  {{/if}}
  
  * **ID {{this.id}}**
    - **Message:** {{this.message}}
    - **Committed by:** {{this.author.displayName}}
    - **FileCount:** {{this.changes.length}}
  
    {{#forEach this.changes}}
    - **File path (TFVC or TfsGit):** {{this.item.path}}
    - **File filename (GitHub):** {{this.filename}}
    {{/forEach}}
  {{/forEach}}
  
  ## List of WI returned by WIQL ({{queryWorkItems.length}})
  {{#forEach queryWorkItems}}
  * **{{this.id}}** {{lookup this.fields 'System.Title'}}
  {{/forEach}}
  
  ## Manual Test Plans
  | Run ID | Name | State | Total Tests | Passed Tests |
  |-------:|------|-------|-------------|--------------|
  {{#forEach manualTests}}
  | [{{this.id}}]({{this.webAccessUrl}}) | {{this.name}} | {{this.state}} | {{this.totalTests}} | {{this.passedTests}} |
  {{/forEach}}
  
  ## Global list of ConsumedArtifacts ({{consumedArtifacts.length}})
  | Category | Type | Version Name | Version Id | Commits | Workitems |
  |----------|------|--------------|------------|---------|-----------|
  {{#forEach consumedArtifacts}}
  | {{this.artifactCategory}} | {{this.artifactType}} | {{#if versionName}}{{versionName}}{{/if}} | {{truncate versionId 7}} | {{#if this.commits}}{{this.commits.length}}{{/if}} | {{#if this.workitems}}{{this.workitems.length}}{{/if}} |
  {{/forEach}}
  
  ## Artifacts published by build ({{publishedArtifacts.length}})
  | Name | Type |
  |------|------|
  {{#forEach publishedArtifacts}}
  | {{this.name}} | {{this.resource.type}} |
  {{/forEach}}

  ## Work Items ({{relatedWorkItems.length}})
  {{#forEach relatedWorkItems}}
  * **{{this.id}}** – {{lookup this.fields 'System.Title'}}
    - **Type:** {{lookup this.fields 'System.WorkItemType'}}
    - **Assigned To:** {{#with (lookup this.fields 'System.AssignedTo')}}{{displayName}}{{/with}}
    - **Created:** {{lookup this.fields 'System.CreatedDate'}}
    - **Last Updated:** {{lookup this.fields 'System.ChangedDate'}}
    - **Description:**
      {{{lookup this.fields 'System.Description'}}}
  {{/forEach}}`

This is the the output of the task:
`2025-12-18T14:46:59.9497883Z ##[debug]Evaluating condition for step: 'Generate Release Notes'
2025-12-18T14:46:59.9498930Z ##[debug]Evaluating: SucceededNode()
2025-12-18T14:46:59.9499150Z ##[debug]Evaluating SucceededNode:
2025-12-18T14:46:59.9499482Z ##[debug]=> True
2025-12-18T14:46:59.9499755Z ##[debug]Result: True
2025-12-18T14:46:59.9500939Z ##[section]Starting: Generate Release Notes
2025-12-18T14:46:59.9509572Z ==============================================================================
2025-12-18T14:46:59.9509664Z Task : Generate Release Notes (Crossplatform)
2025-12-18T14:46:59.9509723Z Description : Generates a release notes file in a format of your choice from the build or release history
2025-12-18T14:46:59.9509814Z Version : 4.27.4
2025-12-18T14:46:59.9509859Z Author : Black Marble
2025-12-18T14:46:59.9509919Z Help : Version: 4.27.4. More Information
2025-12-18T14:46:59.9510054Z ==============================================================================
2025-12-18T14:46:59.9781364Z ##[debug]Using node path: D:\RM_Agent\vsts-agent-win-x64-4.264.2\externals\node20_1\bin\node.exe
2025-12-18T14:47:00.0980832Z ##[debug]system.debug=true
2025-12-18T14:47:00.0981349Z ##[debug]DistributedTask.Tasks.Node.SkipDebugLogsWhenDebugModeOff=True
2025-12-18T14:47:00.1034632Z ##[debug]agent.TempDirectory=D:\RM_Agent\vsts-agent-win-x64-4.264.2_work_temp
2025-12-18T14:47:00.1041865Z ##[debug]loading inputs and endpoints
2025-12-18T14:47:00.1067494Z ##[debug]loading ENDPOINT_AUTH_PARAMETER_SYSTEMVSSCONNECTION_ACCESSTOKEN
2025-12-18T14:47:00.1083154Z ##[debug]loading ENDPOINT_AUTH_SCHEME_SYSTEMVSSCONNECTION
2025-12-18T14:47:00.1085658Z ##[debug]loading ENDPOINT_AUTH_SYSTEMVSSCONNECTION
2025-12-18T14:47:00.1088264Z ##[debug]loading INPUT_APPENDTOFILE
2025-12-18T14:47:00.1090811Z ##[debug]loading INPUT_CHECKFORMANUALLYLINKEDWI
2025-12-18T14:47:00.1093127Z ##[debug]loading INPUT_CHECKSTAGE
2025-12-18T14:47:00.1096163Z ##[debug]loading INPUT_CONSIDERPARTIALLYSUCCESSFULRELEASES
2025-12-18T14:47:00.1098772Z ##[debug]loading INPUT_CUSTOMHANDLEBARSEXTENSIONFILE
2025-12-18T14:47:00.1100965Z ##[debug]loading INPUT_DUMPPAYLOADFILENAME
2025-12-18T14:47:00.1104673Z ##[debug]loading INPUT_DUMPPAYLOADTOCONSOLE
2025-12-18T14:47:00.1107490Z ##[debug]loading INPUT_DUMPPAYLOADTOFILE
2025-12-18T14:47:00.1112063Z ##[debug]loading INPUT_GETALLPARENTS
2025-12-18T14:47:00.1114898Z ##[debug]loading INPUT_GETINDIRECTPULLREQUESTS
2025-12-18T14:47:00.1118721Z ##[debug]loading INPUT_GETPARENTSANDCHILDREN
2025-12-18T14:47:00.1122925Z ##[debug]loading INPUT_GETPRDETAILS
2025-12-18T14:47:00.1124802Z ##[debug]loading INPUT_GETTESTEDBY
2025-12-18T14:47:00.1126732Z ##[debug]loading INPUT_INLINETEMPLATE
2025-12-18T14:47:00.1128389Z ##[debug]loading INPUT_MAXRETRIES
2025-12-18T14:47:00.1130854Z ##[debug]loading INPUT_OUTPUTFILE
2025-12-18T14:47:00.1132635Z ##[debug]loading INPUT_PAUSETIME
2025-12-18T14:47:00.1133841Z ##[debug]loading INPUT_RECURSIVELYCHECKCONSUMEDARTIFACTS
2025-12-18T14:47:00.1135529Z ##[debug]loading INPUT_REPLACEFILE
2025-12-18T14:47:00.1136775Z ##[debug]loading INPUT_SEARCHCROSSPROJECTFORPRS
2025-12-18T14:47:00.1137860Z ##[debug]loading INPUT_SHOWONLYPRIMARY
2025-12-18T14:47:00.1138968Z ##[debug]loading INPUT_SORTCS
2025-12-18T14:47:00.1140005Z ##[debug]loading INPUT_SORTWI
2025-12-18T14:47:00.1141575Z ##[debug]loading INPUT_STOPONERROR
2025-12-18T14:47:00.1142805Z ##[debug]loading INPUT_STOPONREDEPLOY
2025-12-18T14:47:00.1143887Z ##[debug]loading INPUT_TEMPLATEFILE
2025-12-18T14:47:00.1144957Z ##[debug]loading INPUT_TEMPLATELOCATION
2025-12-18T14:47:00.1146008Z ##[debug]loading INPUT_WIQLFROMTARGET
2025-12-18T14:47:00.1147091Z ##[debug]loading INPUT_WIQLWHERECLAUSE
2025-12-18T14:47:00.1149517Z ##[debug]loading SECRET_SYSTEM_ACCESSTOKEN
2025-12-18T14:47:00.1154776Z ##[debug]loaded 33
2025-12-18T14:47:00.1159944Z ##[debug]Agent.ProxyUrl=undefined
2025-12-18T14:47:00.1160353Z ##[debug]Agent.CAInfo=undefined
2025-12-18T14:47:00.1161799Z ##[debug]Agent.ClientCert=undefined
2025-12-18T14:47:00.1162055Z ##[debug]Agent.SkipCertValidation=undefined
2025-12-18T14:47:00.2367357Z ##[debug]Starting Tag XplatGenerateReleaseNotes task
2025-12-18T14:47:00.2367720Z ##[debug]System.TeamFoundationCollectionUri=https://dev.azure.com/WebDev/
2025-12-18T14:47:00.2368006Z ##[debug]System.TeamProject=ManagerService
2025-12-18T14:47:00.2373738Z ##[debug]templateLocation=Inline
2025-12-18T14:47:00.2375728Z ##[debug]templatefile=D:\RM_Agent\vsts-agent-win-x64-4.264.2_work\5\s
2025-12-18T14:47:00.2382633Z ##[debug]inlinetemplate=## Build {{buildDetails.buildNumber}}
Branch: {{buildDetails.sourceBranch}}
Author: {{buildDetails.requestedFor.displayName}}
Commit: {{buildDetails.sourceVersion}}

Build {{buildDetails.buildNumber}}

Branch: {{buildDetails.sourceBranch}}
Tags: {{buildDetails.tags}}
Completed: {{buildDetails.finishTime}}
Previous Build: {{compareBuildDetails.buildNumber}}

Associated Pull Requests ({{pullRequests.length}})

[{{this.pullRequestId}}]({{replace (replace this.url "_apis/git/repositories" "_git") "pullRequests" "pullRequest"}}) {{this.title}}
- Associated Work Items
  {{#forEach this.associatedWorkitems}}
  {{#with (lookup_a_work_item ../../relatedWorkItems this.url)}}
  - [{{this.id}}]({{replace this.url "_apis/wit/workItems" "_workitems/edit"}}) - {{lookup this.fields 'System.Title'}}
    {{/with}}
    {{/forEach}}
- Associated Commits (this includes commits on the PR source branch not associated directly with the build)
  {{#forEach this.associatedCommits}}
  - {{this.commitId}} - {{this.comment}}
    {{/forEach}}
    {{/forEach}}

Global list of WI with PRs, parents and children

WorkItems

{{this.id}} {{lookup this.fields 'System.Title'}}
- WIT {{lookup this.fields 'System.WorkItemType'}}
- Tags {{lookup this.fields 'System.Tags'}}
- Assigned
  {{#with (lookup this.fields 'System.AssignedTo')}}{{displayName}}{{/with}}
- Description
  {{{lookup this.fields 'System.Description'}}}
- PRs
  {{#forEach this.relations}}
  {{#if (contains this.attributes.name 'Pull Request')}}
  {{#with (lookup_a_pullrequest ../../pullRequests this.url)}}
  - {{this.pullRequestId}} - {{this.title}}
    {{/with}}
    {{/if}}
    {{/forEach}}
- Parents
  {{#forEach this.relations}}
  {{#if (contains this.attributes.name 'Parent')}}
  {{#with (lookup_a_work_item ../../relatedWorkItems this.url)}}
  - {{this.id}} - {{lookup this.fields 'System.Title'}}
    {{#forEach this.relations}}
    {{#if (contains this.attributes.name 'Parent')}}
    {{#with (lookup_a_work_item ../../../../relatedWorkItems this.url)}}
    - {{this.id}} - {{lookup this.fields 'System.Title'}}
    {{/with}}
    {{/if}}
    {{/forEach}}
    {{/with}}
    {{/if}}
    {{/forEach}}
- Children
  {{#forEach this.relations}}
  {{#if (contains this.attributes.name 'Child')}}
  {{#with (lookup_a_work_item ../../relatedWorkItems this.url)}}
  - {{this.id}} - {{lookup this.fields 'System.Title'}}
    {{/with}}
    {{/if}}
    {{/forEach}}
- Tested By
  {{#forEach this.relations}}
  {{#if (contains this.attributes.name 'Tested By')}}
  {{#with (lookup_a_work_item ../../testedByWorkItems this.url)}}
  - {{this.id}} - {{lookup this.fields 'System.Title'}}
    {{/with}}
    {{/if}}
    {{/forEach}}
    {{/forEach}}

Global list of CS ({{commits.length}})

Associated commits

ID {{this.id}}
- Message: {{this.message}}
- Committed by: {{this.author.displayName}}
- FileCount: {{this.changes.length}}
{{#forEach this.changes}}
- File path (TFVC or TfsGit): {{this.item.path}}
- File filename (GitHub): {{this.filename}}
  {{/forEach}}
  {{/forEach}}

List of WI returned by WIQL ({{queryWorkItems.length}})

{{this.id}} {{lookup this.fields 'System.Title'}}
{{/forEach}}

Manual Test Plans

Run ID	Name	State	Total Tests	Passed Tests
{{#forEach manualTests}}
{{this.id}}	{{this.name}}	{{this.state}}	{{this.totalTests}}	{{this.passedTests}}
{{/forEach}}

Global list of ConsumedArtifacts ({{consumedArtifacts.length}})

Category	Type	Version Name	Version Id	Commits	Workitems
{{#forEach consumedArtifacts}}
{{this.artifactCategory}}	{{this.artifactType}}	{{#if versionName}}{{versionName}}{{/if}}	{{truncate versionId 7}}	{{#if this.commits}}{{this.commits.length}}{{/if}}	{{#if this.workitems}}{{this.workitems.length}}{{/if}}
{{/forEach}}

Artifacts published by build ({{publishedArtifacts.length}})

Name	Type
{{#forEach publishedArtifacts}}
{{this.name}}	{{this.resource.type}}
{{/forEach}}

Work Items ({{relatedWorkItems.length}})

{{this.id}} – {{lookup this.fields 'System.Title'}}
- Type: {{lookup this.fields 'System.WorkItemType'}}
- Assigned To: {{#with (lookup this.fields 'System.AssignedTo')}}{{displayName}}{{/with}}
- Created: {{lookup this.fields 'System.CreatedDate'}}
- Last Updated: {{lookup this.fields 'System.ChangedDate'}}
- Description:
  {{{lookup this.fields 'System.Description'}}}
  {{/forEach}}
  2025-12-18T14:47:00.2385634Z ##[debug]outputfile=D:\RM_Agent\vsts-agent-win-x64-4.264.2_work\5\s\releasenotes_14053.md
  2025-12-18T14:47:00.2385916Z ##[debug]outputVariableName=undefined
  2025-12-18T14:47:00.2386159Z ##[debug]showOnlyPrimary=False
  2025-12-18T14:47:00.2386412Z ##[debug]replaceFile=true
  2025-12-18T14:47:00.2386647Z ##[debug]appendToFile=True
  2025-12-18T14:47:00.2386891Z ##[debug]getParentsAndChildren=False
  2025-12-18T14:47:00.2387671Z ##[debug]searchCrossProjectForPRs=False
  2025-12-18T14:47:00.2387940Z ##[debug]overrideActiveBuildReleaseId=undefined
  2025-12-18T14:47:00.2388191Z ##[debug]overrideStageName=undefined
  2025-12-18T14:47:00.2388873Z ##[debug]stopOnRedeploy=False
  2025-12-18T14:47:00.2389753Z ##[debug]SortWi=False
  2025-12-18T14:47:00.2390630Z ##[debug]SortCS=False
  2025-12-18T14:47:00.2390994Z ##[debug]customHandlebarsExtensionCodeAsFile=undefined
  2025-12-18T14:47:00.2391258Z ##[debug]customHandlebarsExtensionCode=undefined
  2025-12-18T14:47:00.2391671Z ##[debug]customHandlebarsExtensionFile=customHandlebarsExtension
  2025-12-18T14:47:00.2391948Z ##[debug]customHandlebarsExtensionFolder=undefined
  2025-12-18T14:47:00.2392198Z ##[debug]gitHubPat=undefined
  2025-12-18T14:47:00.2392452Z ##[debug]bitbucketSecret=undefined
  2025-12-18T14:47:00.2392693Z ##[debug]bitbucketUser=undefined
  2025-12-18T14:47:00.2392943Z ##[debug]dumpPayloadToFile=true
  2025-12-18T14:47:00.2393719Z ##[debug]dumpPayloadToConsole=true
  2025-12-18T14:47:00.2394560Z ##[debug]dumpPayloadFileName=D:\RM_Agent\vsts-agent-win-x64-4.264.2_work\5\s\dump.txt
  2025-12-18T14:47:00.2395251Z ##[debug]checkStage=false
  2025-12-18T14:47:00.2396218Z ##[debug]getAllParents=False
  2025-12-18T14:47:00.2396475Z ##[debug]tags=undefined
  2025-12-18T14:47:00.2396714Z ##[debug]overridePat=undefined
  2025-12-18T14:47:00.2396981Z ##[debug]overrideBuildReleaseId=undefined
  2025-12-18T14:47:00.2397254Z ##[debug]getIndirectPullRequests=False
  2025-12-18T14:47:00.2398070Z ##[debug]stopOnError=False
  2025-12-18T14:47:00.2398910Z ##[debug]considerPartiallySuccessfulReleases=False
  2025-12-18T14:47:00.2399664Z ##[debug]checkForManuallyLinkedWI=true
  2025-12-18T14:47:00.2400487Z ##[debug]wiqlWhereClause=[System.TeamProject] = 'DevBoard'
  AND [System.ChangedDate] >= @today - 7
  2025-12-18T14:47:00.2401208Z ##[debug]getPRDetails=true
  2025-12-18T14:47:00.2401468Z ##[debug]getPRDetailsRepositoryId=undefined
  2025-12-18T14:47:00.2401723Z ##[debug]getPRDetailsRefName=undefined
  2025-12-18T14:47:00.2402177Z ##[debug]getTestedBy=true
  2025-12-18T14:47:00.2402932Z ##[debug]wiqlFromTarget=WorkItems
  2025-12-18T14:47:00.2403197Z ##[debug]wiqlSharedQueryName=undefined
  2025-12-18T14:47:00.2404122Z ##[debug]recursivelyCheckConsumedArtifacts=false
  2025-12-18T14:47:00.2404884Z ##[debug]maxRetries=20
  2025-12-18T14:47:00.2405503Z ##[debug]Build.BuildId=14053
  2025-12-18T14:47:00.2405849Z ##[debug]Release.ReleaseId=undefined
  2025-12-18T14:47:00.2406107Z ##[debug]Release.DefinitionId=undefined
  2025-12-18T14:47:00.2406380Z ##[debug]Release_EnvironmentName=undefined
  2025-12-18T14:47:00.2406641Z ##[debug]ReleaseNotes.Fix349=undefined
  2025-12-18T14:47:00.2437050Z Creating Azure DevOps API connections for https://dev.azure.com/WebDev/ with 'allowRetries' set to 'true' and 'maxRetries' count to '20'
  2025-12-18T14:47:00.2440487Z ##[debug]Getting System.AccessToken
  2025-12-18T14:47:00.2440927Z ##[debug]Getting credentials the agent is running as
  2025-12-18T14:47:00.2443571Z ##[debug]SYSTEMVSSCONNECTION exists true
  2025-12-18T14:47:00.2443866Z ##[debug]Found an OAUTH token
  2025-12-18T14:47:00.2444272Z Creating the credential handler from the OAUTH token
  2025-12-18T14:47:00.3167881Z ##[debug]Agent environment resources - Disk: D:\ Available 103673.91 MB out of 204799.00 MB, Memory: Used 7055.00 MB out of 16383.00 MB, CPU: Usage 23.00%
  2025-12-18T14:47:00.4804869Z Getting the current build details
  2025-12-18T14:47:00.5641139Z Getting artifacts published by the current build
  2025-12-18T14:47:00.6115034Z Getting items associated with only the current build
  2025-12-18T14:47:00.8739141Z Get the artifacts consumed by the build
  2025-12-18T14:47:00.8742382Z ##[debug]Request payload: {"contributionIds":["ms.vss-build-web.run-consumed-artifacts-data-provider"],"dataProviderContext":{"properties":{"buildId":"14053","sourcePage":{"url":"https://dev.azure.com/WebDev//ManagerService/_build/results?buildId=14053&view=results","routeId":"ms.vss-build-web.ci-results-hub-route","routeValues":{"project":"ManagerService","viewname":"build-results","controller":"ContributedPage","action":"Execute"}}}}}
  2025-12-18T14:47:00.8742911Z ##[debug]Request URL: https://dev.azure.com/WebDev//_apis/Contribution/HierarchyQuery/project/ManagerService?api-version=5.1-preview
  2025-12-18T14:47:00.9318809Z ##[debug]Request response: {"statusCode":200,"result":{"dataProviderSharedData":{},"dataProviders":{"ms.vss-web.component-data":{},"ms.vss-web.shared-data":null,"ms.vss-build-web.run-consumed-artifacts-data-provider":{"buildId":14053,"buildNumber":"20251218.3","definitionId":47,"definitionName":"RM_Alpha_Version_Builder","consumedSources":[]}}},"headers":{"cache-control":"no-cache","pragma":"no-cache","content-length":"292","content-type":"application/json; charset=utf-8; api-version=5.1-preview.1","expires":"-1","p3p":"CP="CAO DSP COR ADMa DEV CONo TELo CUR PSA PSD TAI IVDo OUR SAMi BUS DEM NAV STA UNI COM INT PHY ONL FIN PUR LOC CNT"","x-tfs-processid":"1165512e-b7ef-4d51-ba3b-7dbce86004cf","strict-transport-security":"max-age=31536000; includeSubDomains","activityid":"6039e875-1a76-42bd-9847-b807b770e96a","x-tfs-session":"6039e875-1a76-42bd-9847-b807b770e96a","x-vss-e2eid":"6039e875-1a76-42bd-9847-b807b770e96a","x-vss-senderdeploymentid":"b99a1d20-e935-0212-66ea-53052623a333","x-vss-userdata":"4952ba6e-8f7c-4470-8c0d-01c2ef7cbdf0:de8dcf63-8350-4ac4-aec4-59f13b199693","x-frame-options":"SAMEORIGIN","request-context":"appId=cid-v1:60025946-10bc-42f1-8e6e-a3f240250b2d","access-control-expose-headers":"Request-Context","x-content-type-options":"nosniff","x-cache":"CONFIG_NOCACHE","x-msedge-ref":"Ref A: 472726ABA9D44E7B9EA0C99A21E0DF55 Ref B: VIEEDGE4108 Ref C: 2025-12-18T14:47:00Z","date":"Thu, 18 Dec 2025 14:47:00 GMT"}}
  2025-12-18T14:47:00.9320767Z ##[debug]Request response.result: {"dataProviderSharedData":{},"dataProviders":{"ms.vss-web.component-data":{},"ms.vss-web.shared-data":null,"ms.vss-build-web.run-consumed-artifacts-data-provider":{"buildId":14053,"buildNumber":"20251218.3","definitionId":47,"definitionName":"RM_Alpha_Version_Builder","consumedSources":[]}}}
  2025-12-18T14:47:00.9321458Z Get the file details associated with the commits
  2025-12-18T14:47:00.9325111Z Enriched change 21123544 of type TfsGit
  2025-12-18T14:47:01.0991903Z Enriched with details of 3 files
  2025-12-18T14:47:01.0992253Z Enriched change 7487978 of type TfsGit
  2025-12-18T14:47:01.1480560Z Enriched with details of 3 files
  2025-12-18T14:47:01.1480821Z Enriched change 89797878 of type TfsGit
  2025-12-18T14:47:01.2113565Z Enriched with details of 3 files
  2025-12-18T14:47:01.2113903Z Get any test details associated with the build
  2025-12-18T14:47:01.3733679Z ##[debug]Found 0 automated test results associated with the build
  2025-12-18T14:47:01.3734098Z ##[debug]No automated tests associated with build 14053
  2025-12-18T14:47:01.3734295Z Get any manual test run details associated with the build
  2025-12-18T14:47:01.3737438Z ##[debug]Get batch of manual test runs [0] - [1000]
  2025-12-18T14:47:01.5704411Z ##[debug]Found 0 manual test runs associated with the build
  2025-12-18T14:47:01.5704811Z ##[debug]No manual test plans associated with build
  2025-12-18T14:47:01.5705006Z Removing duplicate Commits from master list
  2025-12-18T14:47:01.5709196Z Expanding the truncated commit messages...
  2025-12-18T14:47:01.5709481Z ##[debug]Expanding commit [7487978]
  2025-12-18T14:47:01.5709744Z ##[debug]Need to expand details from Azure DevOps
  2025-12-18T14:47:01.6200954Z Expanded truncated commit messages 1
  2025-12-18T14:47:01.6201219Z Leaving CS in default order as returned by API
  2025-12-18T14:47:01.6201376Z Find any WorkItems linked from GitHub using the AB#123 format
  2025-12-18T14:47:01.6203580Z Adding 0 found using AB#123 links in GitHub comments
  2025-12-18T14:47:01.6203741Z Removing duplicate WorkItems from master list
  2025-12-18T14:47:01.6205109Z Getting tests linked to WorkItems
  2025-12-18T14:47:01.6206239Z Checking for user defined WIQL query
  2025-12-18T14:47:01.6208521Z Getting Work Items using WIQL query parameters
  2025-12-18T14:47:01.6209307Z Getting Work Items using WIQL query
  2025-12-18T14:47:01.6209759Z ##[debug]SELECT [System.Id] FROM WorkItems WHERE [System.TeamProject] = 'DevBoard'
  AND [System.ChangedDate] >= @today - 7 ORDER BY [System.ID] DESC
  2025-12-18T14:47:01.7737172Z Found 0 WI using WIQL
  2025-12-18T14:47:01.7737443Z Leaving WI in default order as returned by API
  2025-12-18T14:47:01.7737822Z ##[debug]Getting the details of build 14053 from default project
  2025-12-18T14:47:01.8185896Z The default artifact for the release was not linked to an Azure DevOps Git Repo Pull Request
  2025-12-18T14:47:01.8186214Z Getting all completed Azure DevOps Git Repo PRs in the Team Project ManagerService
  2025-12-18T14:47:01.8186377Z Getting all completed Azure DevOps Git Repo PRs for all repositories
  2025-12-18T14:47:01.8186524Z Getting all completed Azure DevOps Git Repo PRs for all refs
  2025-12-18T14:47:01.8186686Z Getting associated PRs
  2025-12-18T14:47:01.8189026Z ##[debug]Get batch of PRs [0] - [1000]
  2025-12-18T14:47:01.9030619Z ##[debug]Adding batch of 13 PRs
  2025-12-18T14:47:01.9030924Z Found 13 Azure DevOps PRs in the repo
  2025-12-18T14:47:01.9031552Z Checking for PRs associated with the commit 21123544
  2025-12-18T14:47:01.9032005Z Checking for PRs associated with the commit 7487978
  2025-12-18T14:47:01.9032256Z - PR 2319 matches the commit 7487978
  2025-12-18T14:47:01.9032455Z Checking for PRs associated with the commit 89797878
  2025-12-18T14:47:01.9032793Z Enriching known Pull Requests
  2025-12-18T14:47:01.9505472Z ##[debug]Checking for tags for 2319
  2025-12-18T14:47:02.0827246Z ##[debug]Added 0 work items for 2319
  2025-12-18T14:47:02.1955870Z ##[debug]Added 1 commits for 2319, note this includes commits on the PR source branch not associated directly with the build
  2025-12-18T14:47:02.1957353Z Total Builds: [0]
  2025-12-18T14:47:02.1957696Z Total Commits: [3]
  2025-12-18T14:47:02.1957811Z Total Workitems: [0]
  2025-12-18T14:47:02.1957959Z Total Related Workitems (Parent/Children): [0]
  2025-12-18T14:47:02.1958106Z Total Release Tests: [0]
  2025-12-18T14:47:02.1958227Z Total Tests: [0]
  2025-12-18T14:47:02.1958354Z Total Manual Test Runs: [0]
  2025-12-18T14:47:02.1958474Z Total Manual Test Configurations: [0]
  2025-12-18T14:47:02.1958590Z Total Pull Requests: [1]
  2025-12-18T14:47:02.1958713Z Total Indirect Pull Requests: [0]
  2025-12-18T14:47:02.1958844Z Total Associated Test WI: [0]
  2025-12-18T14:47:02.1958960Z Total Published Artifacts: [0]
  2025-12-18T14:47:02.1959081Z Total Consumed Artifacts: [0]
  2025-12-18T14:47:02.1959195Z Total WIQL Workitems: [0]
  2025-12-18T14:47:02.1962509Z Start of payload data dump
  2025-12-18T14:47:02.1973025Z {"workItems":[],"commits":[...]}
  2025-12-18T14:47:02.1983048Z End of payload data dump
  2025-12-18T14:47:02.1983267Z Writing payload data to file D:\RM_Agent\vsts-agent-win-x64-4.264.2_work\5\s\dump.txt
  2025-12-18T14:47:02.1983500Z Generating the release notes, the are 1 template(s) to process
  2025-12-18T14:47:02.1983993Z ##[debug]Using template mode Inline
  2025-12-18T14:47:02.1984211Z Using in-line template
  2025-12-18T14:47:02.1984506Z ##[debug]Loading handlebar template
  2025-12-18T14:47:02.1984897Z ##[debug]Processing template
  2025-12-18T14:47:02.1985262Z ##[debug] WI: 0
  2025-12-18T14:47:02.1985619Z ##[debug] CS: 3
  2025-12-18T14:47:02.1985992Z ##[debug] PR: 1
  2025-12-18T14:47:02.1986358Z ##[debug] Builds: 0
  2025-12-18T14:47:02.1986788Z ##[debug] Manual Tests: 0
  2025-12-18T14:47:02.1987167Z ##[debug] Manual TestConfigurations: 0
  2025-12-18T14:47:02.1987593Z ##[debug] Release Tests: 0
  2025-12-18T14:47:02.1988009Z ##[debug] Related WI: 0
  2025-12-18T14:47:02.1988531Z ##[debug] Related Tests: 0
  2025-12-18T14:47:02.1988961Z ##[debug] Indirect PR: 0
  2025-12-18T14:47:02.1989427Z ##[debug] Consumed Artifacts: 0
  2025-12-18T14:47:02.1989868Z ##[debug] Published Artifacts: 0
  2025-12-18T14:47:02.1990226Z ##[debug] Query WI: 0
  2025-12-18T14:47:02.1990573Z ##[debug]Processing handlebar template
  2025-12-18T14:47:02.2282923Z Loading handlebars-helpers extension
  2025-12-18T14:47:02.4378456Z ##[debug]Attempting to load custom handlebars extension from D:\RM_Agent\vsts-agent-win-x64-4.264.2_work_tasks\XplatGenerateReleaseNotes_7b0a5887-75c4-4ade-a915-f92a93c934cb\4.27.4\customHandlebarsExtension.js}
  2025-12-18T14:47:02.4379130Z ##[debug]Custom handlebars extension file does not exist
  2025-12-18T14:47:02.4700584Z Completed processing template
  2025-12-18T14:47:02.4700903Z Writing output file D:\RM_Agent\vsts-agent-win-x64-4.264.2_work\5\s\releasenotes_14053.md
  2025-12-18T14:47:02.4705559Z Finished writing output file D:\RM_Agent\vsts-agent-win-x64-4.264.2_work\5\s\releasenotes_14053.md
  2025-12-18T14:47:02.4705785Z Output variable 'undefined' set to value of first generated release notes
  2025-12-18T14:47:02.4707367Z ##[debug]task result: Succeeded
  2025-12-18T14:47:02.4709438Z ##[debug]Processed: ##vso[task.complete result=Succeeded;]
  2025-12-18T14:47:02.4985090Z ##[section]Finishing: Generate Release Notes`

And the resulting notes:

`## Build 20251218.3
Branch: refs/heads/master
Author:
Commit: 78945613

Build 20251218.3

Branch: refs/heads/master
Tags:
Completed:
Previous Build:

Associated Pull Requests (1)

2319 #8795 #8794 Test PR for RN generation
- Associated Work Items
- Associated Commits (this includes commits on the PR source branch not associated directly with the build)
  - 123456 - #8795 #8794 Test PR for RN generation Test

Global list of WI with PRs, parents and children

Global list of CS (3)

Associated commits

ID 78945613
- Message: Update RM_Alpha_Version_Builder.yml for Azure Pipelines
- Committed by:
- FileCount: 3
- File path (TFVC or TfsGit): /ManagerService.Pipeline
- File filename (GitHub):
- File path (TFVC or TfsGit): /ManagerService.Pipeline/Pipelines
- File filename (GitHub):
- File path (TFVC or TfsGit): /ManagerService.Pipeline/Pipelines/RM_Alpha_Version_Builder.yml
- File filename (GitHub):
ID 456798
- Message: Merged PR 2319: #8795 #8794 Test PR for RN generation

#8795 #8794 Test PR for RN generation Test

Related work items: #8794, #8795

Committed by:
FileCount: 3
File path (TFVC or TfsGit): /ManagerService.Pipeline
File filename (GitHub):
File path (TFVC or TfsGit): /ManagerService.Pipeline/ReleaseNotes
File filename (GitHub):
File path (TFVC or TfsGit): /ManagerService.Pipeline/ReleaseNotes/AlphaReleaseTemplate.md
File filename (GitHub):

ID 123456
- Message: #8795 #8794 Test PR for RN generation
- Committed by:
- FileCount: 3
- File path (TFVC or TfsGit): /ManagerService.Pipeline
- File filename (GitHub):
- File path (TFVC or TfsGit): /ManagerService.Pipeline/ReleaseNotes
- File filename (GitHub):
- File path (TFVC or TfsGit): /ManagerService.Pipeline/ReleaseNotes/AlphaReleaseTemplate.md
- File filename (GitHub):

List of WI returned by WIQL (0)

Manual Test Plans

Run ID	Name	State	Total Tests	Passed Tests

Global list of ConsumedArtifacts (0)

Category	Type	Version Name	Version Id	Commits	Workitems

Artifacts published by build (0)

Name	Type

Work Items (0)`

Can anybody point me in the right direction?

Thanks for helping!

rfennell · 2025-12-18T16:06:10Z

rfennell
Dec 18, 2025
Maintainer

In general I a couple of things to people new to the task

Initially test with a simple team projects/repo/template setup
To avoid having to run loads of build runs- use the Local test Console

That said, as soon as multiple team projects are involved, with commits in different projects to work items, you correct that going down the WIQL route is a good idea.

The log shows our WIQL being run, but it returns nothing

2025-12-18T14:47:01.6208521Z Getting Work Items using WIQL query parameters
2025-12-18T14:47:01.6209307Z Getting Work Items using WIQL query
2025-12-18T14:47:01.6209759Z ##[debug]SELECT [System.Id] FROM WorkItems WHERE [System.TeamProject] = 'DevBoard'
AND [System.ChangedDate] >= @today - 7 ORDER BY [System.ID] DESC
2025-12-18T14:47:01.7737172Z Found 0 WI using WIQL

So that explains the result, I guess there is an issue with the query.

If you have not installed it already try installing the Azure DevOps WIQL Editor, it lets you run WIQL directly and has some intellisense to help edit it.

0 replies

drahcir9000 · 2025-12-19T13:45:16Z

drahcir9000
Dec 19, 2025
Author

Hi Richard,

thanks for your fast response! I tried the WIQL editor and the query worked there. I will try the local test console next.
Was hoping that I missed something obvious but I guess it must be something tricky.

BR Richard

4 replies

drahcir9000 Dec 21, 2025
Author

HI @rfennell ,

I ran the local test console for a classic build /YAML pipeline.
For the test I did not set a releaseId and also no WIQL query. The PAT is from the project the repo and pipeline run in.
Everything worked right from the start. Commit details, work item details alongside PR details are all there.

`Checking for PRs associated with the commit bed2c128ff57dad2cba6486dc91f35b1a69fe50c

PR 1874 does not have a lastMergeCommit
PR 1578 does not have a lastMergeCommit
PR 1571 does not have a lastMergeCommit
PR 1577 does not have a lastMergeCommit
PR 1572 does not have a lastMergeCommit
PR 961 does not have a lastMergeCommit
PR 609 does not have a lastMergeCommit
PR 310 does not have a lastMergeCommit
PR 336 does not have a lastMergeCommit
PR 311 does not have a lastMergeCommit
Enriching known Pull Requests
##vso[task.debug]Checking for tags for 2135
##vso[task.debug]Added 1 work items for 2135
##vso[task.debug]Added 2 commits for 2135, note this includes commits on the PR source branch not associated directly with the build
##vso[task.debug]Checking for tags for 2215
##vso[task.debug]Added 3 work items for 2215
##vso[task.debug]Added 4 commits for 2215, note this includes commits on the PR source branch not associated directly with the build
##vso[task.debug]Checking for tags for 2240
##vso[task.debug]Added 2 work items for 2240
##vso[task.debug]Added 2 commits for 2240, note this includes commits on the PR source branch not associated directly with the build
##vso[task.debug]Checking for tags for 2319
##vso[task.debug]Added 2 work items for 2319
##vso[task.debug]Added 1 commits for 2319, note this includes commits on the PR source branch not associated directly with the build
##vso[task.debug]Added 2 work items for 2325
##vso[task.debug]Added 1 commits for 2325, note this includes commits on the PR source branch not associated directly with the build
Total Builds: [0]
Total Commits: [292]
Total Workitems: [12]
Total Related Workitems (Parent/Children): [31]
Total Release Tests: [0]
Total Tests: [0]
Total Manual Test Runs: [0]
Total Manual Test Configurations: [0]
Total Pull Requests: [5]
Total Indirect Pull Requests: [0]
Total Associated Test WI: [0]
Total Published Artifacts: [0]
Total Consumed Artifacts: [0]
Total WIQL Workitems: [0]`

I tried to run the task in the pipeline with the same parameters in the query but I still get no work items. Is there any parameter/permission I need to set?

drahcir9000 Dec 21, 2025
Author

I guess, I found a solution. Setting the OverridePat seems to help.

rfennell Dec 21, 2025
Maintainer

Ah, that makes sense, the build agent's auto generated PAT will probably be scoped to the current team projects, so not seeing WI in the other team project. Your PAT does not suffer this issue.

You could look changing the settings that control the scope of the build agent's auto generated PAT

drahcir9000 Dec 24, 2025
Author

This is one of the things I tried initially but it does not have an impact on the results.
Since OverridePat is fulfilling our needs I am happy.

I will close this post. Thank you for your help and the awesome extension.

And merry Christmas!

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Work items are not showing up in release notes #2171

Uh oh!

{{title}}

Uh oh!

Replies: 2 comments 4 replies

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{title}}

Uh oh!

Select a reply

Uh oh!

Work items are not showing up in release notes #2171

Uh oh!

drahcir9000 Dec 18, 2025

Build {{buildDetails.buildNumber}}

Associated Pull Requests ({{pullRequests.length}})

Global list of WI with PRs, parents and children

WorkItems

Global list of CS ({{commits.length}})

Associated commits

List of WI returned by WIQL ({{queryWorkItems.length}})

Manual Test Plans

Global list of ConsumedArtifacts ({{consumedArtifacts.length}})

Artifacts published by build ({{publishedArtifacts.length}})

Work Items ({{relatedWorkItems.length}})

Build 20251218.3

Associated Pull Requests (1)

Global list of WI with PRs, parents and children

Global list of CS (3)

Associated commits

List of WI returned by WIQL (0)

Manual Test Plans

Global list of ConsumedArtifacts (0)

Artifacts published by build (0)

Work Items (0)`

Replies: 2 comments · 4 replies

Uh oh!

rfennell Dec 18, 2025 Maintainer

Uh oh!

drahcir9000 Dec 19, 2025 Author

Uh oh!

drahcir9000 Dec 21, 2025 Author

Uh oh!

drahcir9000 Dec 21, 2025 Author

Uh oh!

rfennell Dec 21, 2025 Maintainer

Uh oh!

drahcir9000 Dec 24, 2025 Author

drahcir9000
Dec 18, 2025

Replies: 2 comments 4 replies

rfennell
Dec 18, 2025
Maintainer

drahcir9000
Dec 19, 2025
Author

drahcir9000 Dec 21, 2025
Author

drahcir9000 Dec 21, 2025
Author

rfennell Dec 21, 2025
Maintainer

drahcir9000 Dec 24, 2025
Author