Sharepoint 2010 Client OM - How to get the Last approved document version?

Question

I am trying to use sharepoint foundation 2010 as file store for a website. Every document update must go thru an approval cycle and finally gets to a approved status to show up on the website for end users. When a document is updated in sharepoint the status is reset to "Draft" even if the previous version was approved. This is the intended behavior.

File.Versions gives me the list of versions.

How to get the version that was last "Approved"?

Answer 1

Please use below code and this will give latest approved version.

SPList oList = new SPSite("http://developerBOX1").AllWebs["Web1"].GetList( "http://developerBOX1/Web1/DocLIB");

        SPListItemCollection collListItems = oList.Items;
        SPListItem itemFound;
        if (oList.EnableVersioning) 
        {
            foreach (SPListItem oListItem in collListItems)
            {

                SPListItemVersionCollection allVersions = oListItem.Versions;          
                // Iterate through all versions         
                foreach (SPListItemVersion version in allVersions)
                {
                    if (version.Level == SPFileLevel.Published)
                    {
                        itemFound = version.ListItem;
                        return;
                    }
                } 
            } 
        }