How to filter from custom fields?

[C. Erico]

I have a custom field called "Product Line" and it contains text such as Seller A, Seller B, Buyer A, Buyer B, etc

How do I filter if a "Product Line" to show only Seller and not Buyer?

I tried using !~ but it doesn't supported by the 'Product Line' field.

Thanks!

[Brant Schroeder]

@C. Erico Welcome to the Atlassian Community

I am assuming that you are using a dropdown field custom field.  If that is the case then you will need to use in or not in  and list the options that you would like to include or exclude.  

[C. Erico]

@Brant Schroeder I see, can you give me an example on how to use the query? I just tried it and it seems to be not working

[Brant Schroeder]

"Change reason[Dropdown]" in (Maintenance, "New functionality", Repair)

 For you  "Product Line" in ("Seller A", "Seller B")