will.good Posted January 23, 2023 Share Posted January 23, 2023 Hi, Hoping this is possible and i'm just not understanding properly. Using the filters in Service Manager > Reports is it possible to filter for contains? e.g. Job Title contains the word 'People' I have tried using Value is like but not getting anywhere Link to comment Share on other sites More sharing options...
Steve Giller Posted January 23, 2023 Share Posted January 23, 2023 Are you using the % wildcard in your "is like" clause? i.e. "Begins With%" "%Ends With" "%Contains%" Link to comment Share on other sites More sharing options...
Sam P Posted January 24, 2023 Share Posted January 24, 2023 See also here, hopefully this can be updated soon Link to comment Share on other sites More sharing options...
will.good Posted January 24, 2023 Author Share Posted January 24, 2023 22 hours ago, Steve Giller said: Are you using the % wildcard in your "is like" clause? i.e. "Begins With%" "%Ends With" "%Contains%" Hi @Steve Giller, Yes, I have tried all of these, but I get no results back on all of them (Attribute 2 is where Job Title is stored for us) I would expect quite a lot of results as one of our biggest customer base is People Managers Link to comment Share on other sites More sharing options...
Steve Giller Posted January 24, 2023 Share Posted January 24, 2023 I don't think you need the quotes in the Report Builder, try without them and see what you get. 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