Multi Level Cascade based on values from Driving table

This is an example of a Multi Level Cascade field, used to populate dependent values.

Data stores in a previously created driving table. The values will be used to query data in the multi cascade field.

You want to select service type in the Type column and based on the type select the service name in the Name column.

Configuration

Create driving table with basic values

We assume you already have a driving table solutions_d5 containing the basic values
Create Multi Level Cascade field and query data from the driving table

The field configuration is following:

##############################
# Define the levels which makes up this custom field
#--------------------------------------------
mc.levels = type, name, user

##############################
# Define where the data is coming from
#--------------------------------------------
mc.ds=jira

##############################
# First level - list of types
# Query types from the driving table 'services_d5'
#--------------------------------------------
level.type.query = select distinct type from services_d5

##############################
# Second level - list of names
# Query names from the driving table 'services_d5', depending on the type
#--------------------------------------------
level.name.query = select name from services_d5 where type = {type.type}

##############################
# Third level - list of users
# Query users from the jira database
#--------------------------------------------
level.user.query = select user_name from cwd_user