BIP - search using wildcard and multiple values in a text parameter

Summary

BIP - search using wildcard and multiple values in a text parameter

Content

User would like to input values in BIP parameters and search using wildcards or multiple values. I have created the data model query with below

AND ( gjb.name IN ( :p_batch_name)

OR UPPER (gjb.name) LIKE UPPER ( :p_batch_name)

And, created a 'Text' parameter in the BIP report and ticked the box 'Text field contains comma-separated values'.

But, when running the report, it does not work for wildcard search (eg: BAT%) and does not return results even though there are matching records. 

Is there a way to resolve this and allow the user to search on both wildcard or multiple values in the same text parameter box.