3

I'm searching for an easy way to display the latest changes of a sharepoint list.

Situation: one huge list (10k entries) with a lot of daily changes (lets say 100).
Target: Display the changes during the day, e.g:
Item 122 was changed by userX
Field 1: old value -> new value
Field 2: old value -> new value

I've thought about a lot of ways, for example get the latests changed items using the caml webservice and then read the version history one by one...

My wish would be to get a notification (but not using mail, since this would require another email server of the changed items. It should not be necessary to deploy any code to the sharepoint, since its a production system.

Any possibility for additional notifications? Or an RSS feed that includes the changes on field level?

Thanks a lot

Improve this question
9
  • Did you think about an event receiver for updated, that populates a hidden list, which you make yourself an RSS feed for? Commented Nov 21, 2012 at 13:47
  • Is it possible to create an event reciever without c#/vb? how? Commented Nov 21, 2012 at 14:50
  • I'm taking that would be an issue for you? It is probably by far the easiest solution, you could put content expiry on the log list to, make it nice and tidy, but yes this would be a programmatic solution. Commented Nov 21, 2012 at 14:59
  • I'm searching for something "external" like an push of changes to an url. Or a possibility to get the latest changes with old values and new values in one step Commented Nov 21, 2012 at 15:07
  • Problem is, you can't get the version history easily, you can order by created, but you can't see WHAT was altered. If that's sufficient you could look at the Frontpage RPC and using that as a feed for the list? Commented Nov 21, 2012 at 15:15

2 Answers 2

Reset to default
1

Quick and easy

Here is one way: http://spxsltws.codeplex.com/

You could add this web part then point it at the ListItemChanges function of /_vti_bin/Lists.asmx then use xsl transform to display it.

The basic idea is a web part that consumes a web service and returns results through xsl transform. I think this will be the most elegant solution. I was gonna write one, but the codeplex one looks really pretty good.

More Control for more work

Another solution would be to write a .net bdc that consumes the lists web service and turns it into an external list.

Improve this answer
0

Create a View with:

  1. Sort by: Modified
  2. Sort direction: Descending
  3. Filter: Modified, is greater than, [Today]-1

Then to get the view's RSS feed. Edit the view, and next to "Web address of this view" click the RSS icon.

Improve this answer
2
  • RSS does not include the changed field values (old and new value), or does it? Commented Nov 21, 2012 at 15:58
  • Nope. Sorry - missed that part. No field level changes. Getting field level changes efficiently, without writing server code isn't possible, AFAIK. Commented Nov 22, 2012 at 11:42

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.