How to add multiple Filters by Using Contain Function?

[Loganathan Suresh]

Eg., I want to Search filters which contains Base Hotfix Release ID's IN MHF or Data. 

Also, I want Base Shipment Release ID's contains "PHF". 

I'm trying the following, but getting error.

project = AHIC AND status in ("Fix Deployed (Staging 1)", "Fix Reviewed(Staging 1)") AND ("Base HotFix Release ID" IN ~ ("*MHF*, "*DATA*" ) OR ("Base Shipment Release ID" ~ "*PHF*"))

Error in JQL Query: Expecting either a value, list or function but got '~'. You must surround '~' in quotation marks to use it as a value. (line 1, character 119)

Any Way to do so?

[Mark Segall]

Hi @Loganathan Suresh and welcome to the community!

Adding filters to queries does not work this way.  You'd have to explicitly add each filter you want covered in the JQL.  For example:

project = AHIC AND filter IN ("MHF1", "MHF2", "DATA1","DATA2")