Setup Field Criteria in MDF objects to filter values using association and/or field criteria

[Former Member]

Objective: under Manage Data: I would like to filter Field2 value by Field1 values. e.g. If Field1 value is USA then Field2 should appear with only N1, N2 and nothing else. and same with other countries. I would like to do it using association, field criteria. No business rule.

This is my scenario:

Parent MDF object = Country (usual MDF FO)

Child MDF Object = mycity (custom GO)

Effective dating= Basic

Association -> ONE to MANY -> Country

Three values are stored under "mycity"

e.g. N1 under Country=USA

e.g. N2 under Country=USA

e.g. M1 under Country=India

e.g. P1 under country= Japan

Final MDF object where I recall above objects = mainform

Effective dating = Basic

Field1 (Name of country) = "Country" (GO)

Field2 (Name of my city) = "mycity" (GO) -> Under Field2 "Field Crieteria" set as below

I appreciate your direction.

Regards,

Raj

[Latyshenko2]

Hi Raj!

I know I am late, but anyway))

In your scenario, I suppose the names of fields are cust_Field1 and cust_Field2

In cust_Field2 you need to configure the Field Criteria as follows:

Source Field Name: cust_toCountry.internalId

Destination Field Name: cust_Field1

Also, see my blog for other cases:

https://blogs.sap.com/2021/07/10/definitions-of-field-criteria-for-mdf-objects-in-employee-central/