Wednesday, February 16, 2011

dotCMS SQL to see history of a contentlet item

Here is some SQL that will output the history of a particular contentlet item. You need to know the identifier for the record (which you can see from the Admin UI).

select c.*
from contentlet c
inner join inode 
   on inode.identifier = 11235 
   and inode.inode = c.inode
order by c.title, c.inode;