We have 3 different picklist fields in our Case object


  • Queue controls Type values.

  • Type controls Area values.

I would like to know whether there is a way to export picklist values in the following format from the application depending upon the controlling-dependent field mappings.

For Example

Queue values are : {Q1,Q2,Q3}

Type values are : {T1,T2,T3}

Area values are : {A1,A2,A3}

Contolling-dependent mappings are as follows

Queue-Type mapping




Type-Area Mapping




My desired output should be




I am okay if the solution is obtainable via code also.

Can someone throw me some pointers as to how can I achieve that ?



Browse other questions tagged .