Solved

Reporting via a Custom Object (Land) from an Opportunity with a "many-to-many" relationship (Opportunity/Land Association Junction Object)

G

We have created a report pulling data from an Opportunity (Master), Contact and Land (Custom Object with a many-to-many relationship to Opportunities). The schema is as shown below. The "Related by" between Opportunity and Account is "Lookup from what you have", and likewise between Account & Contact. Our report requires data from one of the Land Object Records. The Land Name could be entered against the Opportunity at the time of running. 

 

Has any of the Community successfully reported data against similar requirements and if so would you mind sharing your solution, ideally pausing the report execution to request the Land Name from which to pull fields for inclusion in the report??

 

Thanks, Greg

 

 

186000_pastedImage_0.png

icon

Best answer by sophie_timu 29 July 2016, 07:33

View original

2 replies

S
Badge +4

Hi Greg,

I believe we assisted you with this inquiry via a Support​ case that was opened earlier this month.

Please post what we did to resolve your inquiry here so others on the Community site can refer to this also.

Cheers

Sophie

G

Thanks Sophie

With the great support provided by the DDPSupport team we resolved this case by creating SOQL code as follows:

Opportunity_Land_Association__c is the Junction Object joining Opportunities and our custom object Land__c

Our thanks to Sophie for her dedication in getting this resolved.

Regards, Greg

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings