ERROR: operator does not exist: character = bigint Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts. Position: 63
Fields used - Single Select++ and Database Lookup++
populated single select with row a from database
lookup using single select field from database row b
Have tried type cast but did not correct issue.
here is the sql query used against postgreSQL v9 database -
SELECT short_name
FROM department_short_names
WHERE long_name = {customfield_11449}
jira version 7.12.3
app version 1.6.5-jira7
If I understand you correctly customfield_11449 is a select++ field. In that case you need to use either id or name of this field as follows:
That was it - I read that in the docs but it did not translate that I need to pick what I needed from the select list.
I think your issue is resolved. I'm closing this issue now. Please fill free to contact us again if you need anything else.