Can anyone tell, why the following query is not working?

"select parent_name from cwd_membership where child_name = {reporter} and parent_name in (select group_name from RESPONSIBLE_TEAM where Team_Category != 'SME');" I am using the pluging "Database Custom Field" plugin and used above query. If i am using any hard coded value in place of {reporter}, then only its working fine. Please sugest any solution.

3 answers

1 accepted

You should upgrade to the latest version of databasecf for Jira 4.3, that is 1.1.3, in which reporter works correctly as query parameter on all screens.

Hi,

What version of Jira and databasecf plugin are you using? On which screen are you testing the custom field (edit issue, create issue, transition)?

I am using jira-4.3 version and databasecf-1.0.3 version. i am trying to do that on create and edit issue screen.

On edit issue the query should work when the page is loaded. The database custom field should show the correct values. It doesn't correctly update values when selecting a reporter from the autocomplete suggestions list, but it updates ok when selecting the reporter from the user picker popup or when entering manually the entire username for the reporter. You can use this alternative until a fix will be available.

Is the selection from autocomplete suggestions causing you the problem or the database custom field doesn't show the right values when entering edit issue? If second is the case, make sure the value stored in database for the column child_name matches exactly the reporter field value.

If that is not the problem, please add a request here http://bugs.kepler-rominfo.com , giving more details, such as log entries and screenshots.

not sure if it applies to your SQL, but in the property file the field value usually needs to be preceded by '$'

e.g.

sql.query=select case from simple_view where domain = '${_customfield_10943}' and area = '${_customfield_10944}'

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published May 30, 2018 in Marketplace Apps

Three tips for boosting your board's efficiency with Story Maps

Trello is one of the most effective tools for driving your sprints. It's customizable for every Agile team and product owners and Scrum masters (SM) love it. However, Agile teams often struggle with:...

852 views 2 9
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you