Apex Code Development You need to sign in to do that
Don't have an account?
Baguiar2 Excel Connector Sfemail/soql_table function
Hi there,
not sure if this is the right group but wonder if there is a way from the excel connector using the "Sfemail" or the "soql_table" function , to retrieve the contact ID but only contacts that are part of Accounts with a certain field Value.
In other words, I wanted to get contacts that are ONLY part of Accounts with the "Status = Active" . I was tryong something like this but no success so far:
soql_table("Contact","Email = B1 and AccountID in soql_table("Account","Status = 'ACTIVE' ") ")
Can we do a Soql within a Soql ?
Thanks for the help!!
not sure if this is the right group but wonder if there is a way from the excel connector using the "Sfemail" or the "soql_table" function , to retrieve the contact ID but only contacts that are part of Accounts with a certain field Value.
In other words, I wanted to get contacts that are ONLY part of Accounts with the "Status = Active" . I was tryong something like this but no success so far:
soql_table("Contact","Email = B1 and AccountID in soql_table("Account","Status = 'ACTIVE' ") ")
Can we do a Soql within a Soql ?
Thanks for the help!!