topic Re: retrieving the modified items from wcm in Alfresco Archive

retrieving the modified items from wcm

meetmrharish — Fri, 17 Apr 2009 13:50:07 GMT

HiI want to retrieve the items from the WCM which are modified within a given time period. But I have not found any method provided in the API javadoc (Alfresco Labs 3). Can anyone suggest a way out!Thanks in advanceHarish

Re: retrieving the modified items from wcm

mrogers — Fri, 17 Apr 2009 14:23:05 GMT

You would typically want to compare items between snapshots rather than time based query.

Could you give a little more information of what you are trying to do.

Re: retrieving the modified items from wcm

meetmrharish — Fri, 17 Apr 2009 14:38:41 GMT

My task is to periodically update an external database with the metadata of content present in the WCM. So if there are any changes(newly created, modified, deleted) in the repository from the last updated time, the changes must be updated in the database.

I have previously worked with websphere. It is providing a method such as
findContentModifiedBetween(java.util.Date startDate, java.util.Date endDate) &
findContentModifiedSince(java.util.Date modifiedDate)

I am not able to find such option in Alfresco

Re: retrieving the modified items from wcm

meetmrharish — Mon, 20 Apr 2009 09:05:37 GMT

Does anyone help me out in resolving the above issue

Regards
Harish

Re: retrieving the modified items from wcm

mrogers — Mon, 20 Apr 2009 09:40:13 GMT

Your assets have "created" and "modified" properties so you can do a search for the assets by modification date.

Or as I said above you are probably better off comparing snapshots. And that will give you "deleted" files as well.

Re: retrieving the modified items from wcm

meetmrharish — Mon, 20 Apr 2009 12:04:36 GMT

Thanks for the reply dude. I guess retrieving all the documents and comparing the modified time with the given value is a bit lengthy. Rather dont we have any query methods for it, provided by Alfresco?

Regards
Harish

Re: retrieving the modified items from wcm

mrogers — Mon, 20 Apr 2009 12:11:04 GMT

This thread shows the syntax for how to query by date range.

http://forums.alfresco.com/en/viewtopic.php?f=36&t=15029