Report join should display info from Primary & Secondary table — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood: Oracle Cloud SCM and Purchasing

Report join should display info from Primary & Secondary table

edited Apr 21, 2020 12:18PM in Reporting & Analytics for B2C Service 4 comments

Summary

Report join should display info from Primary & Secondary table

Content

I have contact table with primary employment detail and custom object secondary employment details. 

Relationship contact(c_id) -> CO$SecEmp(ContactID)

For example  a member contains 2 secondary employment details. 

When I make a join  report shows 2 records but, I want to show 3 records (1 for primary and 2 for secondary)

Example

ContactID    Branch           Employer
1                 PriBranch1      PriEmployer1
1                 SecBranch1    SecEmployer1
1                 SecBranch2    SecEmployer2

How to do this in report?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!