Apostrophe in user name breaks query builder

cancel
Showing results for 
Search instead for 
Did you mean: 

Apostrophe in user name breaks query builder

L3 Networker

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.

1 REPLY 1

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 LIVEcommunity as a whole!

The LIVEcommunity thanks you for your participation!