How to distinct fetchxml on subgrid

(0) Share

Report

Posted on by Jeroen J

415

So, okay, here goes nothing.

I’m trying to display a subgrid on my custom new_project entity. This subgrid should show invoice attributes from invoices related to invoicedetails with which the new_projectid is related (we can invoice over multiple projects, each in his own invoicedetail).

If I create the desired system view, the disctinct="false" and there is an invoicedetailid attribute added (obviously I didn’t add that myself)! This can easily result in one invoice occurring 14 times in the subgrid.

So, I tried to set the distinct on true in the fetch and removed the invoicedetailid from it. Now I receive this pesty errormessage telling me that “Columns should always be specified on RetrieveMultiple”. That’s where my “mess up fetchxml”-skills are dried up. I tried to do the same using XRMToolbox’s FetchXML builder, but that won’t allow me to remove the invoicedetailid attribute.

Any thoughts?

Thanks,

Jeroen

All responses (2)

Answers (0)

Jeroen J 415 on at

Like (0)

Report

RE: How to distinct fetchxml on subgrid

Hey Mike,

thanks for getting back to me this fast.

No, I haven't tried that, because it's very possible that there will be more than only 1 invoices that need to be displayed.

Any other ideas maybe?
Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: How to distinct fetchxml on subgrid

Have you tried using a <fetch top="1" >