Validation

[Former Member]

Hi All

Need help in writing a validation

Say I have 5 plants and there are Item types mapping respective to the Plant codes.

I in MDM want the ItemTypes to be displayed based on the Plant selected.

Ex: P1 has IT1,IT3,IT5

When Plant P1 is selected the ItemTypes should show only IT1,IT3,IT5.

Please suggest

Regards

Shifali

[Former Member · Accepted solution]

Transferred this logic to be implemented in Portal.

Regards

Shifali

[Former Member]

hi Shefali,

Create a single table with both plant and Item types in it and use Free form search to sort as per plant.

Even if you think of writing an expression on this, if you have 100 Item types for one plant it would lead to a very complex solution.

Thanks and Regards,

Shahid Noolvi

[former_member226173]

Hi Shifali,

I do not think Validation can help you here .

Can you explain what is the current structure of your system

What is are the table types used ??

Regards,

Vag Vignesh Shenoy

[Former Member]

My tables are flat..

Both the plants table and Mapping table are look up  Flat

Regards

Lakshmi

[former_member226173]

Hi Shifali ,

I see 2 possible solutions .

1) Maintain a Hierarchy so that plant will be the parent and all the Item Types can be mapped to a specific type of Plant

2) If you have a Portal Interface you can use the below solution

In the Item Types table add one more field called Plant looking up to the Plant table , now when the Portal fetches the data from the Item Types table you can place a logic in the Portal such a way that depending on the Plant value the Item Types can be displayed .

Regards

Vag Vignesh Shenoy