User form not showing values until searched

[Abhay_Yadav]

Hi All,

We have a requirement to populate data in cascading manner in 3 fields.

1. Department: ENUM

2. Function: SQL ENUM

3. Team: SQL ENUM

So based on department hardcoded function list should get populated and based on function hardcoded team should get populated.

I have used below logic in Function and Team SQL query:

SELECT
CASE WHEN ${supplierFunction} = 'XYZ' THEN 'XYZ' END AS ID
UNION ALL
SELECT
CASE WHEN ${supplierFunction} = 'XYZ' THEN 'ABC' END
UNION ALL
SELECT
CASE WHEN ${supplierFunction} = 'XYZ' THEN 'DEF' END
END

It is working fine data wise and refresh wise, only issue is data does not get listed in the dropdown we have to search for value and then it get's displayed in Function and Team dropdown. Is this the expected behaviour or is there something wrong with our configuration.

Regards,

Abhay Yadav

[rushikeshvartak]

change dept enum to SQL enum if does not work share screenshot of config and ars

[Abhay_Yadav]

Hi @rushikeshvartak ,

I have changed the department to SQL ENUM, Department is getting populated properly.

But Function and Team behaviour is same as before it is not showing value with out searching.

Regards,

Abhay Yadav

[rushikeshvartak]

 share screenshot of config and ars

[Abhay_Yadav]

Hi @rushikeshvartak,

Config:

ARS:

Regards,

Abhay Yadav

[rushikeshvartak]

Click on both attribute and share configs

[Abhay_Yadav]

Hi @rushikeshvartak ,

user department config:

Function Config:

Regards,

Abhay Yadav

[rushikeshvartak]

use Refresh instead of Mapping

[Abhay_Yadav]

Hi @rushikeshvartak,

Updated it to Refresh but the behaviour is still same.

Regrards,

Abhay Yadav

[rushikeshvartak]

Please share logs in text file