public IList<BoardWorkItem> GetWorkItems(string projectName, string iterationPath) { var workItemMappings = _config.WorkItemMappings[projectName]; WorkItemQuery query = new WorkItemQuery(projectName, workItemMappings); query.AddColumn("Id"); query.AddColumn("Summary"); query.AddColumn("Description"); query.AddColumn("Priority"); query.AddCriterion("System.IterationPath", "Under", iterationPath); query.AddSort("Priority", "ASC"); return GetWorkItems(query, workItemMappings); }
public void CanCreateValidQuery() { WorkItemQuery query = new WorkItemQuery("teamboard", new Dictionary<string, string>() { {"Id","System.Id"}, {"Summary", "System.Title"}, {"Description", "System.Description"}, {"Priority", "CodeStudio.Custom"}, {"Status", "System.State"} }); query.AddColumn("Id"); query.AddColumn("Summary"); query.AddColumn("Description"); query.AddColumn("Priority"); query.AddSort("Priority", "ASC"); query.AddCriterion("Status", "<>", "Closed"); Assert.Equal("SELECT [System.Id],[System.Title],[System.Description],[CodeStudio.Custom] FROM WorkItems WHERE [System.TeamProject] = 'teamboard' AND [System.State] <> 'Closed' ORDER BY [CodeStudio.Custom] ASC", query.ToString()); }