You need to sign in to do that
Don't have an account?
Monishan M
How to query only the parent records which has child records and eliminate the parent records which doesnt have child
Hi,
I have below query built. But this query fetches even the suggestion_vod__c records which doesnt have suggestion_tags_vod__c records.
I need to fetch only the suggestion_vod__c records which have suggestion_tags_vod__c records. I need to eliminate the suggestions which doesnt have suggestion tags.
Could you please help me in the query
For(Suggestion_vod__c S :[Select id,account_vod__c,Expiration_Date_vod__c ,OwnerId,Created_Based_on_CVMD_Respi_AZ_JP__c,
Marked_As_Complete_vod__c,Patients_ID_AZ_JP__c,Dismissed_vod__c,Created_Based_on_Cycle_Plan_Rule_AZ_JP__c,
(Select id,Product_vod__c,Suggestion_vod__c from Suggestion_Tags_vod__r)
from suggestion_vod__c
where Expiration_Date_vod__c >= Today
AND Marked_As_Complete_vod__c = Null
AND Dismissed_vod__c = Null
Suggestion_tag_vod__c object has a master detail relationship with Suggestion_vod__c object.
I have below query built. But this query fetches even the suggestion_vod__c records which doesnt have suggestion_tags_vod__c records.
I need to fetch only the suggestion_vod__c records which have suggestion_tags_vod__c records. I need to eliminate the suggestions which doesnt have suggestion tags.
Could you please help me in the query
For(Suggestion_vod__c S :[Select id,account_vod__c,Expiration_Date_vod__c ,OwnerId,Created_Based_on_CVMD_Respi_AZ_JP__c,
Marked_As_Complete_vod__c,Patients_ID_AZ_JP__c,Dismissed_vod__c,Created_Based_on_Cycle_Plan_Rule_AZ_JP__c,
(Select id,Product_vod__c,Suggestion_vod__c from Suggestion_Tags_vod__r)
from suggestion_vod__c
where Expiration_Date_vod__c >= Today
AND Marked_As_Complete_vod__c = Null
AND Dismissed_vod__c = Null
Suggestion_tag_vod__c object has a master detail relationship with Suggestion_vod__c object.
Select Suggestion_vod__r.id,Suggestion_vod__r.account_vod__c,Suggestion_vod__r.Expiration_Date_vod__c ,Suggestion_vod__r.OwnerId,Suggestion_vod__r.Created_Based_on_CVMD_Respi_AZ_JP__c,Suggestion_vod__r.Marked_As_Complete_vod__c,Suggestion_vod__r.Patients_ID_AZ_JP__c,Suggestion_vod__r.Dismissed_vod__c,Suggestion_vod__r.Created_Based_on_Cycle_Plan_Rule_AZ_JP__c,id,Product_vod__c from Suggestion_Tags_vod__c where Suggestion_vod__r.Expiration_Date_vod__c >= Today AND Suggestion_vod__r.Marked_As_Complete_vod__c = Null AND Suggestion_vod__r.Dismissed_vod__c = Null