StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>I don't have SharePoint handy, so the list access code might not be quite right, but the rest of the code should do what you want.</p> <pre><code>ManagerSummary summary = new ManagerSummary(); foreach (ListItem oListItem in collListItem) { FieldUserValue managerValue = (FieldUserValue)oListItem["Manager"]; string managerId = managerValue.LookupId; string managerName = managerValue.LookupValue; double amount = Convert.ToDouble(oListItem["Amount"].ToString()); summary.AddValue(managerId, managerName, amount); } StringBuilder output = new StringBuilder(); output.AppendLine("<tr><th>Manager Name</th><th>Total</th></tr>"); foreach (var manager in summary.TopManagers(3)) { output.AppendFormat("<tr><td>{0}</td><td>{1}</td></tr>", manager.Name, manager.Total); output.AppendLine(); } Console.WriteLine(output.ToString()); class ManagerSummary { Dictionary<string, Manager> _managers = new Dictionary<string, Manager>(); public void AddValue(string managerId, string managerName, double amount) { if (_managers.ContainsKey(managerId)) { _managers[managerId].Total += amount; } else { _managers[managerId] = new Manager { Id = managerId, Name = managerName, Total = amount }; } } public List<Manager> TopManagers(int count) { var managers = _managers.Values.ToList(); return managers.OrderByDescending(x => x.Total).Take(count).ToList(); } } class Manager { public string Id { get; set; } public string Name { get; set; } public double Total { get; set; } public override string ToString() { return string.Format("{0,-20}{1,-10}", Name, Total); } } </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload