Finance | Project Operations, Human Resources, ...

RecId created date time is earlier than preceeding RecId

(0) Share

Report

Posted on by Michael Pequit

Hello,

Are there any triggers where new rec id's Created date/time is earlier than the preceeding rec id?

Example is Rec Ids 1,2,3,4,5 created date time is today but 6,7,8,9 are dated yesterday.

As far as I know ax controls the created date/time and increment of rec id is fixed for any tables.

The issue is when BI fetches recid for certain created datetime as query, there are missing rec ids in the middle

All responses (4)

Answers (0)

Suggested answer

ergun sahin 8,816 Moderator on at

Like (0)

Report

RE: RecId created date time is earlier than preceeding RecId

It creates the RecId sequentially, but there is no guarantee that it will sequentially give it to the table. There are cases where it keeps it in the cache and makes jumps.

You can read it from the article I added above.

Of course, missing RecIds could be due to the fact that the CreatedDateTime field was disabled for a certain period of time, but in this case the CreatedDateTime value would be null(01\01\1900). This situation that can be understood by examining the records in 3-5 minutes. That's why I didn't include that possibility.
Suggested answer

Hossein.K 6,646 on at

Like (0)

Report

RE: RecId created date time is earlier than preceeding RecId

Hi,

No, The rec ids are in order. In your select statement use order by ASC or DSC for rec ids
Suggested answer

ergun sahin 8,816 Moderator on at

Like (0)

Report

RE: RecId created date time is earlier than preceeding RecId

community.dynamics.com/.../463953
Suggested answer

ergun sahin 8,816 Moderator on at

Like (1)

Report

RE: RecId created date time is earlier than preceeding RecId

No, it's not guaranteed that RecID will go incremental