Proper use of CreatedDateTime in Data Entities

(0) Share

Report

Posted on by Raphael Tagliani

Hello,

This questions refers to The New Dynamics AX (AX7) : how to use properly the CreatedDateTime field in a custom entity?

I created a new custom table, and set the Created Date Time property to YES.

Then, I created a custom entity, for an OData integration with a C# client. In the data entity, I tried to add the field "CreatedDateTime", but this is not allowed. Adding a field "EntityCreatedDateTime" got me out of trouble (since this name is not system-reserved), and I was able to query the CreatedDateTime.

Unfortunately, when I try to create a new entity and post it to AX, I receive an error :

insert not allowed for field 'DataEntityCreatedDateTime'

How am I meant to use this field? I don't need to write anything in it, I would just like to be able to query the field.

Of course, I could create another UTCDateTime field, with a dummy name, but why not use the system field, since it is there?

Thank you for your guidance.

6330.table.png

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Sort by

dekaasboer 1,530 on at

Like (0)

Report
Copy link

Link copied!

The createdDateTime field is a system field. Every time a record is modified the AOS will update this field. You should not try to insert data into this field through a entity. AX will fill the field for you when you import the data.

Was this reply helpful? Yes No
Raphael Tagliani on at

Like (0)

Report
Copy link

Link copied!

Dear Rik,

Thank you for your answer.

I am aware of that : I am not trying to write in the field, but to use it in a select and be able to write the entity without touching CreatedDateTime.

Do you have any solution for that?

Was this reply helpful? Yes No
Al Moulsdale on at

Like (0)

Report
Copy link

Link copied!

Hi Raphael,

Did you ever solve this?

I am facing exactly the same problem, I want to be able to query against the original CreatedDateTime of a sales order.

Thanks

Was this reply helpful? Yes No
Raphael Tagliani on at

Like (0)

Report
Copy link

Link copied!

Hi Al M,

Yes, I think so... if my memory does not fail me (I'm not 100% sure I remember correctly).

In fact, it was not a limitation of the system but a database synchronization problem. I had to recompile and resynch the whole model. After that, it worked.

Good luck with your development, let us know if that worked for you!

Was this reply helpful? Yes No