unable to make the migration tool to take query for migration context into account

[dbru540]

i try to execute a migration of a project's work items and i setted up in the config file, a query to filter the list of work items to migrate.

but it does not seems to be taken into account.

`{
"Version": "15.0",
"LogLevel": "Debug",
"workaroundForQuerySOAPBugEnabled": false,
"Source": {
"$type": "TfsTeamProjectConfig",
"Collection": "https://dev.azure.com/***/",
"Project": "",
"ReflectedWorkItemIDFieldName": "Custom.ReflectedWorkItemId",
"AuthenticationMode": "AccessToken",
"AllowCrossProjectLinking": false,
"PersonalAccessToken": "",
"LanguageMaps": {
"AreaPath": "Area",
"IterationPath": "Iteration"
}
},
"Target": {
"$type": "TfsTeamProjectConfig",
"Collection": "https://dev.azure.com/***/",
"Project": "",
"ReflectedWorkItemIDFieldName": "Custom.ReflectedWorkItemId",
"AuthenticationMode": "AccessToken",
"AllowCrossProjectLinking": false,
"PersonalAccessToken": "",
"LanguageMaps": {
"AreaPath": "Area",
"IterationPath": "Iteration"
}
},
"FieldMaps": [
{
"$type": "RegexFieldMapConfig",
"WorkItemTypeName": "",
"sourceField": "System.AreaPath",
"targetField": "System.AreaPath",
"pattern": "AX7_TF\\(.)",
"replacement": "OLD-CityzMedia\$1",
"valueMapping": { "AX7_TF" : "OLD-CityzMedia\$1" }
},
{
"$type": "RegexFieldMapConfig",
"WorkItemTypeName": "",
"sourceField": "System.IterationPath",
"targetField": "System.IterationPath",
"pattern": "AX7_TF\\(.)",
"replacement": "OLD-CityzMedia\$1",
"valueMapping": { "AX7_TF" : "OLD-CityzMedia\$1" }
}
],
"WorkItemTypeDefinition": {
"sourceWorkItemTypeName": "targetWorkItemTypeName"
},
"Processors": [
{
"$type": "WorkItemMigrationConfig",
"Enabled": true,
"ReplayRevisions": true,
"PrefixProjectToNodes": false,
"UpdateCreatedDate": false,
"UpdateCreatedBy": false,
"WIQLQueryBit": " AND [System.WorkItemType] NOT IN ('Code Review Response','Code Review Request') AND [System.id] >= 19200 ",
"WIQLOrderBit": "[System.ChangedDate] desc",
"LinkMigration": true,
"AttachmentMigration": true,
"AttachmentWorkingPath": "C:\Users\*\",
"FixHtmlAttachmentLinks": true,
"SkipToFinalRevisedWorkItemType": false,
"WorkItemCreateRetryLimit": 5,
"FilterWorkItemsThatAlreadyExistInTarget": true,
"PauseAfterEachWorkItem": false,
"AttachmentMaxSize": 480000000,
"AttachRevisionHistory": false,
"LinkMigrationSaveEachAsAdded": false,
"GenerateMigrationComment": false,
"WorkItemIDs": null,
"MaxRevisions": 0,
"NodeStructureEnricherEnabled": true,
"UseCommonNodeStructureEnricherConfig": false,
"ShouldCreateMissingRevisionPaths": true,
"NodeBasePaths": [],
"AreaMaps": {},
"IterationMaps": {
},
"MaxGracefulFailures": 0
}

]
}`

[MrHinsh]

These two properties do not exist:

"WIQLQueryBit": " AND [System.WorkItemType] NOT IN ('Code Review Response','Code Review Request') AND [System.id] >= 19200 ",
"WIQLOrderBit": "[System.ChangedDate] desc",

It looks like you have copied and pasted some old config data into the new v15 format. This is not supported. I recommend recreating the config from scratch.