You need to sign in to do that
Don't have an account?
Sigmund VanDamme
SOQL / Workbench Query Help leads/opps
I need to get all of the leads that do not have "Demo" In the name of the opportunity it was converted to.
So I need to get all leads and, if they have been converted, check the name for "demo in it". I.e. a left outer join on Leads to Opportunities
I have tried all the following without any luck in workbench:
So I need to get all leads and, if they have been converted, check the name for "demo in it". I.e. a left outer join on Leads to Opportunities
I have tried all the following without any luck in workbench:
- Tried to Reference ConvertedOpportunityId__r.Name in the query i.e.: SELECT id, ConvertedOpportunityId FROM Lead where (Not ConvertedOpportunityId__r.Name like '%demo%') - this gives me a syntax error (Didn't understand relationship 'ConvertedOpportunityId__r' in field path)
Please try with the below query and mark this as answer if it works the way you want.
Thanks,
Karthik
All Answers
Please try with the below query and mark this as answer if it works the way you want.
Thanks,
Karthik