Special characters while checking in where condition

[Suresh1]

Hello Team,

I'm trying to get user's location from Data Analyser for a set of users by checking specific location name.

It shows fine in the user profile from UI but when i try from analyser it shows some encoded value 

For Example. In Saviynt UI my location shows as ASIA > IND > India > Bangalore

But when i run select username,location from users where username='Myname' I get location in below format

ASIA > IND > India > Bangalore

Can anyone help me why this is happening in the Analyser and not in the UI. Please also let me know how to decode this back to original value

[rushikeshvartak]

This is working in EIC v24.x 

SELECT
username,
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(location, '>', '>'),
'&lt;', '<'),
'&amp;', '&'),
'&quot;', '"'),
'&#39;', '''') AS decoded_location
FROM users
WHERE username = 'Myname';