nfeed query with customfield

[marc]

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

[Corentin Mehat]

Hello,

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

[Dhanalakshmi Mallapuram]

how did this resolved?

[Dhanalakshmi Mallapuram]

fixed it try using below code in your query.

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

"Product" would be the custom-filed name