Finance | Project Operations, Human Resources, ...

How to do action after inserted record in sysdatabaselog table

(1) Share

Report

Posted on by it.dev

Hi All,

I want to do some action after record inserted in sysdatabaselog table, and currently i try to use oninserted event handler

[DataEventHandler(tableStr(SysDataBaseLog), DataEventType::Inserted)]
public static void SysDataBaseLog_onInserted(Common sender, DataEventArgs e)
{

//action here

}

but the event handler could not be triggered

Thanks & Regards,

Masha

I have the same question (0)

All responses (8)

Answers (0)

Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report

If it is not triggering, you can write COC on post next or we have postInsert method in the insert of this table where you can use it for writing code. Let me know if this works.

Was this reply helpful? Yes No
it.dev 28 on at

Like (0)

Report
Hi Bharani,

I try using this code and still not work

[ExtensionOf(tableStr(SysDataBaseLog))] final class ASP_DatabaseLog_Extension { public void postInsert() { ASP_IntegrateLoggingStaging logStg; next insert(); //Action } }

Thanks & Regards,

Masha

Was this reply helpful? Yes No
Suggested answer

Waed Ayyad 9,039 Super User 2025 Season 2 on at

Like (0)

Report

Hi @ it dev

In the COC your code should be like this: you should call the insert not postinsert

[ExtensionOf(tableStr(SysDataBaseLog))]
final class ASP_DatabaseLog_Extension
{
public void insert()
{
ASP_IntegrateLoggingStaging logStg;

next insert();

//Action
}

}

Regards,

Waed Ayyad

Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future

Was this reply helpful? Yes No
it.dev 28 on at

Like (0)

Report
Hi Ayyad,

still can't trigger the action

[ExtensionOf(tableStr(SysDataBaseLog))] final class DatabaseLog_Extension { public void insert() { LogStaging logStg; next insert(); logStg.clear(); logStg.FileType = "test"; logStg.insert(); } }

Thanks & Regards,

Masha

Was this reply helpful? Yes No
Martin Dráb 237,970 Most Valuable Professional on at

Like (0)

Report

I think the records are inserted directly in the database layer, not in the application layer.

Was this reply helpful? Yes No
Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report

Can you give some more information your business problem? I understand you need to trigger some action on insert. But if you give more detail, then we can give some other better approach.

And also in your previous code, you have written COC on postinsert but you called insert. Can you make the next call to postinsert as I suggested in my first response?

Was this reply helpful? Yes No
André Arnaud de Cal... 301,134 Super User 2025 Season 2 on at

Like (0)

Report

Hi Masha,

As Martin mentioned, database log setup will create SQL triggers on the tables. Using these triggers, the database log is filled in the background. Can you tell the business problem you need to solve with an action after the insert?

Was this reply helpful? Yes No
gustavsundblad82 2 on at

Like (0)

Report

As have already been mentioned in this post the logic around databaselog is a bit different so it's not possible to configure alerts or subscribe to events directly off that table as far as I can tell. I have been able to do a workaround for specific scenarios (only parameter tables, heavy risk of performance issues) using signature log.

SigSignatureLog table works with alerts and thereby you can also leverage the business event for alerts created. The trick is to configure electronic signature on the tables needed, this link explains it very well:

Electronic signature and the database log in D365FO (linkedin.com)

Once the signature is set up then you can configure alerts on the signed records and do whatever you need to do with them. For our specific scenarios where we needed to audit specific tables for changes it resolved it without resorting to custom events or anything else.

Was this reply helpful? Yes No