unable to migrate a team board instead it is reading query with all workitems in the project

[shiva-gattu]

I want to migrate a team board below is the script
{
"ChangeSetMappingFile": null,
"Source": {
"$type": "TfsTeamProjectConfig",
"Collection": "OrgA",
"Project": "Project A",
"ReflectedWorkItemIDFieldName": "Custom.ReflectedWorkItemId",
"AllowCrossProjectLinking": false,
"AuthenticationMode": "Prompt",
"PersonalAccessToken": "",
"LanguageMaps": {
"AreaPath": "Area",
"IterationPath": "Iteration"
},
},
"Target": {
"$type": "TfsTeamProjectConfig",
"Collection": "Org B",
"Project": "Project B",
"ReflectedWorkItemIDFieldName": "Custom.ReflectedWorkItemId",
"AllowCrossProjectLinking": false,
"AuthenticationMode": "Prompt",
"PersonalAccessToken": "",
"LanguageMaps": {
"AreaPath": "Area",
"IterationPath": "Iteration"
},
},
"FieldMaps": [],
"GitRepoMapping": null,
"LogLevel": "Debug",
"Processors": [
{
"$type": "WorkItemMigrationConfig",
"Enabled": false,
"ReplayRevisions": true,
"PrefixProjectToNodes": false,
"BuildFieldTable": false,
"UpdateCreatedDate": true,
"UpdateCreatedBy": true,
"WIQLQuery": "AND [System.AreaPath] UNDER 'Project A\Area1\Area2' AND [System.WorkItemType] NOT IN ('Shared Steps', 'Shared Parameters')",
"WIQLOrderBit": "[System.ChangedDate] desc",
"LinkMigration": true,
"AttachmentMigration": true,
"AttachmentWorkingPath": "c:\temp\WorkItemAttachmentWorkingFolder\",
"FixHtmlAttachmentLinks": false,
"WorkItemCreateRetryLimit": 5,
"FilterWorkItemsThatAlreadyExistInTarget": false,
"PauseAfterEachWorkItem": false,
"AttachmentMaxSize": 480000000,
"AttachRevisionHistory": false,
"GenerateMigrationComment": true,
"LinkMigrationSaveEachAsAdded": false,
"NodeStructureEnricherEnabled": null,
"WorkItemIDs": null,
"NodeBasePaths": [],
"MaxGracefulFailures": 0,
"SkipRevisionWithInvalidIterationPath": true,
"SkipRevisionWithInvalidAreaPath": true
}
],
"Version": "15.0",
"workaroundForQuerySOAPBugEnabled": false,
"WorkItemTypeDefinition": {
"sourceWorkItemTypeName": "targetWorkItemTypeName"
},

}

but wiql query is reading all the workitems in migration

[MrHinsh]

Your WIQLQuery is invalid.

{
      "$type": "WorkItemMigrationConfig",
      "Enabled": false,
      "UpdateCreatedDate": true,
      "UpdateCreatedBy": true,
      "WIQLQuery": "SELECT [System.Id] FROM WorkItems WHERE [System.TeamProject] = @TeamProject AND [System.WorkItemType] NOT IN ('Test Suite', 'Test Plan','Shared Steps','Shared Parameter','Feedback Request') ORDER BY [System.ChangedDate] desc",
      "FixHtmlAttachmentLinks": false,
      "WorkItemCreateRetryLimit": 5,
      "FilterWorkItemsThatAlreadyExistInTarget": false,
      "PauseAfterEachWorkItem": false,
      "AttachRevisionHistory": false,
      "GenerateMigrationComment": true,
      "WorkItemIDs": null,
      "MaxGracefulFailures": 0,
      "SkipRevisionWithInvalidIterationPath": false,
      "SkipRevisionWithInvalidAreaPath": false
    },

[MrHinsh]

You can create a WIQL query that filters just what you need.

The content of your query above was invalid.

[shiva-gattu]

{
"query": {
"id": "00000000-0000-0000-0000-000000000000",
"name": "Untitled query",
"isPublic": false,
"wiql": "SELECT [System.Id], [System.WorkItemType], [System.Title], [System.AssignedTo], [System.State], [System.Tags] FROM Workitems WHERE [System.TeamProject] = @project AND [System.WorkItemType]<>'' AND [System.State]<>''",
"path": null
}
} This is the WIQL query when i run query in editor

there is no where it is showing areapath. when i execute the migration getting below SS.

Is there a way where i can downgrade the version to 13. or please help me with currect query

[MrHinsh]

I'm sorry, I really don't understand what you need. This is a WIQL query, same as used in all versions of the tool. The only difference is that the latest version allows you to control the whole query.

To filter by Area path you can follow WIQL: Area and Iteration Path

[shiva-gattu]

I got this Thank you Hinsh.

WIQLQuery": "SELECT [System.Id] FROM WorkItems WHERE [System.TeamProject] = @teamproject AND [System.AreaPath] UNDER 'Project A\Team A' [System.WorkItemType] NOT IN ('Test Suite', 'Test Plan','Shared Steps','Shared Parameter','Feedback Request') ORDER BY [System.ChangedDate] desc",

Also set "Enabled": True, it worked. Only issue is Authentication Mode prompt is not working we need to set Accesstoken.

But its working now Thanks Again

[MrHinsh]

We plan on removing Prompt as there are many things that only run with a token.