Data Deletion Via Dataport from Actions Table - 99001509

Business Central/NAV Developers Forum
1

Hi,

This is my first time posting here & I am in learning stage of MS Dynamic Navision 2009.

I have Actions Table ID 99001509 which is having morethan 3.5 million records.

Here my question is how can I delete all old records (keeping only one month recent records) via dataport.

I am having little Knowledge in Dataport upto Export & Export only but I do not know how to apply delete function in dataport etc.

Any suggestions willbe hightly appreciated.

Kind Regards

2

You can just use the DELETE function. You use it as “Rec.DELETE;” - but why do you want to use a dataport to delete it?

3

Hi Erik,

Thanks for your reply,

Currenly I am deleting manually from Object Designer T-99001509 by selecting records.

I am looking for an option from Dataport to delete such huge records in single shot.

If possible, Kindly guide me in a simple step.

Thanks again for your suggestions.

Best Regards

4

Why do you require data port ?

You can write report using T-99001509 and write a code on onAfterGetRecord Trigger as following

DELETEALL;