Advanced filter help

[jovanio_junior]

I have a database that has some primary keys that I can search in Jira.

But I can't add more than one data to perform the search for all items.

For example:

project = XPTO AND "CNPJ" ~ "001001001001"

So I can find the item in Jira.

But I would like to add all the CNPJs so that the search brings all the corresponding items.

But this doesn't work:

project = XPTO AND "CNPJ" ~ "001001001001,002002002002,003003003003"

Putting a comma in the search keys is not enough to perform the search.

Is there another method that is effective?

[Walter Buggenhout]

Hi @jovanio_junior,

If you want to search for multiple items, you need to use OR in you search. And as soon as you do so, it becomes important to use () to make sure you combine your criteria correctly. The following might do the trick:

Project = XPTO AND (CNPJ ~ "001001001001" OR CNPJ ~ "002002002002") OR
CNPJ ~ "003003003003")

 Hope this helps!