To apply filters on Target Database in Rules

  • 2
  • Problem
  • Updated 4 days ago
The filters present in the Action Criteria are applied only on the source data but not on the target.

For example,

If Source data have multiple records with Same account number as below -

Now if we try to update this exclude the record with value yes by using it in criteria and 
and apply the identifier on Account then the rule is updating all the records including the Field Exclude which has Yes too.

So user is requesting to post as an enhancement request where the Action criteria is applied on target too.
Photo of Prathap

Prathap, Employee

  • 262 Points 250 badge 2x thumb

Posted 2 weeks ago

  • 2
Photo of Jahnavi

Jahnavi, Champion

  • 1,348 Points 1k badge 2x thumb
This is very important for us, we have multiple rules where we could use this
Photo of Jitin Mehndiratta

Jitin Mehndiratta, Product Manager

  • 2,636 Points 2k badge 2x thumb
Hi Prathap,

The use case which you mentioned can be achieved by merging the "Source Data set with Target object" in the Bionic query and then setting up a filter to exclude the records with "exclude = Yes". 

Let me know if that helps.