We are delighted to share our new EIC Delivery Methodology for efficiently managing Saviynt Implementations and delivering quick time to value. CLICK HERE.

Select Option of Register User Form do not Work Well

KK
Regular Contributor
Regular Contributor
Hi Team.
 
I created Single Select Attributes in Register User Form.
In one attribute, I can see selectable option without entering search character.
But in another attribute, I can't see selectable option until entering search character.
I want to see selectable option without entering search character.
I attached screenshot.
 
Best Regards,
6 REPLIES 6

Dhruv_S
Saviynt Employee
Saviynt Employee

Hi @KK 

Thanks for reaching out to Forums for the above query. 

Could you please provide complete config screenshot of both the dynamic attributes from the Register user form. Once you provide the information, we will check and let you know further.

Regards,

Dhruv Sharma

KK
Regular Contributor
Regular Contributor

@Dhruv_S 
Thanks.
I attached the complete config screenshot.
Please check that.

Best Regards,

Dhruv_S
Saviynt Employee
Saviynt Employee

Hi @KK 

I tried to replicate the issue and it was replicated with the queries you have provided. 

Original queries

Manager (select username from users) -> Shows the list without any input

Receptionist (select email from users)-> Doesnot shows the list without typing

As per my understanding this was due to username being a unique field and email not being the same.

So I modified the Receptionist query as below.

Modified Queries

Manager (select username from users) -> Shows the list without any input.

Receptionist (select distinct email from users)-> Shows the list without any input.

And both worked as expected. Please find the screenshot below.

Dhruv_Sharma_0-1705054719598.png

Please use the distinct keyword in the Receptionist attribute and it should work fine.

Regards,
Dhruv Sharma
If the response is helpful, please click Accept as Solution and kudos it.

 

 

KK
Regular Contributor
Regular Contributor

@Dhruv_S 
Thank you.
I modified SQL query as below, but issue still occur.

Original
select email as ID, concat(firstname, ' ', lastname) as inlinedescription from users

Modified
select distinct email as ID, concat(firstname, ' ', lastname) as inlinedescription from users

KK_0-1705055551767.png

Am I incorrect?

Best Regards,

Dhruv_S
Saviynt Employee
Saviynt Employee

It is happening because attribute concat(firstname, ' ', lastname) which will be giving non unique results.

If you remove this from the query it will give you the results. Please confirm if you are getting the results from the query I have mentioned above.

KK
Regular Contributor
Regular Contributor

@Dhruv_S 
Thanks.
It was success by bellow query.
select distinct email as ID from users