Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

Special characters while checking in where condition

Suresh1
New Contributor III
New Contributor III

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

 

 

1 REPLY 1

rushikeshvartak
All-Star
All-Star

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';


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.