taskHierarchy()

in src/service/WiqlService.ts [21:48]

• 28 lines of code
• 7 McCabe index (conditional complexity)

  taskHierarchy(areas: string[], workItems?: string[], shift?: number) {
    return `
        SELECT
            [System.Id],
            [System.Title],
            [System.State],
            [System.IterationPath],
            [System.WorkItemType],
            [System.Tags]
        FROM workitemLinks
        WHERE
            (
                [Source].[System.AreaPath] IN (${areas})
                AND [Source].[System.TeamProject] = @project
                ${shift ? `AND [Source].[System.IterationPath] = @CurrentIteration ${shift >= 0 ? ` + ${shift}` : ` - ${shift}`} ` : ``}
                AND [Source].[System.State] <> ''
                AND [Source].[System.WorkItemType] ${workItems && workItems.length > 0 ? `in (${workItems})` : `<> ''`}
            )
            AND (
              [System.Links.LinkType] = 'System.LinkTypes.Hierarchy-Forward'
            )
            AND (
                [Target].[System.TeamProject] = @project
                AND [Target].[System.WorkItemType] ${workItems && workItems.length > 0 ? `in (${workItems})` : `<> ''`}
            )
        MODE (Recursive)
        `;
  },