Advertisement
Guest User

Untitled

a guest
Mar 20th, 2019
56
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.27 KB | None | 0 0
  1. [
  2. SELECT Name
  3. FROM Account
  4. WHERE Id != :opp.AccountId
  5. AND Id != :opp.End_Client__c
  6. AND (
  7. Id IN :accountIds
  8. OR ParentId IN :accountIds
  9. OR Parent.ParentId IN :accountIds
  10. OR Parent.Parent.ParentId IN :accountIds
  11. OR Parent.Parent.Parent.ParentId IN :accountIds
  12. )
  13. ORDER By Name
  14. ]
  15.  
  16. [
  17. SELECT Name
  18. FROM Account
  19. WHERE Id != :opp.AccountId
  20. AND Id != :opp.End_Client__c
  21. AND (
  22. OR Parent.Parent.ParentId IN :accountIds
  23. OR Parent.Parent.Parent.ParentId IN :accountIds
  24. )
  25. ORDER By Name
  26. ]
  27.  
  28. [
  29. SELECT Name
  30. FROM Account
  31. WHERE (Id != :opp.AccountId
  32. AND Id != :opp.End_Client__c
  33. AND Id IN :accountIds)
  34. OR
  35. (Id != :opp.AccountId
  36. AND Id != :opp.End_Client__c
  37. AND ParentId IN :accountIds)
  38. OR
  39. (Id != :opp.AccountId
  40. AND Id != :opp.End_Client__c
  41. AND Parent.ParentId IN :accountIds)
  42. OR
  43. (Id != :opp.AccountId
  44. AND Id != :opp.End_Client__c
  45. AND Parent.Parent.ParentId IN :accountIds)
  46. OR
  47. (Id != :opp.AccountId
  48. AND Id != :opp.End_Client__c
  49. AND Parent.Parent.Parent.ParentId IN :accountIds)
  50. ORDER By Name
  51. ]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement