How to get the latest pdf document from a list of pdf documents which are in document library in sharepoint2013

Question

When I click a button in home page it has to open the latest weekly buzz which is a pdf document and is located in document library.When ever they upload the new one it has to open up the new one. Could you suggest me how to do it.Thank you.

Answer 1

The simplest way is to create a filtered view that only displays the last uploaded document. In the view settings:

• sort by modified date, descending order
• limit the number of displayed items to one

Programmatically, you could use the REST services as you are on SP 2013, and proceed in two steps:

1. retrieve the ID of the last modified document /_api/web/lists/getbytitle('Documents')/items?$sort=Modified%20descending&$top=1&$select=ID
2. retrieve the url of that document. For example if the ID from the first step is 42: /_api/web/lists/getbytitle('Documents')/items(42)/EncodedAbsUrl

Answer 2

The simplest solution is to upload the document always with the same file name and overwrite the existing version.

If you need to retain a copy for each version, you may want to try the following.

Create a new document library called "DisplayDoc".

Create a workflow in the original document library that runs when a document is created.

The workflow will

• delete a document in the DisplayDoc library called TheFile.pdf
• copy the current document to DisplayDoc
• rename the document in DisplayDoc that has the same name as the current document and assign the file name TheFile.pdf

Now all you need to do is to seed a file called TheFile.pdf in the DisplayDoc library and let the workflow in the other library run whenever a file is created.

On the home page you can create a link to DisplayDoc/TheFile.pdf and that never needs to change.

Tested and working in SP 2010. Should work along the same lines in SP2013

Answer 3

You can use SharePoint Designer to drop the Document Library View on the page and limit the results to 1.

Than sort the results based on Modified date field (descending)

You can choose different layouts available in SharePoint Designer for showing the single item and play with XSLT to customize the view..

Reference:

Change the number of records displayed in a Data View