Clearing Logging History
Sanjay Parbhoo
1-23-18
Hi

You are able to track history on a records using the logging control feature.


1. Is there a way purging this data?

2. Ideally you would want x amount of history (2 years possibly) and anything earlier can be removed. Has anyone done anything like this for a customer?

Thanks

Sanjay
Syntec Solutions
Siniša Peteh
9-11-18
external inner procedure CheckFlush(var Integer,Integer);

event startup
begin


SetLangMode(LangSlovenian,"ENG",0);

Maintenance("Delete history",DeleteHistVClass,DeleteHistMn,modTC);

return;

end;

event definewindows
begin
real x,h,h1,h2,h3,h4,h5,h6,h7,v,v2,l,vs,vm,f,t;

SetLangMode(LangSlovenian,"ENG",0);

WindowBegin("Delete history",DeleteHistVClass,CGMnt,RcType);
SetWRect(64,80,459,200);
EditFieldTL(100,6, 70,"Older than", M4Date,Normal,0,d1,false,PasteCurDate);
EndWindow;

return;
end;

global updating
procedure DeleteHistMn(record RcVc RepSpec)
begin
record RHistVc Recr;
Integer flushcnt;

while (LoopMain(Recr,0,true)) begin
if (blank(RepSpec.d1) or Recr.TransDate<=RepSpec.d1) then begin

RecordDelete(Recr);
StepBack(Recr);
CheckFlush(flushcnt,100);

end;
end;
return;
end;
Sanjay Parbhoo
9-21-18
Created bySiniša Peteh13:22 11 Sep 2018
external inner procedure CheckFlush(var Integer,Integer); event startup begin SetLangMode(LangSlovenian,"ENG",0); Maintenance("Delete history",DeleteHistVClass,DeleteHistMn,modTC); return; end; event definewindows begin real x,h,h1,h2,h3,h4
Thanks Siniša !
Leave Comment
You can subscribe to notifications for this post by selecting the 'star' icon on the top right corner of the post.
Back to the list
Latest Posts
Hello, Kindly please report the bug so that we can further investigate and resolve it. Thank you. Best regards, Benjamin...
11:31 3 May 2024
Hi, No changes should have been made that would increase client&apos;s HDB file. Please try to delete HANSA.HDB from client folder and reconnect to server and check if it will grow to 30MB again. ...
10:14 30 Apr 2024