Skip to main content
Solved

report relationship

  • 15 March 2023
  • 1 reply
  • 57 views

Forum|alt.badge.img+1

Hello,

how do I relate these three: CRActivity, Users, EPEmployee? Thanks!

I want to filter by the ownerid

 

Best answer by Naveen Boga

Hi @paula012 Here is the joins with the conditions and hope this helps

 

  • EPEmployee(UserID) Join with Users (PKID)
  • EPEmployee(BAccountID and OwnerID)  Join with BAccount (BAccount ID and DefContactID)
  • EPEmployee (BAccountID, OwnerID) Join with CRActivity (BAccountID, OwnerID)
View original
Did this topic help you find an answer to your question?

1 reply

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3377 replies
  • Answer
  • March 17, 2023

Hi @paula012 Here is the joins with the conditions and hope this helps

 

  • EPEmployee(UserID) Join with Users (PKID)
  • EPEmployee(BAccountID and OwnerID)  Join with BAccount (BAccount ID and DefContactID)
  • EPEmployee (BAccountID, OwnerID) Join with CRActivity (BAccountID, OwnerID)

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings