web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) New field in database ...

Microsoft Dynamics AX (Archived)

New field in database log table

(0) Share

Report

Report

Posted on by Johnny

6,480

Hello,

We would like to add new field (display method?) in the database log table / form.

The field should hold value from "Parent" table.

For example, if there is something changed in Vendor bank account table and we have the corresponding record in database log, we want this new field to display the Vendor ID.

Same should be for other "Parent" - "Child" tables too. e.g. customer bank account modification should display customer ID, etc...

Please advice what classes / logic to be used in X++.

Thanks.

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Vilmos Kintera 46,149 on at

Like (1)

Report
Copy link

Link copied!

Have a look at \Classes\Application\log* methods, that is where database log entries are maintained.

You could write your custom logic in there, for example by checking if the record to be inserted is of a specific table - if (recordInserted is VendBankAccount) -, or by TableId - if (recordInserted.TableId == tableNum(VendBankAccount), then you could place the code in there to populate your additional field in SysDatabaseLog to store the parent reference.

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

CP04-islander 39

#2

#3

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans