I have a Jira 6.1 install with the Database Values Plugin v 3.0
I create a field (# 10190, name CustomerDB) which gets additional info from another DB.
I'm trying to use this as part of a REST API query.
It works well in the fields selection: I can add &fields=customfield_10190 to have it in the produced fields. But I can't make it work in the jql itself.
I tried:
Here's the properties file:
database.driver=net.sourceforge.jtds.jdbc.Driver database.user=... database.password=... database.connection.url=jdbc:jtds:sqlserver:.... cache.timeout=1 sql.query=select SERNUM, CUSTNAME, CUSTDES, SERN from dbo.SERNUMBERS LEFT JOIN CUSTOMERS ON SERNUMBERS.CUST=CUSTOMERS.CUST WHERE PART=5 ORDER BY SERNUM; primarykey.column.number=3 rendering.viewpattern={0} (Customer {1} - {2}) rendering.editpattern={0} (Customer {1} - {2}) rendering.searchpattern={0} (Customer {1} - {2}) edit.type=0 search.type=0 jq1.1.query.reference=CustomerDB jql.1.query=select SERNUM from dbo.SERNUMBERS WHERE SERN='QUERY_VALUE';
Any clue?
Thanks
The plugin makes it so that there's apparently no way you can query any database field. You can only use the primary key of the DB like this:
/rest/api/2/search?jql=CustomerDB=23&fields=...
Does the JQL work if you type it in JIRA itself ? If not, then try to get that working first.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.