JoanneG Posted November 24, 2020 Share Posted November 24, 2020 Good Morning, I am trying to create a reports to search for requests which have the word Covid in summary/description, which was resolved on the previous day. However on checking the reports it isn't showing a request which was resolved yesterday, so i am not sure where i am going wrong, please see below my filter, can anyone provide me with advice. Thank you Joanne Link to comment Share on other sites More sharing options...
Bob Dickinson Posted November 24, 2020 Share Posted November 24, 2020 Hi @JoanneG Often in these scenarios, it's best to work backwards with a bit of trial and error. So the next step to take is to remove the 3 "Summary" and "Description" LIKE Clauses in your filter and just make sure that some results are returned (i.e. all Service Requests/Incidents that were resolved yesterday). Within that result set should be the one you are referencing (if it's not, then there is an issue with the other criteria). Then add the Clauses back in one by one, and check the Data Preview tab to ensure it gets filtered down and but still displays the request you are looking for to prove it's working. If you could give this a go, and let me know the results then we can go from there. (By the way - looking at your clauses, everything seems fine so far. So my first port of call would be to take a close look at the request you expect to be returned and ensure it meets all of the criteria). Kind regards Bob Link to comment Share on other sites More sharing options...
JoanneG Posted November 24, 2020 Author Share Posted November 24, 2020 Thank you I will have a look now Link to comment Share on other sites More sharing options...
Steve Giller Posted November 24, 2020 Share Posted November 24, 2020 @JoanneG I'll defer to Bob if I'm mistaken, but I think that Requests -> h_description value equals %covid% should be Requests -> h_description value is like %covid% as the equals function will not parse the % character as a wildcard. Also Requests -> h_description value is like %COVID-19% whould be covered by Requests -> h_description value is like %covid% as the comparison is not case sensitive and it contains covid. 1 1 Link to comment Share on other sites More sharing options...
JoanneG Posted November 24, 2020 Author Share Posted November 24, 2020 Thank you so much Bob, all working, didn't realise the filters need to be in a more logical order - new to reporting... Link to comment Share on other sites More sharing options...
Bob Dickinson Posted November 24, 2020 Share Posted November 24, 2020 Glad it's working@JoanneG! Let us know if there are any more issues And good spot@Steve Giller - I saw the the first "Covid Clause" had a LIKE but you're exactly right, the others had "equals" which would have caused an issue 1 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