The Assigned To Me Web Part displays a summary list of any item currently assigned to you. This web part is useful in cases where your SharePoint site is divided into numerous sub-sites and lists. Items are grouped by list with a sum total of items assigned to you per list.
To download this web part as a compiled WSP package, or for more information, click here:
public class AssignedToMe : System.Web.UI.WebControls.WebParts.WebPart { protected override void Render(System.Web.UI.HtmlTextWriter writer) { // Controls are made in Render() rather than // CreateChildControls() because the TBODY // tag does not appear to exist in the Web.UI // namespace and it is required for the SharePoint // expander javascript to work SPWeb spWebThis = SPControl.GetContextWeb(this.Context); List<SPWeb> webs = new List<SPWeb>(); PopulateWebCollectionRecursive(webs, spWebThis); #region Create table and header rows Table table = new Table(); this.Controls.Add(table); table.Attributes["class"] = "ms-settingsframe"; table.Width = Unit.Percentage(100); table.BorderStyle = BorderStyle.None; table.CellPadding = 1; table.CellSpacing = 0; table.Style.Add("border-top", "0px solid"); TableRow rowHeader = new TableRow(); table.Rows.Add(rowHeader); TableCell cellHeaderTitle = new TableCell(); rowHeader.Cells.Add(cellHeaderTitle); cellHeaderTitle.Wrap = false; cellHeaderTitle.Attributes["class"] = "ms-vh2-nofilter"; cellHeaderTitle.Attributes["scope"] = "col"; cellHeaderTitle.Text = "Item"; TableCell cellHeaderModified = new TableCell(); rowHeader.Cells.Add(cellHeaderModified); cellHeaderModified.Wrap = false; cellHeaderModified.Attributes["class"] = "ms-vh2-nofilter"; cellHeaderModified.Attributes["scope"] = "col"; cellHeaderModified.Text = "Modified"; TableCell cellHeaderModifiedBy = new TableCell(); rowHeader.Cells.Add(cellHeaderModifiedBy); cellHeaderModifiedBy.Wrap = false; cellHeaderModifiedBy.Attributes["class"] = "ms-vh2-nofilter"; cellHeaderModifiedBy.Attributes["scope"] = "col"; cellHeaderModifiedBy.Text = "Modified By"; TableCell cellHeaderList = new TableCell(); rowHeader.Cells.Add(cellHeaderList); cellHeaderList.Wrap = false; cellHeaderList.Attributes["class"] = "ms-vh2-nofilter"; cellHeaderList.Attributes["scope"] = "col"; cellHeaderList.Text = "List"; TableCell cellHeaderSite = new TableCell(); rowHeader.Cells.Add(cellHeaderSite); cellHeaderSite.Wrap = false; cellHeaderSite.Attributes["class"] = "ms-vh2-nofilter"; cellHeaderSite.Attributes["scope"] = "col"; cellHeaderSite.Text = "Site"; table.RenderBeginTag(writer); rowHeader.RenderControl(writer); #endregion int count = 0; string rowClass = ""; int listIndex = 0; foreach (SPWeb spWeb in webs) { foreach (SPList spList in spWeb.Lists) { try { SPField spFieldAssignedTo = spList.Fields.GetFieldByInternalName("AssignedTo"); if (spFieldAssignedTo == null) throw new Exception(); } catch { continue; } SPQuery spQuery = new SPQuery(); spQuery.Query = String.Format( "<Where><Eq><FieldRef Name='{0}' LookupId='TRUE' /><Value Type='User'>{1}" + "</Value></Eq></Where>", "AssignedTo", spWebThis.CurrentUser.ID.ToString()); SPListItemCollection spListItemCollection = spList.GetItems(spQuery); if (spListItemCollection.Count > 0) { listIndex++; // This is a (messy) replication of the code used // by SharePoint's expanding/collapsing list viewer LiteralControl headerLiteral = new LiteralControl(String.Format( "<TBODY id=\"titl{0}_\" groupString=\"\"><TR><TD colspan=\"100\" class=\"ms-gb\"" + " style=\"border-bottom: 0; border-top: 0;\" nowrap>" + "<img src=\"/_layouts/images/blank.gif\" alt=\"\" height=1 width=0>" + "<a href=\"javascript:\" onclick=\"javascript:ExpCollGroup('{0}_','img_{0}_');" + "return false;\">" + "<img id=\"img_{0}_\" src=\"/_layouts/images/plus.gif\" alt=\"Expand/Collapse\"" + " border=\"0\"></a> " + "<a href=\"javascript:\" onclick=\"javascript:ExpCollGroup('{0}_','img_{0}_');" + "return false;\">" + "{1}</a> ({2})</TD></TR></TBODY><TBODY id=\"tbod{0}__\"" + " style=\"display: none;\" isLoaded=\"true\">", "1-" + listIndex, spList.Title, spListItemCollection.Count)); headerLiteral.RenderControl(writer); int item = 0; foreach (SPListItem spListItem in spListItemCollection) { #region Create controls for basic item information TableRow rowItem = new TableRow(); rowItem.Attributes["class"] = rowClass; table.Rows.Add(rowItem); TableCell cellItemTitle = new TableCell(); rowItem.Cells.Add(cellItemTitle); cellItemTitle.Attributes["class"] = "ms-vb2"; cellItemTitle.VerticalAlign = VerticalAlign.Top; HyperLink anchorItemTitle = new HyperLink(); cellItemTitle.Controls.Add(anchorItemTitle); anchorItemTitle.NavigateUrl = spList.Forms[PAGETYPE.PAGE_DISPLAYFORM] .ServerRelativeUrl + "?ID=" + spListItem.ID; string strItemName = ""; SPField fieldTitle = spListItem.Fields.GetFieldByInternalName("Title"); strItemName = fieldTitle.GetFieldValueAsText(spListItem[fieldTitle.Id]); if (strItemName == null || strItemName.Trim().Length == 0) strItemName = "(No title)"; anchorItemTitle.Text = strItemName; TableCell cellItemModified = new TableCell(); rowItem.Cells.Add(cellItemModified); cellItemModified.Attributes["class"] = "ms-vb2"; cellItemModified.Wrap = false; cellItemModified.VerticalAlign = VerticalAlign.Top; SPField fieldModified = spListItem.Fields.GetFieldByInternalName("Modified"); cellItemModified.Text = fieldModified.GetFieldValueAsText( spListItem[fieldModified.Id]); TableCell cellItemModifiedBy = new TableCell(); rowItem.Cells.Add(cellItemModifiedBy); cellItemModifiedBy.Attributes["class"] = "ms-vb2"; cellItemModifiedBy.Wrap = false; cellItemModifiedBy.VerticalAlign = VerticalAlign.Top; SPField fieldModifiedBy = spListItem.Fields.GetFieldByInternalName("Editor"); cellItemModifiedBy.Text = fieldModifiedBy.GetFieldValueAsHtml( spListItem[fieldModifiedBy.Id]); TableCell cellItemList = new TableCell(); rowItem.Cells.Add(cellItemList); cellItemList.Attributes["class"] = "ms-vb2"; cellItemList.Wrap = false; cellItemList.VerticalAlign = VerticalAlign.Top; HyperLink anchorList = new HyperLink(); cellItemList.Controls.Add(anchorList); anchorList.NavigateUrl = spList.Forms[PAGETYPE.PAGE_DISPLAYFORM].ServerRelativeUrl; anchorList.Text = spList.Title; TableCell cellItemSite = new TableCell(); rowItem.Cells.Add(cellItemSite); cellItemSite.Attributes["class"] = "ms-vb2"; cellItemSite.Wrap = false; cellItemSite.VerticalAlign = VerticalAlign.Top; HyperLink anchorWeb = new HyperLink(); cellItemSite.Controls.Add(anchorWeb); anchorWeb.NavigateUrl = spWeb.ServerRelativeUrl; anchorWeb.Text = spWeb.Title; rowItem.RenderControl(writer); #endregion rowClass = (rowClass == "") ? "ms-alternating" : ""; count++; item++; } TableRow rowSpacer = new TableRow(); table.Rows.Add(rowSpacer); TableCell cellSpacer = new TableCell(); cellSpacer.ColumnSpan = table.Rows.Count; cellSpacer.Text = "<img src=\"/_layouts/images/blank.gif\" alt=\"\" height=10 width=0>"; rowSpacer.Cells.Add(cellSpacer); rowSpacer.RenderControl(writer); LiteralControl footerLiteral = new LiteralControl(String.Format( "</TBODY><TBODY id=\"foot{0}__\"></TBODY>", "1-" + listIndex)); footerLiteral.RenderControl(writer); } } } if (count == 0) { #region Create controls for 'no items' TableRow rowItemNone = new TableRow(); table.Rows.Add(rowItemNone); TableCell cellItemNone = new TableCell(); rowItemNone.Cells.Add(cellItemNone); cellItemNone.ColumnSpan = table.Rows.Count; cellItemNone.Attributes["class"] = "ms-propertysheet"; cellItemNone.VerticalAlign = VerticalAlign.Top; cellItemNone.Style.Add("padding-left", "5px"); cellItemNone.Text = "No items"; rowItemNone.RenderControl(writer); #endregion } table.RenderEndTag(writer); } private void PopulateWebCollectionRecursive(List<SPWeb> webs, SPWeb thisWeb) { webs.Add(thisWeb); // Important to use .GetSubwebsForCurrentUser() as opposed // to the .Webs collection, as the user may not be privileged // to certain webs foreach (SPWeb subWeb in thisWeb.GetSubwebsForCurrentUser()) PopulateWebCollectionRecursive(webs, subWeb); } }
