Business Rule not detecting change with a dot walked field

SC10 · ‎07-11-2016

On my Project table form, I have dot walked to the Demand table's field of "Project Sponsor".

Creating a new Business Rule, I would like to update a value on my Project record when this dot walked field changes value:

(Note: I have since turned off the "advanced" condition, and am simply using the filter condition on "When to run")

Chuck Tomasi · ‎07-11-2016

Hi Shane,

The idea with Business rules is they detect changes on the record they are watching. In your case, you are asking to watch the pm_project table for updates. yet your condition is also asking "If something changes on the demand table..."

You see the conundrum? Technically, nothing changed on the pm_project table to trigger this business rule. You are looking for a business rule on the demand table which then needs to update the (child) project. That's going to require a bit of script and, if you have multiple child projects under that one demand, they are all going to get updated.

View solution in original post

Michael Fry1 · ‎07-11-2016

Good point Chuck.

SC10 · ‎07-11-2016

Current with a dot walk?

current.u_demand.u_projectsponsor.changes()

Pradeep Sharma · ‎07-11-2016

Hi Shane,

You can write a business rule on target table and when this field is modified then update project table.

Please let me know if I am missing something.

SC10 · ‎07-11-2016

You are correct in assuming this is the solution, however I want to set my "Task for" value based on the changing of a different field on Demand, and a different field on Project.

Demand has this business rule to watch "Requested For" changing, and then set this user to be the "Task For" on the demand record.

Project has this business rule to watch "Demand.Project Manager", and then set this user to be the "Task For" on the project record.

Our Projects always come from our Demands - never made without one - so I am thinking what I really need to do is setup a Business Rule to copy the "Task For" user on the related Project record to be the same as the Demand. However, I am still trying to think up a good way to sync this the other way for when the "Demand.Project Manager" is updated on my Project...

Pradeep Sharma · ‎07-11-2016

Hi Shane,

You mentioned "Our Projects always come from our Demands - never made without one - so I am thinking what I really need to do is setup a Business Rule to copy the "Task For" user on the related Project record to be the same as the Demand." :

For this case you can use dot-walking approach to pull the related field columns. More info here.

https://wiki.servicenow.com/index.php?title=Dot-walking