Area path and @TeamProject in WIQLQuery in TfsWorkItemMigrationProcessor

[kiseta]

I'm trying to understand how the following setup of area path and team field would affect the configuration.json file.

So it is required to use @TeamProject in WIQLQuery in TfsWorkItemMigrationProcessor

here is the query

However here is how the area path and the team fields are setup

We are using TfsNodeStructureTool and mapping everything to top ProjectNameTeam

Any ideas? Any other tools/processors we sould add to configuration file to handle this? Any changes to mapping for AreaPath and Iterations?

{
    "Serilog": {
        "MinimumLevel": "Debug"
    },
    "MigrationTools": {
        "Version": "16.0",
        "Endpoints": {
            "Source": {
                "EndpointType": "TfsTeamProjectEndpoint",
                "Collection": "https://servername.smthelse.ProjectTeamName.com/tfs/Collection/",
                "Project": "ProjectTeamName",
                "ReflectedWorkItemIdField": "TfsMigrationTool.ReflectedWorkItemId",
                "AllowCrossProjectLinking": false,
                "Authentication": {
                    "AccessToken": "Redacted",
                    "AuthenticationMode": "AccessToken"
                },
                "LanguageMaps": {
                    "AreaPath": "Area",
                    "IterationPath": "Iteration"
                },
                "EndpointEnrichers": null
            },
            "Target": {
                "EndpointType": "TfsTeamProjectEndpoint",
                "Collection": "https://dev.azure.com/TargetOrganizationName/",
                "Project": "ProjectTeamName",
                "ReflectedWorkItemIdField": "TfsMigrationTool.ReflectedWorkItemId",
                "AllowCrossProjectLinking": false,
                "Authentication": {
                    "AccessToken": "Redacted",
                    "AuthenticationMode": "AccessToken"
                },
                "LanguageMaps": {
                    "AreaPath": "Area",
                    "IterationPath": "Iteration"
                },
                "EndpointEnrichers": null
            }
        },
        "Processors": [
            {
                "ProcessorType": "TfsWorkItemMigrationProcessor",
                "Enabled": true,
                "UpdateCreatedDate": true,
                "UpdateCreatedBy": true,
                "WIQLQuery": "SELECT [System.Id] FROM WorkItems WHERE [System.TeamProject] = '@TeamProject' AND [System.ChangedDate] >= '2018-01-01T00:00:00.000Z' AND [System.ChangedDate] <= '2018-01-03T23:59:59.999Z'",
                "FixHtmlAttachmentLinks": true,
                "WorkItemCreateRetryLimit": 5,
                "FilterWorkItemsThatAlreadyExistInTarget": false,
                "PauseAfterEachWorkItem": false,
                "AttachRevisionHistory": false,
                "GenerateMigrationComment": true,
                "WorkItemIDs": null,
                "MaxGracefulFailures": 0,
                "SkipRevisionWithInvalidIterationPath": false,
                "SkipRevisionWithInvalidAreaPath": false,
                "Enrichers": null,
                "SourceName": "Source",
                "TargetName": "Target",
                "RefName": null
            },
            {
                "ProcessorType": "TfsTestVariablesMigrationProcessor",
                "Enabled": false,
                "Processor": "TestVariablesMigrationContext",
                "Enrichers": null,
                "SourceName": null,
                "TargetName": null,
                "RefName": null
            },
            {
                "ProcessorType": "TfsTestConfigurationsMigrationProcessor",
                "Enabled": false,
                "Enrichers": null,
                "SourceName": null,
                "TargetName": null,
                "RefName": null
            },
            {
                "ProcessorType": "TfsTestPlansAndSuitesMigrationProcessor",
                "Enabled": false,
                "OnlyElementsWithTag": "",
                "TestPlanQuery": null,
                "RemoveAllLinks": false,
                "MigrationDelay": 0,
                "RemoveInvalidTestSuiteLinks": false,
                "FilterCompleted": false,
                "Enrichers": null,
                "SourceName": null,
                "TargetName": null,
                "RefName": null
            },
            {
                "ProcessorType": "AzureDevOpsPipelineProcessor",
                "Enabled": false,
                "MigrateBuildPipelines": true,
                "MigrateReleasePipelines": true,
                "MigrateTaskGroups": true,
                "MigrateVariableGroups": true,
                "MigrateServiceConnections": true,
                "BuildPipelines": null,
                "ReleasePipelines": null,
                "RepositoryNameMaps": null,
                "Enrichers": null,
                "SourceName": "Source",
                "TargetName": "Target",
                "RefName": ""
            },
            {
                "ProcessorType": "TfsSharedQueryProcessor",
                "Enabled": false,
                "PrefixProjectToNodes": false,
                "SharedFolderName": "Shared Queries",
                "SourceToTargetFieldMappings": null,
                "Enrichers": null,
                "SourceName": "MySource",
                "TargetName": "MyTarget",
                "RefName": null
            }
        ],
        "CommonTools": {
            "TfsChangeSetMappingTool": {
                "Enabled": true,
                "ChangeSetMappingFile": ""
            },
            "TfsGitRepositoryTool": {
                "Enabled": true,
                "Mappings": null
            },
            "FieldMappingTool": {
                "Enabled": true,
                "FieldMaps": []
            },
            "WorkItemTypeMappingTool": {
                "Enabled": false,
                "Mappings": {
                    "Source name": "target name"
                }
            },
            "StringManipulatorTool": {
                "Enabled": true,
                "MaxStringLength": 1000000,
                "Manipulators": [
                    {
                        "Enabled": true,
                        "Pattern": "[^( -~)\n\r\t]+",
                        "Replacement": "",
                        "Description": "Remove invalid characters from the end of the string"
                    }
                ]
            },
            "TfsNodeStructureTool": {
                "Enabled": true,
                "Areas": {
                    "Filters": [],
                    "Mappings": {
                        "^2300 Team Name$": "ProjectTeamName",
                        "^White Walkers$": "ProjectTeamName",
			... 200 more like this
 
                    }
                },
                "Iterations": {
                    "Filters": [],
                    "Mappings": {
                        "^2300 Team Name$": "ProjectTeamName",
                        "^White Walkers$": "ProjectTeamName",
			... 200 more like this
 
                    }

                    }
                },
                "ShouldCreateMissingRevisionPaths": true,
                "ReplicateAllExistingNodes": true
            }
        }
    }
}

[MrHinsh]

The configuration of "Team Field" is not supported by Azure DevOps Services.

You will need to change the configuration to the default, which is Team = Area Path, before you can migrate.