Apostrophe in user name breaks query builder

Announcements

ATTENTION Customers, All Partners and Employees: The Customer Support Portal (CSP) will be undergoing maintenance and unavailable on Saturday, November 7, 2020, from 11 am to 11 pm PST. Please read our blog for more information.

Reply
Highlighted
L3 Networker

Apostrophe in user name breaks query builder

Hi all,

I have a username in my organisation that is domain\john.o'neill and I'm finding that when I try to do a query such as (user.src eq 'domain\john.doe') it's fine, but when I put in (user.src eq 'domain\john.o'neill'). I appreciate that this is because I'm esentially saying (user.src eq 'domain\john.o' ) but with neill' on the end.

Is there a way around this or another way of approaching it? Doubles quotes (") don't work and while I know that having an apostrophe isn't ideal for a user name, it's something I've inherinted.

Any ideas would be greatfully received.

Thanks,

UKRB.

Tags (2)
Highlighted
L3 Networker

i would suggest creating a case for this issue. while you open a case if you enabled debugging on the web ui and replicate the issue this should provide us with some additional data.

To turn on UI php.debug.log, http(s)://xxxx/debug then click on Debug button.

Like what you see?

Show your appreciation!

Click Like if a post is helpful to you or if you just want to show your support.

Click Accept as Solution to acknowledge that the answer to your question has been provided.

The button appears next to the replies on topics you’ve started. The member who gave the solution and all future visitors to this topic will appreciate it!

These simple actions take just seconds of your time, but go a long way in showing appreciation for community members and the Live Community as a whole!

The Live Community thanks you for your participation!