James Targett Posted May 5, 2020 Share Posted May 5, 2020 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 More sharing options...
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
Already have an account? Sign in here.Sign In Now