It’s been awhile since I last wrote a blog. I’ve been extremely occupied with multiple projects along with the many holidays at the end of the year. Kicking off this year with a new client translates to various new requirements in need of solutions. One in particular was to basically filter a child picklist from a combination of two parent picklist value.

In this blog post, I would like to share a detailed solution using MDF to achieve the similar result without a single use of business rules.

To put it in a simple example, I would use Country, Cuisine and Food to illustrate the solution.


Configuring MDF objects

Country is already an existing MDF object. So I only need to create a new MDF for Cuisine and Food.

/wp-content/uploads/2016/01/1_869453.jpg

/wp-content/uploads/2016/01/2_869454.jpg

You must remember to define the associations to its “parents”

/wp-content/uploads/2016/01/3_869455.jpg

Manage Data

Now we need to maintain a couple of records.

/wp-content/uploads/2016/01/4_869456.jpg

For Food Type, we need to define the values based on the combination of country and cuisine.

In my example below, all cuisine types are Asian, but the countries are different.

/wp-content/uploads/2016/01/5_869457.jpg

/wp-content/uploads/2016/01/6_869458.jpg

/wp-content/uploads/2016/01/7_869459.jpg

/wp-content/uploads/2016/01/8_869460.jpg

Combining all the MDF objects

The final step is to define all the MDF created into a target. For my example, I would just be using position.

Define custom fields for each respective MDF.

/wp-content/uploads/2016/01/9_869461.jpg

Remember to include the field criteria for FoodType as per below. 

/wp-content/uploads/2016/01/10_869463.jpg

Results

Go into manage data, either create new or edit the target MDF which we have combined all the MDF into.

When no country or cuisine is defined, food type returns 0 results

/wp-content/uploads/2016/01/11_869464.jpg

Even though we define Asian as our cuisine, food type still returns 0 results

/wp-content/uploads/2016/01/12_869465.jpg

Only after both country and cuisine has been defined we will get the returning result based off data maintain in the food type MDF.

/wp-content/uploads/2016/01/13_869466.jpg

/wp-content/uploads/2016/01/14_869467.jpg

Thank you,

Leon Lee

www.veritasprime.com | www.helpmycloud.com

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply