Leveraging Intelligent Recommendations for Operational Transformation. AMS Partners click HERE | EMEA/APJ Partners click HERE |
07/09/2024 08:20 AM
Hi Experts,
We had to leave the modern UI and move to the CLASSIC UI experience for a certain app that we are working on due to limitations working with datasets on the modern UI.
However, moving ahead we also see that we are not able to filter out dataset attributes based on the SQL query that we are using in the dynamic attribute values to display them on the ARS form.
The ask is to filter and display a certain set of activities based on the selection of two previous dynamic attributes.
In general, the filter works for plain text or other entitlement values but here in our case we are using datasets. Please let us know if we are missing anything on the SQL query or is this a known issue with datasets.
SQL query being used:
select d.attribute1 as ID from dataset_values d where DATASETNAME='Trainings_XXXX' and d.attribute3 like concat('%','${abc}','%') and d.attribute4 like concat('%','${xyz}','%')
Dataset SS:
Thanks
07/09/2024 08:21 AM
It works please share logs for error
07/09/2024 08:25 AM
07/09/2024 09:58 PM
07/10/2024 01:05 AM
Already disabled.
Thanks
07/10/2024 09:36 AM
Check with NEO if its working then raise support ticket for classic UI