Skip to main content
Topics#Data ManagementNagendra Singh の質問
Nagendra Singh が「#Data Management」で質問
2015年6月30日 19:01

help with parent-child relational query

Hello there, Need help to get help on following, I was Parent data comparinf with child data, my query look like this:

 

Select ParentId, parentfield from Parent where parentfield NOT IN ( select childfield from child where parent.id = child.id)

 

​Any advise?
6 件の回答
  1. Orkhan Shukurov
    2015年6月30日 20:25

    NON-programmatic solution: Since soql doesn't allow field-to-field comparison you can create a Boolean type formula field (e.g. Comparison__c) in child object with the following formula:

    IF(Parent__r.Parentfield==Childfield, True, False)

     

    then you can reference this in you query as:

     

     

    Where Comparision__c=true
回答を記入...
0/9000