Migrate ALL work items

[NormanGarciaV]

Hi,

Having an issue.. the documentation indicates that to migrate all, the WIQLQuery should be empty, but it does not seem to be working. I tried:

"WIQLQuery": "",
"WIQLQuery": null,

Also tried adding a list all the IDs, but the error is the same, any help will be greatly appreciated. Thanks.

Error msg attached as well:

[13:31:36 INF] [v15.0.4] Querying items to be migrated: null ...
[13:31:36 INF] [v15.0.4] DONE in 00:00:00.0026199
[13:31:36 FTL] [v15.0.4] Error while running WorkItemMigration
System.Exception: You must specify a Query
at MigrationTools._EngineV1.Clients.WorkItemQueryBuilder.BuildWIQLQuery(IMigrationClient migrationClient) in D:\a\1\s\src\MigrationTools_EngineV1\Clients\WorkItemQueryBuilder.cs:line 36
at MigrationTools._EngineV1.Clients.TfsWorkItemMigrationClient.GetWorkItems(String WIQLQuery) in D:\a\1\s\src\MigrationTools.Clients.AzureDevops.ObjectModel_EngineV1\Clients\TfsWorkItemMigrationClient.cs:line 199
at VstsSyncMigrator.Engine.WorkItemMigrationContext.InternalExecute() in D:\a\1\s\src\VstsSyncMigrator.Core\Execution\MigrationContext\WorkItemMigrationContext.cs:line 177
at MigrationTools._EngineV1.Processors.MigrationProcessorBase.Execute() in D:\a\1\s\src\MigrationTools_EngineV1\Processors\MigrationProcessorBase.cs:line 50

[MrHinsh]

Can you point to where in the documentation this is indicated? That is not correct and there should always be a query.

The default generated query migrates all work items:

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

[NormanGarciaV]

Hi,

Here it is... https://nkdagility.com/learn/azure-devops-migration-tools/Reference/v1/Processors/WorkItemMigrationContext/

Look under the options table, scroll down to WIQLQuery, read the description.

Thanks.

[MrHinsh]

Thanks. That's defo old data!