BackendBughelp wanted
描述
Issue Summary
Cannot display JQL result with customfield type like radiobutton, list single, list multiple, ...
Steps to Reproduce
- Create a customfield in JIRA like "Select List (cascading)". Setup the field behaviour "options" with values.
- Create Jira issue and choose the value in list.
- Create in redash a new jql query like:
{
"fields": "summary,priority,customfield_xxxx",
"jql": "project = \"xxxx Service Desk\""
}
The column appears in the result set but there is no value.
For example, here is what I get with postman with a get on : https://myhost/rest/api/2/search?jql=issuekey=LSD-31401
"customfield_13592": {
"self": "https://myhost/rest/api/2/customFieldOption/14340",
"value": "Software",
"id": "14340",
"child": {
"self": "https://myhost/rest/api/2/customFieldOption/14372",
"value": "MySoftwareValueChild",
"id": "14372"
}
As you can see the customfield value is “MySoftwareValueChild”.
To search for this kind of value in jira, I use jql cascadeOption() function , first value is the parent and second value is the child value. See https://confluence.atlassian.com/jiracoreserver073/advanced-searching-functions-reference-861257222.html#AdvancedSearchingFunctions-cascadeOption%28
Technical details:
- Redash Version: 6.0.0
- Browser/OS: Firefox
- How did you install Redash: docker-compose (dev)