Apex Code Development You need to sign in to do that
Don't have an account?
sami31 Query on parent child related objects
Hi,
There are 2 objects Account &Address and the relationship is master detial. In address there is a checkboox called primary and most of the account will have 1 address which is marked as primary. I want to know the accounts which don't have a primary address at all. For example there are 2 accounts A & B. Account A has 5 addresses and none of them have primary checked and Account B has 5 address in which 1 is primary and the other 4 non primary. So when a run a report saying primary=false i am getting both accounts A(5 records for each non primary address) & B(4 records for each non primary address) instead of only account A. This is because B has 4 addresses which are not primary and report is pulling them.
Is there any different way or query where i can get only account wiht no primary address which means by our example only account A should come out but not acount B.
Thanks.
There are 2 objects Account &Address and the relationship is master detial. In address there is a checkboox called primary and most of the account will have 1 address which is marked as primary. I want to know the accounts which don't have a primary address at all. For example there are 2 accounts A & B. Account A has 5 addresses and none of them have primary checked and Account B has 5 address in which 1 is primary and the other 4 non primary. So when a run a report saying primary=false i am getting both accounts A(5 records for each non primary address) & B(4 records for each non primary address) instead of only account A. This is because B has 4 addresses which are not primary and report is pulling them.
Is there any different way or query where i can get only account wiht no primary address which means by our example only account A should come out but not acount B.
Thanks.
Hi Sameer,
Try putting the account name in filter condition.
Thanks,
Gaurav
Email: gauravgarg.nmims@gmail.com
Skype: gaurav62990
Sorry i didn't get your point. If you mean to add the account name manually in report filter then i think you misunderstood my requirement. In my org I assume there will be good amount of accounts without primary checkbox(not even single address marked as primary), so i want to know all such accounts without single child address marked primary.
Any suggestions??
Thanks,
The above requirement can be fulfilled via Rollup summary field on Account object, that will count the child object has any Primary address field as true, Please find below article to create rollup summary field.
https://success.salesforce.com/answers?id=90630000000h0EZAAY
Once the Roll-up summary field is created, please add the this field in filter criteria.
Hope this will solve your problem.
Thanks,
Gaurav
Email: gauravgarg.nmims@gmail.com
skype: gaurav62990