Include Accounts Where No Data Is Available In Bionic Rules

  • 3
  • Question
  • Updated 1 year ago
  • Answered
It was called out to me by a customer today that the "include accounts where no data is available" is not there in bionic rules even though we are sourcing SFDC object for this data. In customer rules the checkbox is there, but it doesn't appear that we have that capability for bionic rules yet. Is this something we have road mapped or discussed yet? They are trying to fetch a data set where they have Asset "a" with no support cases. In order to achieve that we'd need to filter for accounts where data is unavailable to build this query. 

Photo of Steve Davis

Steve Davis, Employee

  • 7,330 Points 5k badge 2x thumb

Posted 1 year ago

  • 3
Photo of Dan Ahrens

Dan Ahrens, Gainster (employee)

  • 22,434 Points 20k badge 2x thumb
Could you accomplish this by doing a data fetch task on all accounts and then left merging that (to retain all accounts including those without data) on the second data set?
Photo of Manu Mittal

Manu Mittal, Employee

  • 13,004 Points 10k badge 2x thumb
Since we can perform multiple types of joins, we should be able to get the right Accounts even without that checkbox. As Dan mentioned, you can query all Accounts, then query Accounts with cases (do a COUNT of cases by Account Id in this dataset task), and finally merge (retain all records from left dataset) to get a full list of Accounts along with their case counts. When adding a rule action, you can use the case count to include/exclude certain Accounts.
Photo of Steve Davis

Steve Davis, Employee

  • 7,330 Points 5k badge 2x thumb
Marking this as "solved" due to the sustainable workaround.