You need to sign in to do that
Don't have an account?
sroberts_ME
Data filtering
Hi all,
I am new to the force.com platform and was wondering if you could help.
My goal is to output all of the contacts from all accounts that have asset "a" and do not have asset "b". Based on my understanding this can not be done with the normal reports section, but my guess is it is pretty simple in apex. The thing I can't quite figure out is how to check "a" and "b" against all the values of the assets related list for each account in our database.
I hope that's enough information, thanks for your help!
-Sam
Try this one
Here a and be should be Asset records. Please let me know if any issues
I have created a test class also please let me know i understood your issue correctly or not.
You can run this test and verify result by the query that i suggested.