Click HERE to see how Saviynt Intelligence is transforming the industry. |
10/09/2024 08:54 AM - edited 10/09/2024 08:55 AM
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
10/09/2024 09:00 AM
change dept enum to SQL enum if does not work share screenshot of config and ars
10/09/2024 09:13 AM
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
10/09/2024 10:48 AM
share screenshot of config and ars
10/09/2024 10:57 PM
10/09/2024 11:00 PM
Click on both attribute and share configs
10/10/2024 03:10 AM
10/10/2024 05:29 AM
use Refresh instead of Mapping
10/14/2024 02:30 AM
10/14/2024 10:51 AM
Please share logs in text file