How to update CreatedBy or ModifiedBy field

(0) Share

Report

Posted on by bois0155

260

Hello guys,

I have a web service that creates some records and the CreatedBy field of a table is populated using the admin user since there is no user interaction.

I'm already sending the CreatedBy value on the request, but I want to update the CreatedBy field on the table.

However, this is a system field and I cannot update it. There is any way to override it?
When I try to write x++ code it shows "The field CreatedBy is read only. A value cannot be assigned to it"

Thanks,

I have the same question (0)

All responses (13)

Answers (1)

Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

These fields always store the id of the user of the session who wrote the record. If you want to store some other information, you should put it in some other fields.

Was this reply helpful? Yes No
Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

Or change the Integration user to correct user id. Having configured admin user for integration will result in writing the relevant user id information in the tables.

Was this reply helpful? Yes No
Verified answer

Martin Dráb 237,880 Most Valuable Professional on at

Like (0)

Report
Maybe you want to run the whole thing in a context of another user. If so, use runAs().

If you want to run under an integration account but pretend it was inserted at another user (which doesn't look optiomal to me), maybe you can use overwriteSystemField(). Like this:

new OverwriteSystemfieldsPermission().assert(); myTable.overwriteSystemfields(true); myTable.(fieldnum(MyTable, CreatedBy)) = '...'; myTable.insert();

By the way, using an admin account for this purposes sounds dangerous to me. I would use a dedicated user with just the permissions needed for the custom service - and no more.

Was this reply helpful? Yes No
ergun sahin 8,826 Moderator on at

Like (0)

Report
static void changeCreatedBy(Args _args) { TestTable testTable; ; select firstOnly forUpdate testTable; ttsBegin; new OverwriteSystemfieldsPermission().assert(); testTable.overwriteSystemfields(true); testTable.(fieldnum(TestTable,CreatedBy)) = "ergun.sa"; testTable.doUpdate(); testTable.overwriteSystemfields(false); CodeAccessPermission::revertAssert(); ttsCommit; info("test"); }

Create a menuItem (Runon:Server,ObjectType:Job)

community.dynamics.com/.../update-ax-system-fields-either-createddatetime-or-modifieddatetime

Was this reply helpful? Yes No
bois0155 260 on at

Like (0)

Report

Thank you guys, I believe I'll have to override it for now. To use runAs like Martin said I would have to do a lot of changes on the service.

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

Like (0)

Report

I don't think that the second verified answer is correct. As far as I know, overwriteSystemFields() works only on insert, not update. Please let me know if I'm wrong.

Was this reply helpful? Yes No
ergun sahin 8,826 Moderator on at

Like (0)

Report

I also knew like you, but I tried when I saw the update in the example. It worked without any problems. In the link, he/she didn't say that the menuitem should work on the server side. Need to pay attention to that.

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

Like (0)

Report

Okay, thank you.

Paying attention to running on server isn't needed anymore. D365FO doesn't have any client application to run X++ code on.

Was this reply helpful? Yes No
ergun sahin 8,826 Moderator on at

Like (0)

Report

You got me there. I didn't tried at d365 ( but on ax 2012). I dont think but its possible this is not working on d365fo

Was this reply helpful? Yes No
bois0155 260 on at

Like (0)

Report

Hello guys, I just created a Runnable job to test it on D365FO and I couldn't update the field.

Was this reply helpful? Yes No