Adding ProductName to EcoResReleasedProductV2Entity extension

(2) Share

Report

Posted on by EK-26061005-0

429

I have tried adding the product name by using EcoResProductTranslationFallbackView as an EcoResProduct datasource and directly adding the Name field in the entity, but visual studio does not allow creating a relation like "EcoResProduct.RecId == EcoResProductTranslationFallbackView.Product". Is there a better way of adding the ProductName to the entity?

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

Justin Kruger 183 on at

Like (0)

Report

Adding ProductName to EcoResReleasedProductV2Entity extension

Hi @EK-26061005-0,

The exact data requirements are a bit unclear to me, but if you require the translations only for specific languages would adding a range to EcoResProductTranslation table help you ?

Was this reply helpful? Yes No
EK-26061005-0 429 on at

Like (0)

Report

Adding ProductName to EcoResReleasedProductV2Entity extension

Hello @Justin Kruger, thanks for the fast reply.

Joining only the EcoResProductTranslation table still causes data multiplication for every language that has this field's translation. I also need to specify which language will be used (Ideally with SystemLanguageId from SystemParameters)

Was this reply helpful? Yes No
Suggested answer

Justin Kruger 183 on at

Like (0)

Report

Adding ProductName to EcoResReleasedProductV2Entity extension

Hi @EK-26061005-0,

Have you tried joining the base EcoResProductTranslation table to the EcoResProduct table in your entity extension.

You can then add the Name field from EcoResProductTranslation to your entity field list.

Was this reply helpful? Yes No
EK-26061005-0 429 on at

Like (0)

Report

Adding ProductName to EcoResReleasedProductV2Entity extension

Hello Mohamed,

In order to use the method i have to add the view as datasource first, which causes unnecessary data multiplication if the view has no relations. I have also tried manually adding the SystemParameters and EcoResProductTranslation tables as datasource but again i'm not allowed to add the necessary relations as it's always empty in either the join datasource field or the related field:

Was this reply helpful? Yes No
Suggested answer

Mohamed Amine Mahmoudi 26,292 Super User 2025 Season 2 on at

Like (0)

Report

Adding ProductName to EcoResReleasedProductV2Entity extension

Hi @EK-26061005-0,

I think you can add a new computed column in entity extesion since it's a method in this view.

Best regards,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No