filter with space
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-14-2019 06:59 AM
To add a filter for incident search, We have used the filter "assigned_to=Bud Richman" which returns zero entries. When there is space in filter value, it seems '=' operator is not working.
Can anyone please suggest a method to filter the exact entry when the filter value contains space ?
Thanks,
- Labels:
-
Best Practices
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-24-2020 05:24 AM
Can you include a screen shot or explain further where you are attempting to create this filter?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-24-2020 11:40 AM
Hi ,
I think that is not possible. Please remove existing space from name.
Thanks,
Sumanth
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-24-2020 11:57 AM
in case you need it in via code,
could be like below
gr.addEncodedQuery("assigned_to.user.name='Bud Richman'");
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-25-2020 01:16 AM
Hi Pinto,
I think (as nataliya_b points out) you are missing single quotes around the first and last name.
Perhaps be more specific where you have used the query and if you used it via a script or in the filter condition builder in the UI environment.
If via script, this should be a good approach as well:
var grIncident = new GlideRecord('incident');
var returnValue = grIncident.get('caller_id.name','Sylivia Wayland');
(where in your case caller_id.name should be of course the assigned to field).
If you think my answer put you in the right direction or you appreciated my effort, please mark the response as Helpful (👍). That way other people in the community will probably be triggered to read the responses too. If my answer solved your issue, please mark my response as Correct (✅). In the list of question people like me that want to help out will know your question was already answered and others that are curious to the answer know a good answer is given in the thread.
Thanks in advance! Good luck!