var mismatch error during database lookup

Description

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}

Environment

jira version 7.12.3
app version 1.6.5-jira7

Activity

Show:
Deniz Oğuz
March 13, 2019, 5:57 PM

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:

Russell Estes
March 13, 2019, 7:45 PM

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.

Deniz Oğuz
March 13, 2019, 7:47 PM

I think your issue is resolved. I'm closing this issue now. Please fill free to contact us again if you need anything else.

Answered

Assignee

Deniz Oğuz

Reporter

Russell Estes

Labels

None

Source

None

Jira Version

None

Database Type/Version

None

Browser Type/Version

None

Priority

Major
Configure