<div>
<div class="content wysiwyg-content">
I am using a CAML query to retrieve a list of articles in a Pages library in SharePoint publishing web site. I need to retrieve all the published articles. If I use a query like<br />
&lt;Eq&gt;&lt;FieldRef Name='_ModerationStatus' /&gt;&lt;Value Type='ModStat'&gt;Approved&lt;/V<wbr />alue&gt;&lt;/Eq&gt;<wbr /><br />
then I will only get the currently published articles. But if there is a previously published version, I need to retrieve the previously published version of the article.<br />
For example, if an article is published(then it is retrieved and is displayed) and the editor will edit the article for a minor modification, then if I put the above query, then the article is not retrived at all(and goes out from the display).<br />
If I dont put the above query then even the draft versions are retrieved(and displayed)<br />
<br />
Please suggest a way I can retrieve the previous published version of an article using CAML. &nbsp;
</div>
</div>


I am using a CAML query to retrieve a list of articles in a Pages library in SharePoint publishing web site. I need to retrieve all the published articles. If I use a query like
<Eq><FieldRef Name='_ModerationStatus' /><Value Type='ModStat'>Approved</Value></Eq>
then I will only get the currently published articles. But if there is a previously published version, I need to retrieve the previously published version of the article.
For example, if an article is published(then it is retrieved and is displayed) and the editor will edit the article for a minor modification, then if I put the above query, then the article is not retrived at all(and goes out from the display).
If I dont put the above query then even the draft versions are retrieved(and displayed)

Please suggest a way I can retrieve the previous published version of an article using CAML.  

Retrieving the last published version using CAML

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.