Jump to content

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


James Targett
 Share

Recommended Posts

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

Link to comment
Share on other sites

  • Victor changed the title to Adding OR criteria to report fler and ability to search for a text string

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...