Apex Code Development You need to sign in to do that
Don't have an account?
Andrew_0509 SOQL query assistance
I am a bit stuck on a SOQL query.
I need to do the following:
Find the list of Account that have opportunities created from 2015 to 2020 but do have product ABC OR XYZ (opp line item) on those opportunities but in the year 2021 have a product ABC or XYZ on a certain opportunity.
Any ways to get this done?
I dont think you can put in IF statements in a SOQL query.
IF Opp. created date is between 2015 - 2020 then check if it does not have products ABC or XYZ, If Opp. created date is 2020 then check account id with opportunities that have a product ABC or XYZ.
I need to do the following:
Find the list of Account that have opportunities created from 2015 to 2020 but do have product ABC OR XYZ (opp line item) on those opportunities but in the year 2021 have a product ABC or XYZ on a certain opportunity.
Any ways to get this done?
I dont think you can put in IF statements in a SOQL query.
IF Opp. created date is between 2015 - 2020 then check if it does not have products ABC or XYZ, If Opp. created date is 2020 then check account id with opportunities that have a product ABC or XYZ.
Greetings!
You would need to first query the products based on the criteria and then you can filter the opportunities based on which you can retrieve accounts.
For this,you would need to create lists as this all can not be done in single query.
Please mark it as best answer if it helps you to fix the issue.
Thank you!
Regards,
Shirisha Pathuri