Re-migrate updated work items

[code-on-git]

After I run the initial migration of all work items I would like to run a new migration to just refresh the work items that has been updated since the last migration.

I've tried to use the processor WorkItemPostProcessingConfig like this;

{
      "$type": "WorkItemPostProcessingConfig",
      "Enabled": true,
      "WorkItemIDs": null,
      "WIQLQueryBit": "AND [System.WorkItemType] IN ( 'User Story' ) AND [System.Id] IN (69)",
      "WIQLOrderBit": null,
      "FilterWorkItemsThatAlreadyExistInTarget": false,
      "PauseAfterEachWorkItem": false,
      "WorkItemCreateRetryLimit": 1
    }

And like this:

{
      "$type": "WorkItemPostProcessingConfig",
      "Enabled": true,
      "WorkItemIDs": [69],
      "WIQLQueryBit": null,
      "WIQLOrderBit": null,
      "FilterWorkItemsThatAlreadyExistInTarget": false,
      "PauseAfterEachWorkItem": false,
      "WorkItemCreateRetryLimit": 1
    }

But everything I try gives 0 result:

[09:52:46 DBG] [v14.3.7] TypeDefinitionMapContainer: Adding Work Item Type sourceWorkItemTypeName
[09:52:46 INF] [v14.3.7] Beginning run of 1 processors
[09:52:46 INF] [v14.3.7] Processor: WorkItemPostProcessingContext
[09:52:46 INF] [v14.3.7] Migration Context Start: WorkItemPostProcessingContext
[09:52:46 INF] [v14.3.7] TfsMigrationClient::GetDependantTfsCollection:AuthenticationMode(AccessToken)
[09:52:46 INF] [v14.3.7] TfsMigrationClient::GetDependantTfsCollection: Connecting with AccessToken
[09:52:46 INF] [v14.3.7] MigrationClient: Connecting to https://dev.azure.com/**********/
[09:52:47 DBG] [v14.3.7] MigrationClient: validating security for {"IsContainer": false, "UniqueName": "****@****.**", "Descriptor": {"Data": null, "Identifier": "ed27d9d8-76f4-4e49-a49b-e205721d7ec2\\****@****.**", "IdentityType": "Microsoft.IdentityModel.Claims.ClaimsIdentity", "$type": "IdentityDescriptor"}, "IsActive": true, "MemberOf": [], "Members": [], "TeamFoundationId": "e6eae80a-663d-4c51-8d41-5e8bed7cdcf5", "UniqueUserId": 0, "$type": "TeamFoundationIdentity"}
[09:52:47 DBG] [v14.3.7] TfsWorkItemMigrationClient::GetWorkItemStore(https://dev.azure.com/**********/, BypassRules)
[09:52:47 DBG] [v14.3.7] WorkItemQuery: ===========GetWorkItems=============
[09:52:47 DBG] [v14.3.7] WorkItemQuery: TeamProjectCollection: https://dev.azure.com/**********/
[09:52:47 DBG] [v14.3.7] WorkItemQuery: Query: SELECT [System.Id] FROM WorkItems WHERE [System.TeamProject] = 'MigTargetLab1'  AND [System.WorkItemType] = 'sourceWorkItemTypeName' AND [System.WorkItemType] IN ( 'User Story' ) AND [System.Id] IN (69) ORDER BY [System.Id]
[09:52:47 DBG] [v14.3.7] WorkItemQuery: Parameters: {"TeamProject": "MigTargetLab1"}
[09:52:47 DBG] [v14.3.7] WorkItemQuery: TeamProject: MigTargetLab1
[09:52:47 DBG] [v14.3.7] Query sent
[09:52:48 INF] [v14.3.7] Migrate 0 work items?
[09:52:48 INF] [v14.3.7] Found target project as MigTargetLab1
[09:52:48 INF] [v14.3.7] DONE in 00:00:02.1474259
[09:52:48 INF] [v14.3.7]  Migration Context Complete WorkItemPostProcessingContext
[09:52:48 INF] [v14.3.7] Application is shutting down...
[09:52:48 DBG] [v14.3.7] Hosting stopping
[09:52:48 DBG] [v14.3.7] Exiting with return code: 0
[09:52:48 INF] [v14.3.7] Application Ending
[09:52:48 INF] [v14.3.7] The application ran in 00:00:03.6835756 and finished at 12/28/2023 09:52:48
[09:52:48 DBG] [v14.3.7] Hosting stopped

Is this even possible to do?
In the example above I try to specify one work item ID, but if it's possible I would like to refresh all work items that has been updated since the last migration.

[MrHinsh]

To re-migrate the same work items with on the changes we run the same config with FilterWorkItemsThatAlreadyExistInTarget": false,.

It may be a good idea (for speed) to add a date filter to the QueryBit. WIQL is localised so you will need to create a query that matches your region, but this is what I get:

AND [System.ChangedDate] > "2023-01-12" AND [System.WorkItemType] IN ('Product Backlog Item')

[code-on-git]

Simple as that - thanks a lot