We added a custom field having Cascade Select field type that has two tier fields - First and Second on a create screen for an issue type. We set this custom field to be required, so if any user tries creating a ticket with "None" in both tier fields then the ticket can not be created.
We noticed few tickets were created just a value in first tier field, leaving it empty/blank or "None" on the second tier field. Now we need to identify all those related tickets that are left blank or "None" intentionally. Can you please help me with a filter search syntax to find all such relevant tickets?
Note: The firs tier field could have any value but just second tier field must be either blank or None