greeting. i try to update previous record in date effective table but it does not update. help pls
ok after reading i understand much problem I had thanks you both
If a table has no gap then the records are stored as
If a table has gap then the records are stored as
Note that dates in no gap property allow for consecutive dates continuum timeline, the later one can have dates missing in the continuum timeline.
For example if we have following records
Record1: ValidFrom 1.1.2018 ValidTo 31.1.2018
Record2: ValidFrom 2.2.2018
There is a gap between the records (neither record is active on 1.2.2018).
ok i think understand what you mean and i will take look at link.
i do not what you mean by map definition
The setup is in two different places:
- In the valid time state index of the table (for example index AK1 in LogisticsPostalAddress).
- Form data source has property ValidTimeStateUpdate which determines how the data will be handled on this form (look at the LogisticsPostalAddressForm, LogisticsPostalAddress data source). This property is of course available only for ValidTimeState tables.
I suggest you read the complete MS documentation about the topic: docs.microsoft.com/.../valid-time-state-tables-and-date-effective-data
Gap property means whether the system will allow gaps between the ValidFrom/ValidTo of records (gap means a period of time when no record is valid).
What do you mean by gap property
how can i know valid time state update mode of table?
If its a production environment, then it wont work since Past Records can't be updated.
If you are on a development environment, use the SQL Server to bypass restrictions in Dynamics 365 to update records. Make sure you check the gap property for that table that you are going to update (so that you maintain consistency in your application between records of that table).
Then you can't change the old records.
its out of box table
i do not have access to x plus plus code
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to a top community star!
In our never-ending quest to help the Dynamics 365 Community members get answers faster …
Welcome to the next edition of the Community Platform Update. This is a status …
Stay up to date on forum activity by subscribing.
