Filter Lookup bases on N:N relationship

(0) Share

Report

Posted on by Amine Amine

HEllo ,

I have a 4 tables :
Product table (virtual table from SAP)

Contact table (standart table)
Contact-Product (Contains the contact and product information as I cannot create N:N relationship for virtual tables)

In another table called Item I have a lookup to Product , so it shows all the products,

I want to filter this lookup to show only the product the user have access to based on the Contact-product table

How I acheive that, I dont want to create relationship between Contact-product and Item , because the contact product it's not used in the SAP,

Categories:

Customize & extend

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

SaiRT14 1,990 Super User 2025 Season 2 on at

Like (0)

Report

Pls try the following:

In your Item lookup's View definition, use FetchXML to filter products based on the current user's access:

<fetch>
<entity name="product">
<attribute name="productid" />
<link-entity name="contact_product" from="productid" to="productid" link-type="inner">
<filter>
<condition attribute="contactid" operator="eq" value="@UserId" />
</filter>
</link-entity>
</entity>
</fetch>

Was this reply helpful? Yes No