Skip to main content
Topics#Data ManagementPergunta de Nagendra Singh
Nagendra Singh perguntou em #Data Management
30 de jun. de 2015, 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 respostas
  1. Orkhan Shukurov
    30 de jun. de 2015, 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
Escrever uma resposta...
0/9000