Announcing the SAVIYNT KNOWLEDGE EXCHANGE unifying the Saviynt forums, documentation, training, and more in a single search tool across platforms. Click HERE to read the Announcement.

Don't show id in SQL ENUM dynamic attribute

ASA
Regular Contributor II
Regular Contributor II

Hi,

when we use an SQL ENUM dynamic attribute we need an id column and can additionally use inlinedescription, e.g.:

SELECT userkey AS id, CONCAT(firstname, ' ', lastname) AS inlinedescription FROM ....

 This would result in an entry in the drop down that looks like this:

12345: John Doe

We'd like to only display the inlinedescription part, so:

John Doe

Is this possible?

 

4 REPLIES 4

nimitdave
Saviynt Employee
Saviynt Employee

I assume that you only need John Doe as value in drop down. So you can try as below.

SELECT CONCAT(firstname, ' ', lastname) AS id FROM ..

ASA
Regular Contributor II
Regular Contributor II

But I need a certain id for the mapping to user column like manager or owner.

Darshanjain
Saviynt Employee
Saviynt Employee

Hi @ASA 

Without the id column as user key its not possible to update and there is no way to hide it. But you can use username instead of user key which can be okay for users and use the owner column in the mapping.

Sql:  

SELECT username AS id, CONCAT(firstname, ' ', lastname) AS inlinedescription FROM ....

 

Thanks

Darshan 

ASA
Regular Contributor II
Regular Contributor II

Hi Darshan,

this is a good alternative to use the username. Didn't know about the "owner" column.

Thanks a lot!