Live Report for changing max Versions of all documents in specific folders

Peter_Arens

Hello,

I am looking for a report which changes the max versions of all documents in specific folders. Do you have any idea how to write such a report?

The selection is, I think very eas. I would write a report with such a coding:

select * from dtree where parentid in (73322953, 73233485) and subtype=144

The DB field Maxvers would have to be changed, for exampe to 37.

How would you write such a report?

 

Thanks for your help

Peter

Rinita_Pranaykanti

 

Hello Peter,

You can try with the below query with “Allow Database Modification” 

enabled.

Update dtree

Set Maxvers = 37

where dataid in (select dataid from dtree where parentid in (73322953, 73233485) and subtype =144)

 

But updating Livelink database is not recommended by OT, so I wont do it. I would rather do it with either LAPI (Function - UpdateObjectInfo) or WebReport (Tag - [LL_REPTAG=DATAID NODEACTION:MAXVERS:37 /] )

Once you have updated the maxvers column in dtree, if the documents have more than 37 version added then the older version will get purged only after ‘Add Version’ functionality is called on the document.

Regards,

Rinita