Summary

JQL search based on Select List (cascading) results in the error:

An option provided by the function 'cascadeOption' for the field 'xxxxx' does not exist.

Steps to Reproduce

1. Create two projects, let's call them Project A and Project B
2. Create a customfield of type "Select List (cascading)", which we will name CasField
3. Add the customfield to the issue create and edit screen schemes.
4. Create two contexts for the customfield CasField: Context A and Context B.
   • For Context A, add the options as shown in the screenshot below and assign it to Project A.
     
   • For Context B: Add the options as shown in the screenshot below and assign it to Project B
     Note, the cascadeOption ABC updated here is in uppercase, it was in lower case in Context A.
     
5. Create a few issues in Project A and Project B by passing the custom field values.
6. The JQL below helps to filter the issues based on the cascadeOption.
   
7. Navigate to Settings> Projects, delete Project B
8. Execute the same JQL

Expected Results

The JQL filters the Jira issues based on the cascadeOption.

Actual Results

The JQL fails with the following exception:
 

An option provided by the function 'cascadeOption' for the field 'CasField' does not exist.

Workaround

Avoid using a mix of upper and lower case options in the context.
In the case described, updating context B to lowercase "abc" or context A to uppercase "ABC" helps resolve the issue.