Skip to main content
steve_davis
steve_davis
Gainsight Employee ⭐️⭐️
May 24, 2017
Question

Include Accounts Where No Data Is Available In Bionic Rules

  • May 24, 2017
  • 3 replies
  • 59 views
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. 

    3 replies

    dan_ahrens
    dan_ahrens
    Expert ⭐️⭐️⭐️
    May 24, 2017
    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?
    VP of Customer Success at Forcepoint
      manu_mittal
      Gainsight Employee ⭐️
      manu_mittal
      Gainsight Employee ⭐️
      May 24, 2017
      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.
        steve_davis
        steve_davisAuthor
        Gainsight Employee ⭐️⭐️
        May 30, 2017
        Marking this as "solved" due to the sustainable workaround. 
        Terms & ConditionsAccessibility statement