Notifications
Announcements
No record found.
Can I create a change-based rule, which reports when a field 'has changed', but only when the previous value is non-blank?
(In this case, a date field)
Thanks
*This post is locked for comments
You can create a trigger on MS SQL server to trace changes on that field.
or
Configure Dynamics to Log DB, just go to Administration module Then under Setup Select Database Log click New and follow the steps. You need to make sure the table is added to Database log system first (SysDatabaseLogWizard::tableAllowed).
Regards,
Abdallah
Thanks for the reply - I already actually have the SalesTable setup on the database log, so that's fine, but the practical example is where the production department needs to know within a short time-frame that the customer's confirmed ship date has changed...
I 'successfully' setup a change-based alert which sends a pop-up to production when the date 'has changed', but this also picks up where the previous date was blank - ie. this is the first instance of a confirmed ship date.
I would like to say - only do this where previous date !"" - tried this in the select filter, but it did not work (presumably because the select filter is looking at the new value)
Hope this makes sense!
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Priya_K 4
Martin Dráb 4 Most Valuable Professional
MyDynamicsNAV 2
