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

Chuck Tomasi · ‎07-11-2016

If you are checking simple values, then you can dot-walk all you like. To react to something changing, you have to watch the table that has the changing record.

Chuck Tomasi · ‎07-11-2016

I know it's probably not the answer you wanted, but did we answer your question?

Pradeep Sharma · ‎07-11-2016

Hi Shane,

I agree with Chuck and Michael here. You will have to do this via scripting.

Please let us know if you are blocked.

Michael Fry1 · ‎07-11-2016

I don't think it will work just using filter conditions but using advanced and current.x should make it work.

Chuck Tomasi · ‎07-11-2016

Not really Michael. I cannot watch the incident table and use an advanced condition like:

current.caller_id.manager.changes()

because changes() refers to the current/previous values of the incident record and does not have all values of related records.