Does anyone know how to detect renamed Document or Folder ?

[lluserconnector]

When a document or folder is renamed , the modified date is not changed.

Do anyone know how this could be detected ?

Thanks.

 

[lluserconnector]

I think a solution could be a report getting the list of all rename event from audit

anyone would have an idea about the report sql query ?

 

[appnair]

select * from dauditnew where upper(auditstr)=upper('Rename') and dataid=10608787
for a single one

select * from dauditnew where upper(auditstr)=upper('Rename') and subtype=144 and auditdate >sysdate-10

Something that happened to rename documents in the last 10 days(different filtering criteria)

Oracle specific query may need to be rewritten for SQLserver

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937

 

[lluserconnector]

Thanks appair,

I could manage to make it with your info and then dinging into the DAuditNew table.

In my case I need more info so here is a query I use in my LiveLink Report

select DTREE.*,AUDITDATE from DTREE,DAUDITNEW where (AUDITSTR='Rename') and ((AUDITDATE>%1) and (AUDITDATE<%2)) and DTREE.DATAID=DAUDITNEW.DATAID and dtree.ownerid=-2000 order by AUDITDATE desc

Thanks to all of you

 

[davidt50]

If you are inside Livelink script, you can easily orphan a DAPINodeCallback ( based on LLIAPI:LLIAPI Root:NodeCallbacks ) and override the CBRename function. Making sure you set the fSubTypes to be the list you care about, in this case {0, 144}. The function passes in the existing node information, node and the newName that contains the destination name.

function Assoc CBRename( \
Object dapiCtx, \
DAPINODE node, \
String newName, \
Dynamic context )

Then you can track cleanly the name changes.