Llyr Posted August 25, 2022 Share Posted August 25, 2022 Hi, Im trying to report on tickets that has specific information in a customer field. I have build a report with the following filters, but i get no returns, but i know calls should be returned. In the report here are my settings: I know there should be data here because when i run a query in the Database direct area i get outputs : What am i doing wrong?? Cheers Link to comment Share on other sites More sharing options...
Steve Giller Posted August 25, 2022 Share Posted August 25, 2022 is not the same as If you update your filters to match your WHERE clause you should see the same results. 1 Link to comment Share on other sites More sharing options...
Llyr Posted August 25, 2022 Author Share Posted August 25, 2022 OMG so simple, thanks. Any reason why the - ELS didnt work? the reason i didnt put the %ELS in the report as i didnt want it to pic up words that ended in ELS. Are report queries case sensative? Link to comment Share on other sites More sharing options...
Steve Giller Posted August 25, 2022 Share Posted August 25, 2022 4 minutes ago, Llyr said: i didnt want it to pic up words that ended in ELS Looking at the data from Direct Database, you can use "% ELS" to avoid that. 6 minutes ago, Llyr said: Any reason why the - ELS didnt work? Yes, but without picking apart the data and the report I wouldn't be able to say for certain, possibly the - is a modifier in MariaDb, or the - in the data is not a simple dash (e.g. an em-dash) etc. 2 Link to comment Share on other sites More sharing options...
Llyr Posted August 26, 2022 Author Share Posted August 26, 2022 Thank you so much for the help. Link to comment Share on other sites More sharing options...
Steve Giller Posted August 26, 2022 Share Posted August 26, 2022 18 hours ago, Llyr said: Any reason why the - ELS didnt work? Sorry - missed the obvious - "% - ELS" would have worked.LIKE without a % is the same as = 1 Link to comment Share on other sites More sharing options...
Llyr Posted August 26, 2022 Author Share Posted August 26, 2022 Thanks Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now