Adding OR criteria to report fler and ability to search for a text string

[James Targett]

Hi, I am looking for advice on how to create a Select Filter when building a report in Hornbill. Due to data quality issues I'd like to add a criteria that is an OR rather than an AND when I press the + symbol. I'd also like to look for the occurrence of specific text in the Description field.

In SQL terms I want something like SELECT * FROM Requests WHERE (Service Name ="A" OR Description LIKE "%some string%') AND Status = Open

Thanks

James

[Deen]

@James Targett You can switch the 'AND's to 'OR's by simply clicking on them in the Select Filter criteria.

[James Targett]

Thank you!