private buildWiql()

in ui-fabric-react/scripts/WorkItemSearch.ts [86:122]

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

    private buildWiql(filter: IWorkItemSearchFilter): IWiqlResult {
        if (filter && filter.keyword && filter.keyword.length >= 3) {
            let wiqlWhereClauses = [`([System.TeamProject] = @project)`];
            // Add keyword
            wiqlWhereClauses.push(
                `([System.Title] CONTAINS '${filter.keyword}' OR [System.Description] CONTAINS '${filter.keyword}')`,
            );

            if (filter.assignedToMe) {
                wiqlWhereClauses.push(`([System.AssignedTo] = @me)`);
            }

            if (filter.hasAttachments) {
                wiqlWhereClauses.push(`([System.AttachedFileCount] > 0)`);
            }

            if (filter.hasLinks) {
                wiqlWhereClauses.push(`([System.RelatedLinkCount] > 0)`);
            }

            return {
                wiql: `SELECT [System.Id], 
                    [System.WorkItemType], 
                    [System.AssignedTo], 
                    [System.Title], 
                    [System.State], 
                    [System.AttachedFileCount], 
                    [System.RelatedLinkCount],
                    [System.Tags]
                FROM WorkItems
                WHERE ${wiqlWhereClauses.join(" AND ")}
                ORDER BY [System.ChangedDate] DESC`,
            };
        }

        return { error: "Specify at least 3 chars for the keyword" };
    }