Leveraging Intelligent Recommendations for Operational Transformation. AMS Partners Click HERE | EMEA/APJ Click HERE |
03/12/2024 06:02 AM
Hi,
I need to populate the values based on the selection of the field.
Dynamic Attribute: CONFIRMATION (image1)
When the user selects NO in confirmation then in Role_1_Data_Access all the entitlement lists should be visible except for entitlement value ALL (ent. name).
I am using the below configurations to configure the same but it's not coming up in case of NO in confirmation.
The same query is giving result in Data Analyzer.
Has anyone faced this scenario before ?
Solved! Go to Solution.
03/12/2024 06:15 AM
Add it sub-query in below and try
select distinct ev.entitlment_value as ID from
03/12/2024 06:30 AM
Hey @Raghu
I have tried but its not working.
Thing is when i try the YES condition it works but it in case of NO its coming. Ideally when NO is selected it should show multiple values to select from.
03/12/2024 06:35 AM
Hi @Rajatlm10 , What do you see in logs?
03/12/2024 06:36 AM
Hi @Rajatlm10 do you see any error in the logs?
03/12/2024 06:52 AM
03/12/2024 07:04 AM
Hi @Rajatlm10
As per MySQL standards, a subquery in a MySQL CASE WHEN condition returning multiple rows can causes error. Can you try the below instead?
select ev.entitlement_value as ID from entitlement_values ev inner join entitlement_types et on et.entitlementtypekey=ev.entitlementtypekey inner join endpoints ed on ed.endpointkey=et.endpointkey where ed.endpointkey=906 and ${Confirmation}='NO' and ev.entitlement_value not in ('ALL')
03/12/2024 07:33 AM
Thnx @naveenss for the reply the Query works now.
one thing, The query is selecting all the entitlements values. For now these are dummy entitlement values. So for now we can de-select the ent. which are not required.
But is there any functionality available that allows user to select from the drop down list available. Basically the values selected above . Can't it come as a dropdown list ?
03/12/2024 07:35 AM
Hi @Rajatlm10 change the attribute type from “multi select from sql query” to “single select from sql query”
03/12/2024 07:36 AM
Change to single select for the DA
03/12/2024 07:47 AM
03/12/2024 07:50 AM
Hi @Rajatlm10 , It should come in a drop down so user can select the values. currently does it automatically select all the values?
03/12/2024 07:57 AM
@NM Yes its automatically selecting all the values.