Create a report against key word in Request>Summary Field

[Mark (ESC)]

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]

@Mark (ESC)

You need a 'LIKE Leaver%' against the summary field in your report filter, it will look something like this:

[Mark (ESC)]

Thank you @conor

That worked.

[Victor]

@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.