Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

nfeed query with customfield

m September 9, 2016

Hi,

 

I want to get dynamic data in nfeed field from sql query.

The idea is to get issues from project X and issue type Y, and customfield Z get value <value>

Customfield Z is a selectlist so it have options.

 

This query

#if ($!issue.customfield_15304 != '')
select j.SUMMARY from jiraissue j, customfieldoption o where j.PROJECT=10800 and j.issuetype=11409 and (o.id= $!issue.customfield_15304 and o.customvalue='<value>')
#end

Is not getting any values.

 

Whay am I doing wrong?

 

Cheers

 

2 answers

0 votes
Dhanalakshmi Mallapuram
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
May 31, 2019

how did this resolved?

Dhanalakshmi Mallapuram
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
July 30, 2019

fixed it try using below code in your query.

($issue.get("Product").stringList())

"Product" would be the custom-filed name

0 votes
Corentin Méhat
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 9, 2016

Hello,

you might want to ask the Valiantys dev team about your issue through a support request : https://valiantys.atlassian.net/

 

Suggest an answer

Log in or Sign up to answer