Finance | Project Operations, Human Resources, ...

Extension not working for SysDataBaseLog table

(0) Share

Report

Posted on by M Anas Khan

1,424

Hi there!

I am trying to make an extension of SysDataBaseLog table to change the value of description field. I have implemented the chain of command design pattern for setDescription() method however it is NOT working as expected. Please note I am aware of how to implement COC however in this case it just doesn't work. I am curious to know if system tables are exempted from being extended? Please note even the infolog nor any breakpoint is hitting for this code. Although it is compiling successfully.

Below is the code am using to achieve the requirement:

[ExtensionOf(tableStr(SysDataBaseLog))]
final class SysDataBaseLog_Extension
{
void setDescription(Common common)
{
VendBankAccount vendBankAccount;

if (common.TableId == vendBankAccount.TableId)
{
vendBankAccount = common;
this.Description = vendBankAccount.VendAccount;
}

info(strFmt("Finally in! %", common.TableId));

next setDescription(common);
}

}

I have the same question (0)

All responses (11)

Answers (0)

Blue Wang Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Muhammad,

Have you debugged your code?

if condition not met.

Was this reply helpful? Yes No
Sukrut Parab 71,735 Moderator on at

Like (0)

Report
Copy link

Link copied!

Values are inserted in this table using SQL trigger, that might be the reason you are not able to set it using this method. Did you check if this method is getting called anywhere using find references ?

Was this reply helpful? Yes No
Yuji 4,131 on at

Like (0)

Report
Copy link

Link copied!

Hi Sukrut,

Is there any documentation regarding the SQL trigger record insert? Is it a new feature in D365FO?

Thanks,

Was this reply helpful? Yes No
Blue Wang Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Yuji,

Was this reply helpful? Yes No
Yuji 4,131 on at

Like (0)

Report
Copy link

Link copied!

So this is controlled by Kernel?

Was this reply helpful? Yes No
Sukrut Parab 71,735 Moderator on at

Like (1)

Report
Copy link

Link copied!

So the way it works is when you enable database log for example vendtable , System (X++ code )automatically creates trigger on the table you are enabling database log. You can check the created trigger in your local dev VM and all operations are tracked in database log using this.

Was this reply helpful? Yes No
M Anas Khan 1,424 on at

Like (0)

Report
Copy link

Link copied!

Hi Sukrut,

Thanks for the insight! Yes I can see the trigger on the VendBankAccount table setting the description field. This means that the code in setDescription() doesn't get executed or may be translated into the SQL trigger and may couldn't be translated likewise when extending through COC.

Was this reply helpful? Yes No
Suggested answer

Sukrut Parab 71,735 Moderator on at

Like (0)

Report
Copy link

Link copied!

That's correct . I saw in the past some of the code present related to this functionality doesn't get executed and it might be true for method you are trying to do COC.

Was this reply helpful? Yes No
M Anas Khan 1,424 on at

Like (1)

Report
Copy link

Link copied!

The method setDescription() is getting called in application.logUpdate() method for my scenario, let me try to extend this class instead.

Was this reply helpful? Yes No
M Anas Khan 1,424 on at

Like (0)

Report
Copy link

Link copied!

Tried to implement the onInserting event handler of setDescription method in SysDataBaseLog. No success. Tried to implement COC for logUpdate method in Application class. No success!

Was this reply helpful? Yes No