10
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
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.
No, it's not guaranteed that RecID will go incremental
#1
André Arnaud de Cal...
291,711
Super User 2024 Season 2
#2
Martin Dráb
230,458
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
