Execute WIQL query from configuration file.

[rajendrabhole]

I want to run below WIQL query from configuration file,

SELECT
    [System.Id],
    [System.WorkItemType],
    [System.Title],
    [System.AssignedTo],
    [System.State],
    [System.Tags]
FROM workitemLinks
WHERE
    (
        [Source].[System.TeamProject] = @project
        AND [Source].[System.WorkItemType] <> ''
        AND [Source].[Custom.ReqID] CONTAINS 'CR'
    )
    AND (
        [Target].[System.TeamProject] = @project
        AND [Target].[System.WorkItemType] = 'Test Case'
    )
ORDER BY [System.Id]
MODE (MustContain)

Right now I have implemented "WIQLQueryBit": " AND [Custom.ReqID] contains 'CR' AND [System.WorkItemType] NOT IN ('Test Suite', 'Test Plan')",

Given official documentation mention to create WIQL query from Azure WIQL editor, but not documented how to use query when question come on hierarchical query.

[MrHinsh]

@rajendrabhole there is no support for a hierarchical query, only flat queries.

[rajendrabhole]

Hi @MrHinsh, Thanks for your clarification. So can we run multiple flat queries from the configuration file?

[MrHinsh]

No, a single query selected the work items that the processor migrates.

You can run the processor multiple times with different queries.

[rajendrabhole]

@MrHinsh , Now my configuration processor setting file like below,

"Processors": [
    {
      "$type": "WorkItemMigrationConfig",
      "Enabled": true,
      "ReplayRevisions": true,
      "PrefixProjectToNodes": false,
      "UpdateCreatedDate": true,
      "UpdateCreatedBy": true,
      "WIQLQueryBit": " AND [Custom.ReqID] contains 'CR' AND [System.WorkItemType] NOT IN ('Test Suite', 'Test Plan')",
      "WIQLOrderBit": "[System.ChangedDate] desc",
      "LinkMigration": true,
      "AttachmentMigration": true,
      "AttachmentWorkingPath": "c:\\temp\\WorkItemAttachmentWorkingFolder\\",
      "FixHtmlAttachmentLinks": true,
      "SkipToFinalRevisedWorkItemType": false,
      "WorkItemCreateRetryLimit": 5,
      "FilterWorkItemsThatAlreadyExistInTarget": true,
      "PauseAfterEachWorkItem": false,
      "AttachmentMaxSize": 480000000,
      "AttachRevisionHistory": true,
      "LinkMigrationSaveEachAsAdded": true,
      "GenerateMigrationComment": false,
      "WorkItemIDs": null,
      "MaxRevisions": 0,
      "NodeStructureEnricherEnabled": true,
      "UseCommonNodeStructureEnricherConfig": false,
      "NodeBasePaths": [],
      "AreaMaps": {},
      "IterationMaps": {},
      "MaxGracefulFailures": 0
    },
    {
      "$type": "WorkItemMigrationConfig",
      "Enabled": true,
      "ReplayRevisions": true,
      "PrefixProjectToNodes": false,
      "UpdateCreatedDate": true,
      "UpdateCreatedBy": true,
      "WIQLQueryBit": " AND [Custom.SyncFlag] = 'Yes' AND [System.WorkItemType] IN ('Epic', 'Feature', 'Bug') AND [System.WorkItemType] NOT IN ('Test Suite', 'Test Plan')",
      "WIQLOrderBit": "[System.ChangedDate] desc",
      "LinkMigration": true,
      "AttachmentMigration": true,
      "AttachmentWorkingPath": "c:\\temp\\WorkItemAttachmentWorkingFolder\\",
      "FixHtmlAttachmentLinks": true,
      "SkipToFinalRevisedWorkItemType": false,
      "WorkItemCreateRetryLimit": 5,
      "FilterWorkItemsThatAlreadyExistInTarget": true,
      "PauseAfterEachWorkItem": false,
      "AttachmentMaxSize": 480000000,
      "AttachRevisionHistory": true,
      "LinkMigrationSaveEachAsAdded": true,
      "GenerateMigrationComment": false,
      "WorkItemIDs": null,
      "MaxRevisions": 0,
      "NodeStructureEnricherEnabled": true,
      "UseCommonNodeStructureEnricherConfig": false,
      "NodeBasePaths": [],
      "AreaMaps": {},
      "IterationMaps": {},
      "MaxGracefulFailures": 0
    },
    {
      "$type": "TestConfigurationsMigrationConfig",
      "Enabled": true
    },
    {
        "$type": "TestPlansAndSuitesMigrationConfig",
        "Enabled": true,
        "RemoveInvalidTestSuiteLinks": true,
        "TestPlanQueryBit": "",
        "UseCommonNodeStructureEnricherConfig": false,
        "NodeBasePaths": [
        ],
        "IterationMaps": {
        },
        "AreaMaps": {
        }
    }
  ]

So my doubt now $type : 'WorkItemMigrationConfig' overrides. Last wiql query works and first query scope out by tool. Is that correct understanding?
If i want to run two or multiple WIQL queries then I need to maintain multiple configuration files right?

[MrHinsh]

Why not create a single query that encompasses both:

AND ( 
            ( 
              [Custom.ReqID] contains 'CR' 
            ) 
            OR 
            (
                [Custom.SyncFlag] = 'Yes' AND [System.WorkItemType] IN ('Epic', 'Feature', 'Bug')
            ) 
         ) 
AND [System.WorkItemType] NOT IN ('Test Suite', 'Test Plan')

(That was written freehand and may not be valid WIQL)

You can use the Wiql Editor extension to export the text of the query.