Advanced Filtering with ignoring one value

[László Földesi]

Hi Experts!

I need your help,

We have a backlog with many items, and i want to find which tickets come from real customer.

We using a Customer label for that, but many possible value possible for the customer label.

The common in the label is the TEST value, all ticket contains this, but the most important cases have a second value, but the problem they are many possible different values.

So my question how can i find the tickets which are contains the TEST value in the Customer label, but have another different value too.

project = XXX AND issuetype = XXX AND status in (XXX) AND Customer = TEST AND Customer = ??????

To delete the TEST value is not a good solution because an automatic provess create this ticket from another tool, and many other project use this.

Can you help me

Thnak you

[mogavenasan]

Hi @László Földesi,

One way of doing this is to export the result into CSV > Open in Excel > apply some Excel formula. 

Or if you know what is the different value, then your JQL is already sufficient

project = XXX AND issuetype = XXX AND status in (XXX) AND Customer in ("TEST", "XXX")

I hope that this helps.

Thanks,
Moga