Hi,
I am using Database custom field plugin from CPrime. Below is the postgres sql query for the database custom field "Error Details"
select ErrorGroupsQACE.ErrorDef from ErrorGroupsQACE where ErrorGroupsQACE.ErrorCode = CAST ({customfield_13804} as numeric) and ErrorGroupsQACE.Status = 'Active'
It is listing the correct values on the Jira issue creation screen. But problem is that whenever I choose the option in the Error Details field, error message getting logged into the jira log file as below
ERROR madhura 184x10946x1 ewcjn 10.0.70.48,127.0.0.1 /secure/QuickCreateIssue!default.jspa [c.k.j.p.d.querydb.impl.QueryDatabaseImpl] Could not execute SQL query >>select ErrorGroupsQACE.ErrorDef from ErrorGroupsQACE
where ErrorGroupsQACE.ErrorCode = CAST (? as numeric) and ErrorGroupsQACE.Status = 'Active'<< on database JIRAPRODPG.
org.postgresql.util.PSQLException: ERROR: invalid input syntax for type numeric: ""
Please let me know if i am missing something in sql query?
Regards,
Madhura
I resolved it by changing the type cast in the query as below
select ErrorGroupsQACE.ErrorDef from ErrorGroupsQACE where CAST(ErrorGroupsQACE.ErrorCode varchar) = CAST ({customfield_13804} as varchar) and ErrorGroupsQACE.Status = 'Active'
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.