Update date attribute in category

Livelink_Admin

How to make date attribute to null through Livereport?

Some of the documents date attribute showing wrong date.  User wants to make it null.  I tried to below query.

update llattrdata set valdate = to_date(null) where id = 10301842 and defid = 3156 and attrid = 3;

In DB view it is showing null.  But if I go to Document's properties -> Categories there it is showing wrong date.

 

Can someone help me on this please?

Appu_Nair1

Llattrdata is a read only /reporting tableFurther livelink tables should not be manipulatedBy SQL tools as you will lose standard supportIf SQL skills are prevalent in the org a optional module called webreports can be used to change data otherwise tools such as OI,Blubaker,syntergy etc are usedDevelopers can use LAPI, Webservices Or Oscript to do thisBTW llattrblobdata is the real table that livelinkUses to show you changes in the GUISent with Good (www.good.com)-----Original Message-----From: eLink Entry: Content Server LiveReports Forum [livereportsdiscussion@elinkkc.opentext.com]Sent: Saturday, January 12, 2013 05:16 AM Central Standard TimeTo: eLink RecipientSubject: [EXTERNAL]Update date attribute in categoryUpdate date attribute in category Posted by livelinkadmin@pdo.co.om (Admin, Livelink) On 01-12-2013 06:14How to make date attribute to null through Livereport?Some of the documents date attribute showing wrong date. User wants to make it null. I tried to below query.update llattrdata set valdate = to_date(null) where id = 10301842 and defid = 3156 and attrid = 3;In DB view it is showing null. But if I go to Document's properties -> Categories there it is showing wrong date.Can someone help me on this please?________________________________[To post a comment, use the normal reply function]Forum: Content Server LiveReports ForumContent Server: Knowledge Center