Report on previous modified date of objects

Atiya_Sultana

Hi,Can anyone suggest an SQL query something like the below query which can output all the objects along with their previous modified date in a container? Select * from DTree (nolock) where DataID=XXXX and ModifyDate<’12-Dec-2009’ Many Thanks,Atiya

Greg_Griffiths_(ggriffiths_-_(deleted))

this has been covered on OTO as well - http://communities.opentext.com/communities/livelink.exe?func=ll&objId=8577611&objAction=view&CommShowConsole&CommNodeID=64166&DirectoryRefNodeId=64166 - as well as the EW Forum - https://knowledge.opentext.com/knowledge/llisapi.dll?func=ll&objId=17075242&objAction=view