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
David Delač
Hi Piotr, The log entry:
2024-12-14 08:40:43 0.000 CallHal(IsHansaWorldCustomer) appears because the server is running with the verbosity=debug-detailed setting in its parameters.txt file. Thi...
09:43 16 Dec 2024
Brittany McGrath
Hi Vaughn, I can confirm this has been fixed now and is live in Standard ERP 2024-11-20 Version: 85556786. Thank you. ...
10:04 10 Dec 2024