Pulling through N:1 related entity fields within report

(0) Share

Report

Posted on by Michael_Dawson

Hello all,

I've created a custom entity (FPA) which has multiple Pricelist (entity) lookup fields, which then created multiple N:1 relationships between the FPA and Pricelist entities. I need to be able to create a fetchXML report that can pull through the specified Pricelist(s) records and their values to be used within the report. How would i go about achieving this?

Thanks

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

David Jennaway 14,065 on at

Like (1)

Report
Copy link

Link copied!
The easiest place to start is to create an advanced find to include the relationships you want, and any fields on the main entity and from parent entities, and download the fetchXml. I don't fully understand your relationships, but the 2 main things you'll probably have to do by directly editing the fetchXml are:

Add an attributes that aren't on the main entity or direct parents. You can just add these directly within any entity element

If you have multiple relationships between the same pair of entities, you'll may have to add extra link-entity elements (quite possibly as outer joins), which you can do by copying the initial link-entity elements, ad changing the alias

If you get stuck, try posting the fetchXml of what you have so far, and more detail on the output that you want

Was this reply helpful? Yes No