Using Advanced Find to create a View to show the ralative Entity's record value - urgent

(0) Share

Report

Posted on by Datadvancer

Hi Expert,

I need create a view for one of the Entity-Product. Two of the columns named Retail Price and Wholesale Price which come from another relative Entity- Price. Product and Price have N:1 relationship. Price have setup a subgide in the Product form and have associate view (There are no "Retail Price" and "Wholesale Price" fields in the Product Field List)

Using Advanced Find, when I created the View for the Product, I selected the relative Entity and then select "Retail Price" and "Wholesale Price" to set to "Contains Data". After save and give it a proper name, I need edit the column. When I click the “add Column” , I found the default record type is Product. When I try to select the relative Price from the dropdown list, I cannot find it! What’s wrong happened/I go through a wrong way? Please kindly give me a advice Thanks in advance.

Or for this scenario, can you suggestion another best practice approach?

Categories:

Enterprise Service Settings

I have the same question (0)

All responses (15)

Answers (4)

Verified answer

RaviKashyap 55,410 Moderator on at

Like (0)

Report

Hi,

This is because the N:1 relationship doesn't appear on the list to add column from. This is because if you add column from that relationship, the results will not have unique value for products.

For example, let suppose you have this data

Product1, Price1

Product1, Price2

You can only add fields from the related lookup field on the main entity.

I don't think there is any way to show this kind of data in a view :(

Hope this helps.

Was this reply helpful? Yes No
Datadvancer on at

Like (0)

Report

Hi Ravi,

Thanks very much for your answer.

But I ‘d made a big mistake, that is the Product and the Price relationship is 1:N. This way how to adjust your answer and kindly give me an suggestion?

Was this reply helpful? Yes No
Verified answer

RaviKashyap 55,410 Moderator on at

Like (0)

Report

Hi,

I knew/know that cause you have mentioned that you have a subgrid of Price in Product form which means you will have multiple Prices for a product. So the response doesn't change. You cannot display a field from a 1:N related entity.

Hope this helps.

Was this reply helpful? Yes No
RaviKashyap 55,410 Moderator on at

Like (0)

Report

The 1:N relationship is confusing sometime as the direction changes based on the entity. So if you look from Product, you will see the relationship as 1:N whereas if you look into price entity, you will find the relationship as N:1. This is why whenever I discuss, I describe it as Subgrid on the form or lookup field on he form. I use the word relationship for N:N cause that doesn't change with entity :)

Was this reply helpful? Yes No
Datadvancer on at

Like (0)

Report

Thanks Ravi. Is there any other way to do that, e.g. using workflow, business rule or any out of the box customization?

Was this reply helpful? Yes No
Datadvancer on at

Like (0)

Report

Hi Ravi, I have not read your last note when I summit mine. I reading it now. Thanks.

Was this reply helpful? Yes No
RaviKashyap 55,410 Moderator on at

Like (0)

Report

As mentioned above, I don't think there is any other way for the reason that it will return duplicate products. You could query Prices and then add the product details if you like.

Was this reply helpful? Yes No
Datadvancer on at

Like (0)

Report

Hi Ravi,

Could you explain more detail procession of "query Price and then add the product details"? Thanks.

Was this reply helpful? Yes No
RaviKashyap 55,410 Moderator on at

Like (0)

Report

Currently you are creating an advance find and select the Product as main entity. If you select Price as the main entity, you can then add columns from the product entity. The same thing which you are currently doing but changing the entities around i.e. first select Price and then add columns from products.

Was this reply helpful? Yes No
Suggested answer

RaviKashyap 55,410 Moderator on at

Like (0)

Report

something like this (Test Entity is a custom entity similar to Price-

Was this reply helpful? Yes No