You need to sign in to do that
Don't have an account?
Avinash Angasay
Soql/Sosl Related--
Please write queries for these below problems using Sosl and Soql........
How to access notes related to account.
how to compare close date and fiscal year in Sosl.
Thank you in advance..
1.) Get all the opportunities,contacts,notes related to an Account where Account Name starts with ‘B’.
2.) Get the account name,notes,contacts related to an opportunity where opportunity name ends with ‘A’.
3.) Get all the records where field consist ‘Test’ and close date of opportunity records should be of this fiscal year, accounts should be owned by current logged in.
How to access notes related to account.
how to compare close date and fiscal year in Sosl.
Thank you in advance..
1.) Get all the opportunities,contacts,notes related to an Account where Account Name starts with ‘B’.
2.) Get the account name,notes,contacts related to an opportunity where opportunity name ends with ‘A’.
3.) Get all the records where field consist ‘Test’ and close date of opportunity records should be of this fiscal year, accounts should be owned by current logged in.
You can use the below condition in Where Clause.
Let me know if you face any issues.
If this solution helps, Please mark it as best answer.
Thanks,
All Answers
Your SOQL queries for First and second will be as below.
What do you meant by all records? Do you mean that all Account , Contacts and opportunittes and you have different conditions on each object which may not be possible with SOSL query.
Let me know if you face any issues.
If this solution helps, Please mark it as best answer.
Thanks,
Get all the records where field consist ‘Test’ and close date of opportunity records should be of this fiscal year.
Just Consider it for a single Object Like Opportunity Only....
All Records Means Opportunity all Records.....
how to Compare close date of opportunity with Fiscal year fiscal year in Where Condition.
You can use the below condition in Where Clause.
Let me know if you face any issues.
If this solution helps, Please mark it as best answer.
Thanks,