FilterWorkItemsThatAlreadyExistInTarget is not filtering the workitems which is already migrated in the target

[muthu3758]

{
      "$type": "WorkItemMigrationConfig",
      "ReplayRevisions": true,
      "PrefixProjectToNodes": false,
      "UpdateCreatedDate": true,
      "UpdateCreatedBy": true,
      "BuildFieldTable": false,
      "AppendMigrationToolSignatureFooter": false,
	  "WIQLQueryBit": "AND (NOT [System.WorkItemType] IN ('Test Suite', 'Test Plan','Code Review Request','Code Review Response','Feedback Request','Feedback Response','Shared Steps','Shared Parameter') AND [System.WorkItemType] <> '') AND [System.WorkItemType] IN ('Product Backlog Item') AND [System.CreatedDate] <= '2018-01-01T00:00:00.0000000'",
	  "WIQLOrderBit": "[System.ChangedDate] desc",
      "Enabled": true,
      "LinkMigration": true,
      "AttachmentMigration": true,
      "AttachmentWorkingPath": "c:\\temp\\WorkItemAttachmentWorkingFolder\\",
      "FixHtmlAttachmentLinks": true,
      "SkipToFinalRevisedWorkItemType": true,
      "WorkItemCreateRetryLimit": 5,
      "FilterWorkItemsThatAlreadyExistInTarget": true,
      "PauseAfterEachWorkItem": false,
      "AttachmentMaxSize": 480000000,
      "CollapseRevisions": false,
      "LinkMigrationSaveEachAsAdded": true,
      "GenerateMigrationComment": true,
      "NodeStructureEnricherEnabled": true,
      "NodeBasePaths": []
	 },

Relevant log output

2024-07-29 20:24:54.858 +02:00 [INF] [FilterWorkItemsThatAlreadyExistInTarget] is enabled. Searching for work items that have already been migrated to the target...
2024-07-29 20:24:54.863 +02:00 [INF] [FilterWorkItemsThatAlreadyExistInTarget] is enabled. Source project GLB is replaced with target project Sales on the WIQLQueryBit which resulted into this target WIQLQueryBit "AND (NOT [System.WorkItemType] IN ('Test Suite', 'Test Plan','Code Review Request','Code Review Response','Feedback Request','Feedback Response','Shared Steps','Shared Parameter') AND [System.WorkItemType] <> '') AND [System.WorkItemType] IN ('Product Backlog Item') AND [System.CreatedDate] <= '2018-01-01T00:00:00.0000000'" .
2024-07-29 20:24:54.866 +02:00 [DBG] FilterExistingWorkItems: START | 
2024-07-29 20:24:54.867 +02:00 [DBG] FilterByTarget: Query Execute...
2024-07-29 20:24:54.868 +02:00 [DBG] WorkItemQuery: ===========GetWorkItems=============
2024-07-29 20:24:54.868 +02:00 [DBG] WorkItemQuery: TeamProjectCollection: https://dev.azure.com/VolvoGroup-MASDCL-QA/
2024-07-29 20:24:54.868 +02:00 [DBG] WorkItemQuery: Query: SELECT [System.Id], [Custom.ReflectedWorkItemId] FROM WorkItems WHERE [System.TeamProject] = 'Sales' AND (NOT [System.WorkItemType] IN ('Test Suite', 'Test Plan','Code Review Request','Code Review Response','Feedback Request','Feedback Response','Shared Steps','Shared Parameter') AND [System.WorkItemType] <> '') AND [System.WorkItemType] IN ('Product Backlog Item') AND [System.CreatedDate] <= '2018-01-01T00:00:00.0000000' ORDER BY [System.ChangedDate] desc
2024-07-29 20:24:54.869 +02:00 [DBG] WorkItemQuery: Parameters: {"TeamProject":"Sales"}
2024-07-29 20:24:54.869 +02:00 [DBG] WorkItemQuery: TeamProject:Sales
2024-07-29 20:24:54.869 +02:00 [DBG] Query sent
2024-07-29 20:24:55.198 +02:00 [DBG] FilterByTarget: ... query complete.
2024-07-29 20:24:55.199 +02:00 [DBG] FilterByTarget: Found 0 based on the WIQLQueryBit in the target system.
2024-07-29 20:24:55.200 +02:00 [DBG] FilterByTarget: After removing all found work items there are 3614 remaining to be migrated.
2024-07-29 20:24:55.200 +02:00 [DBG] FilterByTarget: END
2024-07-29 20:24:55.200 +02:00 [INF] !! After removing all found work items there are 3614 remaining to be migrated.
2024-07-29 20:24:55.206 +02:00 [DBG] ValidatingRequiredField: User Story contains Custom.ReflectedWorkItemId

What happened?

I have enabled the FilterWorkItemsThatAlreadyExistInTarget but still it's not considering the work items which is available in the target.

This migration I have initiated with v15, and then tried with version 12 and 13 but this issue occurs in all the revisions.

Is there anything wrong in my config file.

[MrHinsh]

Found 0 based on the WIQLQueryBit in the target system.

The query SELECT [System.Id], [Custom.ReflectedWorkItemId] FROM WorkItems WHERE [System.TeamProject] = 'Sales' AND (NOT [System.WorkItemType] IN ('Test Suite', 'Test Plan','Code Review Request','Code Review Response','Feedback Request','Feedback Response','Shared Steps','Shared Parameter') AND [System.WorkItemType] <> '') AND [System.WorkItemType] IN ('Product Backlog Item') AND [System.CreatedDate] <= '2018-01-01T00:00:00.0000000' ORDER BY [System.ChangedDate] desc with [System.TeamProject] mapped to the target returned zero results...

Most likely reason is the AND [System.CreatedDate] <= '2018-01-01T00:00:00.0000000'