how do i filter jira tickets excluding few label values but including once which has not label assig

unknown

• i have list of tickets which has specific labels (cdms, cdms_t1)
• there are few which are without label (empty values)
• there are few which does have values other than mentioned in bullet 1 
  
  
  Query i am using is 
  issuetype = Bug AND affectedVersion = "DV 2022.R1.0" AND labels not in (cdms, CDMS, cdms_T1, cdms_T2, cdms_T3, cdms_T4, cdms_T5) AND statusCategory in (2, 4) ORDER BY labels ASC, created DESC
  
  but this result doesn't give me tickets which has null value of label. 
  
  only retuns the tickets which has label (third bullet point list ) 

Bastian Stehmann

Hi,

 

You could try

 

issuetype = Bug AND affectedVersion = "DV 2022.R1.0" AND ( labels not in (cdms, CDMS, cdms_T1, cdms_T2, cdms_T3, cdms_T4, cdms_T5) or labels is empty) AND statusCategory in (2, 4) ORDER BY labels ASC, created DESC