Skip to main content
Topics#Data ManagementNagendra Singh의 질문
Nagendra Singh 님이 #Data Management에 질문했습니다
2015년 6월 30일 오후 7: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일 오후 8: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