SPModerationInformation.Status property

Gets or sets a value that specifies the content approval status for an item.

Namespace:  Microsoft.SharePoint
Assembly:  Microsoft.SharePoint (in Microsoft.SharePoint.dll)

Syntax

'Declaration
Public Property Status As SPModerationStatusType
    Get
    Set
'Usage
Dim instance As SPModerationInformation
Dim value As SPModerationStatusType

value = instance.Status

instance.Status = value

public SPModerationStatusType Status { get; set; }

Property value

Type: Microsoft.SharePoint.SPModerationStatusType
An SPModerationStatusType value that specifies the status.

Examples

The following code example approves all the pending items on a site collection and returns the location of the approved item.

Dim siteCollection As New SPSite("https://localhost")
Dim subSites As SPWebCollection = siteCollection.AllWebs
Dim site As SPWeb

For Each site In  subSites

    Dim lists As SPListCollection = site.Lists
    Dim list As SPList

    For Each list In  lists

        If list.BaseType = SPBaseType.DocumentLibrary Then

            Dim docLibrary As SPDocumentLibrary = _
                CType(list, SPDocumentLibrary)
       
            If Not docLibrary.IsCatalog AndAlso _
                docLibrary.EnableModeration = True Then

                Dim allItemsQuery As New SPQuery()
          
                allItemsQuery.ViewAttributes = _
                    "ModerationType='Moderator'"
          
                Dim docLibItems As SPListItemCollection = _
                    docLibrary.GetItems(allItemsQuery)
                Dim docLibItem As SPListItem

                For Each docLibItem In  docLibItems

                    If docLibItem.ModerationInformation.Status = _
                        SPModerationStatusType.Pending Then

                        Console.WriteLine((site.Url + "/" + _
                            docLibItem.File.Url))
                        docLibItem.ModerationInformation.Comment = _
                            "Automatic Approval of items"
                        docLibItem.ModerationInformation.Status = _
                            SPModerationStatusType.Approved
                        docLibItem.Update()

                    End If
               Next docLibItem
           End If
       End If
   Next list
Next site 

using (SPSite oSiteCollection = new SPSite("https://localhost"))
{
    SPWebCollection collWebsites = oSiteCollection.AllWebs;

    foreach (SPWeb oWebsite in collWebsites)
    {
        SPListCollection collLists = oWebsite.Lists;

        foreach (SPList oList in collLists)
        {
            if (oList.BaseType == SPBaseType.DocumentLibrary)
            {
                SPDocumentLibrary oDocumentLibrary = (SPDocumentLibrary)oList;

                if (!oDocumentLibrary.IsCatalog && oDocumentLibrary.EnableModeration ==
                    true)
                {
                    SPQuery oQuery = new SPQuery();

                    oQuery.ViewAttributes =
                        "ModerationType='Moderator'";

                    SPListItemCollection collListItems =
                        oDocumentLibrary.GetItems(oQuery);

                    foreach (SPListItem oListItem in collListItems)
                    {
                        if (oListItem.ModerationInformation.Status ==
                            SPModerationStatusType.Pending)
                        {
                            Console.WriteLine(oWebsite.Url + "/" +
                                oListItem.File.Url);
                            oListItem.ModerationInformation.Comment =
                                "Automatic Approval of items";
                            oListItem.ModerationInformation.Status =
                                SPModerationStatusType.Approved;
                            oListItem.Update();
                        }
                    }
                }
            }
        }
        oWebsite.Dispose();
    }
}

See also

Reference

SPModerationInformation class

SPModerationInformation members

Microsoft.SharePoint namespace