Report with more than one parameter

Hello,

I created a Report with SQL-Query "SELECT ed.Name FROM EventDefinition ed WHERE ed.Name LIKE p_SearchString"

p_SearchString will be defined by submitting the Report. (e.g. %daily%)

I want to change the report to create a list of Eventdefinition with more than one SearchStrind (e.g. where the Name contains "daily" or "monthly")

I tried:

1.

SQL-Query "SELECT ed.Name FROM EventDefinition ed WHERE ( ed.Name LIKE p_SearchString )"

Prerunning Action:

String strSearchString = jcsJob.getJobParameterByName("p_SearchString").getInValueString();

if (strSearchString.indexOf(";") != -1)

{

jcsJob.getJobParameterByName("p_SearchString").setInValueString(strSearchString.replace(";","' OR ed.Name LIKE '"));

jcsJob.getJobParameterByName("p_SearchString").setInValueString("'" + jcsJob.getJobParameterByName("p_SearchString").getInValueString() + "'");

}

2.

SQL-Query "SELECT ed.Name FROM EvenDefinition ed WHERE ( p_SearchString )"

Prerunning Action:

String strSearchString = jcsJob.getJobParameterByName("p_SearchString").getInValueString();

if (strSearchString.indexOf(";") != -1)

{

jcsJob.getJobParameterByName("p_SearchString").setInValueString(strSearchString.replace(";","' OR ed.Name LIKE '"));

}

jcsJob.getJobParameterByName("p_SearchString").setInValueString("ed.Name LIKE '" + jcsJob.getJobParameterByName("p_SearchString").getInValueString() + "'");

But both versions don't work.

How may I redesign the Report for using more than one SearchString?

Best regards

Dana Ullrich