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
Hi there, I&apos;ve just tried to get to HansaManuals from my browser only to be given a webpage that says the following: &quot;HansaManuals can only be opened from within Standard ERP. Please o...
13:05 30 Oct 2026
Tatjana Rozentsova
Hi Paul, BackgroundHALShouldPause is a Boolean function with no arguments. - False: keep working. - True: finish the current item safely and exit the routine. It tells a background HAL routine...
14:12 26 Oct 2026