Saved DBCF value not being selected when issue is edited and field is dependent on a normal select custom field

Up until today I have always used the DBCF to reference other DBCF fields.  For some reason when I use a DBCF field with its query based on a Normal Jira select list, everything is working except the saved value is not auto selected the next time the issue is edited.  Thus unless the user reselects the value it get cleared. 

Using JIRA 5.1.8 and dbcf 2.1.22-SNAPSHOT

For example, this query works fine.  It loads the select list values properly and when one is selected it saves the value.  When viewing the issue you can see the value and when you edit it, the value is still selected.

SELECT TRIM(TEMP.CHILDVALUE) as FIELDVALUE, TEMP.CHILDID AS PK

  FROM SQLFEED_PROPOSEDRESOL_VIEW TEMP

  WHERE TEMP.CHILDFIELDID = 11702     

 AND TRIM(ISSUETYPENAME) = TRIM({issuetype})

 

This query however (this is the proper filter) based on the value of a normal select list does everything the same except when edited, the value is not selected.

SELECT TRIM(TEMP.CHILDVALUE) as FIELDVALUE, TEMP.CHILDID AS PK

  FROM SQLFEED_PROPOSEDRESOL_VIEW TEMP

  WHERE TEMP.CHILDFIELDID = 11702     

 AND TRIM(ISSUETYPENAME) = TRIM({issuetype})

 AND TRIM(CUSTOMVALUE) =  TRIM({customfield_10700})

 

I can always convert the parent field from a normal select list custom field to a DBCF but Since this almost works and according to the docs it should work is there something I am doing wrong or is this a bug?

1 answer

1 accepted

This widget could not be displayed.

Hi Jeff,

 

First of all, JIRA 5.1.x reached the end of life, so we don't support 2.1.x versions, but I will try to guide you in the right direction. I just tested your scenario and it works with the latest DBCF version(3.0.4). You will need to upgrade your JIRA to 6.0 or higher to use the 3.x version for our plugins.

 

Best regards,

Silviu

Thanks.. we will be migrating to 5.2 in a week or 2 :) Unfortunately I cant upgrade to 6.x until I replace nFeed as the next nfeed upgrade breaks my hacks on Jira Behaviours and I can't keep hacking the behaviours plugin every time nFeed upgrades. I was hoping to be be able to replace it before upgrading but at least I know this should work so I can make it part of my 6.X upgrade.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Thursday in United States

Local Atlassian Research Workshop opportunity on Sep. 28th

We're looking for participants for another workshop at Atlassian! We need Jira admins who have interesting custom workflows, issue views, or boards. Think you have a story to sh...

42 views 0 0
View post

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