You need to sign in to do that
Don't have an account?
Chris Sanchez 5
Account Opportunity SOQL
Hello - Please advise how to write the following query.
Select all accounts that have at least one opportunity with the text "2016" in the name and also does not have any opportunities with the text "2017" and "2018" in the name.
I tried my hand with reports and custom report types but as easy as this sounds no such luck. I appreciate your help.
Select all accounts that have at least one opportunity with the text "2016" in the name and also does not have any opportunities with the text "2017" and "2018" in the name.
I tried my hand with reports and custom report types but as easy as this sounds no such luck. I appreciate your help.
Please mark this as the Best answer if this solves your issue.
Thanks