Locked since date using core services

Question

I need to find the check out date for any tridion item in 2013 SP1 using core service. Presently I am using this piece of code - but it is throwing null exception, reason being that there is no attribute 'CheckOutDate" and also there is no such attribute to find it.

using (SessionAwareCoreServiceClient client = new SessionAwareCoreServiceClient(binding))
            {
                RepositoryLocalObjectsFilterData filter = new RepositoryLocalObjectsFilterData();
                XElement checkedOutItemsXml = client.GetSystemWideListXml(filter);
                foreach (XElement tridionItem in checkedOutItemsXml.Nodes())
                {
                    String revDt = tridionItem.Attribute("CheckOutDate").Value; // null exception
            } 

What else I can do to find the same.

Answer 1

The XML you are getting back from GetSystemWideListXml is just basic information about the items. If you actually output the XML, you'd see that indeed there is no such "CheckedOutDate" attribute. However if you take a look at the CoreService API, you'll see that the RepositoryLocalObjectData contains a LockInfo property, which has the date that I believe you are looking for.

Here's a very quick sample of something along the lines of what you could attempt to get you going on the right track:

ReadOptions readOptions = new ReadOptions();
RepositoryLocalObjectsFilterData filter = new RepositoryLocalObjectsFilterData();

XElement checkedOutItems = client.GetSystemWideListXml(filter);
foreach (XElement item in checkedOutItems.Elements())
{
    RepositoryLocalObjectData checkedOutItem = 
        client.Read(item.Attribute("ID").Value, readOptions) as RepositoryLocalObjectData;
    Console.WriteLine(checkedOutItem.Title + " checked out since " + checkedOutItem.LockInfo.LockDate);
}

Hope that helps!