Best answer by dan_ahrens
View originalDoes not exist logic with 1:M
That may be really simple but can't figure it out: is there a way to generate a power list using "does not exist" logic in 1:M relationships? For example find me all accounts which do not have any entitlement contact with role=Admin? The relationship is: Account (1):Entitlements(M):Entitlement Contacts(M).
Userlevel 7
+2
Hi Raya,
This sounds like an ideal use case for Advanced Outreaches and adding participants using a Bionic Query: https://support.gainsight.com/Product_Documentation/CoPilot_and_Automated_Email/Admin_Configuration/...
Bionic rules and queries allow you to pull data from multiple data sets and to aggregate, pivot and transform the data along with doing complex merges (inner, outer, left and right joins are supported). Here is some more info on getting started with Bionic rules: https://support.gainsight.com/Product_Documentation/Rules_Engine/Admin_Configuration/Getting_Started...
This sounds like an ideal use case for Advanced Outreaches and adding participants using a Bionic Query: https://support.gainsight.com/Product_Documentation/CoPilot_and_Automated_Email/Admin_Configuration/...
Bionic rules and queries allow you to pull data from multiple data sets and to aggregate, pivot and transform the data along with doing complex merges (inner, outer, left and right joins are supported). Here is some more info on getting started with Bionic rules: https://support.gainsight.com/Product_Documentation/Rules_Engine/Admin_Configuration/Getting_Started...
Hi Raya,
Create a Bionic Rule with the following tasks:
1) Fetch all accounts
2) Fetch all "accounts, Entitlement contact" where role = "admin"
3) Merge 1 and 2, retain all records from 1 on Account ID(1) = Account ID(2)
4) Fetch all records from 3 where role = null/blank
This will help you achieve the "does not exist" logic in Bionic Rule.
Regards,
Jitin
Create a Bionic Rule with the following tasks:
1) Fetch all accounts
2) Fetch all "accounts, Entitlement contact" where role = "admin"
3) Merge 1 and 2, retain all records from 1 on Account ID(1) = Account ID(2)
4) Fetch all records from 3 where role = null/blank
This will help you achieve the "does not exist" logic in Bionic Rule.
Regards,
Jitin
Hi Jitin - I have a follow-up on this. Where do the results of the Bionic Rule go? How do you then create the power list?
Userlevel 7
+2
Hi Elizabeth,
With Advanced Outreaches you can add participants via traditional powerlists, CSV, Event Framework actions and Bionic Queries. You can even mix and match sources too! So you don't need to exclusively use a power list anymore.
More info here: https://support.gainsight.com/Product_Documentation/CoPilot_and_Automated_Email/Admin_Configuration/...
With Advanced Outreaches you can add participants via traditional powerlists, CSV, Event Framework actions and Bionic Queries. You can even mix and match sources too! So you don't need to exclusively use a power list anymore.
More info here: https://support.gainsight.com/Product_Documentation/CoPilot_and_Automated_Email/Admin_Configuration/...
Reply
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.