JQL cannot return child custom field value

Issue Summary

Cannot display JQL result with customfield type like radiobutton, list single, list multiple, ...

Steps to Reproduce

1. Create a customfield in JIRA like "Select List (cascading)". Setup the field behaviour "options" with values.
2. Create Jira issue and choose the value in list.
3. 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)