how to pass field value into the SQL query of another field (Jira_database_value_plugin.properties)?

[soumia]

Hi,

I am using the Database Value Plugin to populate two custom fields from an external SQL Server database.

For the first field field1 (sql.query=select name from table1) it is working properly.

But for the field2, I need to pass the selected value of field1 to the SQL query of the field2:

sql.query=select version from table1 where name = {field1.value}

This syntax is not working. Any help on this?

Thank you,

[Volodymyr Krupach]

Hi soumia!

I do not know syntax for the Database Value Plugin but I think you can use subselect, putting to the subselect query you use to get field1:

sql.query=select version from table1 where name = (select field1 from table2 where...)