level.xyz.query

Use this to specify the query of the Multi Cascade's level (select list)

xyz is a placeholder for the actual level id.

Placeholders are case sensitive.

level.user

is different from

level.User

Class	level
Property	level.xyz.query
Formal specification	level.xyz.query = <datasource specific query>
Required	required in case it is not the MLCF basic config
Default
Version	1.25
Comment	There are 2 sources to populate a list: a query from a database a customfield of JIRA The Multi Cascade will know that it is either the first or the second based on the property value. If the property value starts with 'customfield:', the list will be populated with the custom field options, otherwise the query will be considered as a sql query. The sql query can contain a placeholders which are replaced with the corresponding value Accessing the selected level can be done with {levelName.columnName} Any other issue values can be used in the sql query

Example

mc.levels = country, city, street
mc.ds=jira
...
level.country.query = select distinct countryName from worldcities
...
level.city.query = select name from woldcities where country = {country.contryName}
...

Reference

MLCF configuration
level.xyz.viewColumn
level.xyz.storeColumn
level.xyz.query.ds
Vehicle Year Make Model cascade