Mark (ESC) Posted October 2, 2020 Posted October 2, 2020 Hi All Probably easy, how do you create a report against key word in Request>Summary Field. So looking to create a report that lists an requests open or on hold that start with the word 'Leaver' Thanks
Conor Posted October 2, 2020 Posted October 2, 2020 @Mark (ESC) You need a 'LIKE Leaver%' against the summary field in your report filter, it will look something like this:
Victor Posted October 6, 2020 Posted October 6, 2020 @Mark (ESC) Nothing wrong with the advice above (good advice for the report itself). However, personally I try to avoid using LIKE as much as possible anywhere... So, I would suggest a different approach to this scenario. I assume the requests having that summary are request to process leavers. If this is correct maybe you can make use of a custom field on the request to mark that request as a "leaver request". This way you don't have to rely on the summary having the word leaver (summary might change) and you can build much friendlier reports afterwards. Just a thought.
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