Notify when bionic query becomes invalid due to changes in Salesforce configuration

  • 7
  • Idea
  • Updated 1 month ago
If changes to a Salesforce field structure are made so that the bionic query is no longer valid, it should create an error or some sort of notification. 

This week we experienced a change in our Salesforce instance with a value that existed as a drop down value and became its own field as a checkbox. For example, the query was Role = Project Manager. Project Manager has been removed from the drop down values and now exists independently as Project Manager = true.

If you look at the query in the live AO, the value is now blank but if you were to try to save a draft version with a blank value you can't - it has to have a value. The rule should not continue to run successfully when the filters are no longer valid.

Photo of Kelly


  • 1,354 Points 1k badge 2x thumb

Posted 1 month ago

  • 7
Photo of Samantha Braastad

Samantha Braastad, Champion

  • 7,508 Points 5k badge 2x thumb
Agreed! Our company is going to be reviewing our entire Salesforce instance and this would be hugely beneficial for catching anything that slips through the cracks.
Photo of Faust Belarmino

Faust Belarmino, Champion

  • 2,736 Points 2k badge 2x thumb
YES! This has been a pain to workaround... out team just audited and deleted a bunch of Salesforce fields and it was a pain to review and make sure rules weren't failing when fields were deleted...
Photo of Jeff Kirkpatrick

Jeff Kirkpatrick, Champion

  • 25,508 Points 20k badge 2x thumb
Gainsight - this feels like a bug.  In Kelly's example above, clearly the filter criteria options are no longer present (for whatever reason).  If it won't save the query without having that value populated, then this should result in a failed rule and notification sent if that value is no longer populated.