how to cascade columns in DRIVING TABLE of table grid editor plugin

[Ignat]

hello everyone

my goal is to develop driving table with colums:

- project

- issue type

- status

it wold be covinient to use lists to populate it, and make list of options for issue type column dependent from value, selected in project column.

now my implementation looks like:

gd.columns=team, projectName, issueTypeName, resolutionStatusName, someComment
gd.tablename=resolutionStatuses
gd.ds=jira

# taking the list of values from customfield
col.team=Команды
col.team.type=list
col.team.query=select customvalue from customfieldoption where customfield=24590 order by sequence
col.team.query.ds=jira
col.team.autocomplete=true
col.team.required = true

# taking project names from jira db table
col.projectName=Проект
col.projectName.type=list
col.projectName.query=select p.pname as projectName from project p order by projectName asc
col.projectName.query.ds=jira
col.projectName.autocomplete=true
col.projectName.required = true

# taking issue types with comples SQL request from jira db
col.issueTypeName=Тип Задачи
col.issueTypeName.type=list

col.issueTypeName.query=select distinct it.pname as issueTypeName from project p join configurationcontext cc on p.id = cc.project join fieldconfigschemeissuetype fci on fci.fieldconfigscheme = cc.fieldconfigscheme join optionconfiguration OC on OC.fieldconfig = FCI.fieldconfiguration join issuetype it on it.id = OC.optionid order by it.pname asc
col.issueTypeName.query.ds=jira


col.resolutionStatusName=Имя статуса
col.resolutionStatusName.type=string

col.someComment=Комментарий
col.someComment.type=string

but when

I try to parametrize SQL request, populating col. projectName with

where p.pname = {projectName}

table crushes.

is it possible to populate driving table column based on another column value, or that's the option for tables in customfield of issues only?

and btw... how to split SQL request for several lines there?

[ABRAR ALI]

Hi @Ignat ,

Did you find a way to do this  ?

-Abrar