Get the modified items in tridion based on selection of date

Question

We are looking for a tool which will list all Tridion Items such as Publications, Folders, Structure Groups Schemas, Components, Component Templates, Pages, Categories and Keywords modified after particular date (or modified between two dates) using core service.

Please any help appreciated.

Answer 1

I am not sure why there is a need to create a custom page using the Core Service and in fact of a tool for this purpose (getting a list of all modified items between two dates) when SDL Tridion CME provides this out of the box - Probably you have not shared all the requirement as I am not sure why you want to generate XML for each one of these and save it in a particular location.

If you just want to search for modified items for a date range and saving its XML at a particular location just to list them again for review purpose, you may follow the below approach - Else, please add more details on the requirement.

You can use the Advanced search feature to generate this list as shown in the below screen shot:

Further, you can save it as a Virtual Folder by clicking on the Save Search button - Going forward, you can access this Virtual Folder in Tridion to get list of these Items for this specific dates.

Caution: If you happen to use Virtual Folder approach; I hope you are also following the SDL Recommended Maintenance tasks for SDL Tridion and Re-indexing the SDL Tridion Items on a regular basis.

Answer 2

Here's how I get items in a folder after a specified date. I think you can easily adapt this. it is using core-service API through powershell. I think it could be more efficient using the search API. but I am not concerned about performance, so I just got everything and then looped through to exclude what is not modified after the date.

        $folder = Get-TridionItem -IdOrPath (Get-EncodedWebdavUrl $WebdavUrl)
    #Get-TridionCoreServiceAssembly
    if ($folder -ne $null)
    {

        $filter = New-Object Tridion.ContentManager.CoreService.Client.OrganizationalItemItemsFilterData
        #want full objects
        $filter.BaseColumns = 3

        #want only items of requested type.
        $filter.ItemTypes = $ItemTypes

        #recursive?
        if ($Recursive)
        {
            $filter.Recursive = $true
        }
        else
        {
            $filter.Recursive = $false
        }
        if ($ShowNew)
        {
            $filter.ShowNewItems = $true
        }


    $client = Get-TridionCoreServiceClient
    if ($client -ne $null)
    {
        try
        {
            if ($client.IsExistingObject($folder.Id))
            {
                $items = $client.GetList($folder.Id,$filter)
            }
        }
        finally
        {
            if ($client -ne $null) { $client.Close() | Out-Null }
        }
    }

        $recentItems = @()
        foreach ($item in $items)
        {
            $versionInfo = $item.VersionInfo
            $itemTitle = $item.Title
            if ($ModifiedDate -lt $versionInfo.RevisionDate)
            {
                Write-Verbose -Message "$itemTitle is modified after specified date and is included"
                $recentItems += $item
            }
            else
            {
                Write-Verbose -Message "$itemTitle is modified before specified date and is excluded"
            }
        }
        return $recentItems