Filtering on multi-select field

[JIRA.USER]

[INTRODUCTION]

• Here the request is very simple : to know the BUGs that were  INITIALLY reported on a given SW version.
• The filed that is used is affectedVersion, this filed is a Multi-select field
• Therefore :
  • BUG_A : could have affectedVersion = 001, 002, 003, 004
  • BUG B : could have affectedVersion = 003, 004, 005
  • BUG C : could have affectedVersion = 002, 003
    
    

      QUESTON : 

• Which are the BUGs that were  INITIALLY reported on SW version 003 ?
  • Expected answer : BUG B
  • NOT Expected : BUG A and BUG C to be shown in the results (even if their affectedVersion contains 003)

---------------------------------------------------------------------------------------------

[DESCRIPTION]

As per the above explanation, is there any way to NOT have to manually list all the existing SW Versions that we want to exclude in the result ?

This would need manual filter update when a new SW version released.

Could lead to errors, by forgetting to exclude some SW versions.

FILTER EXAMPLE : 

project in (SPIC) AND issuetype = Bug AND component in (FEATURE_A) AND affectedVersion in (SW_3.8, SW_3.8.0) and affectedVersion not in (SW_2.0, SW_2.1, SW_2.1.1, SW_2.2, SW_3.0, SW_3.0.0, SW_3.0.1, SW_3.0.2, SW_3.1, SW_3.1.0, SW_3.1.1, SW_3.10, SW_3.11, SW_3.12, SW_3.13, SW_3.4, SW_3.4.0, SW_3.4.1, SW_3.5, SW_3.5.0, SW_3.6, SW_3.6.0, SW_3.6.1, SW_3.6.2, SW_3.6.3, SW_3.7, SW_3.7.0, SW_3.7.1)

GOAL : 

Therefore here, to show all the BUGs initially raised on SW_3.8, SW_3.8.0

---------------------------------------------------------------------------------------------

[ADDITIONAL INFORMATION]

• Version : Jira v8.20.7
• License Type : Jira server platform
• I am only using : BASIC or ADVANCED JIRA filter feature is used
• I am not using : JSON macro
  • don't have access or don't know how to use
  • but staying open to know how to, if a must to solve this current issue