Leveraging Intelligent Recommendations for Operational Transformation. AMS Partners Click HERE | EMEA/APJ Click HERE |
11/16/2023 12:01 PM - edited 11/16/2023 12:13 PM
Hi Team,
I am looking to use substring_index function in technical rule to achieve a requirement. But getting invalid condition error. Idea is to use the value from the substring_index to lookup on a defined dataset.
Is substring_index allowed in technical rule, please share your views.
11/16/2023 09:52 PM
Hi @Amar_Simha
Could you please share the query which you are using in Technical rule advance query.
Technical and User Update rules use the HQL query in Advanced Config. Therefore, you must enter the query in Advanced Config in the HQL format and use the HQL class name instead of the table name.
Also you can use the supported attributes only. Please refer below for the list of supported attributes.
Creating Technical Rules (saviyntcloud.com)
Please check the logs to confirm if the substring_index is supported.
Regards,
Dhruv Sharma
11/16/2023 11:35 PM
@Amar_Simha we have implemented this with below use case :
We have some users with '001#015#1' as cp12.
We're making a technical which states:
If the users have '001#015#1' as customproperty12, we want to create an account and add access on an endpoint to the entitlement with '015' as value in customproperty1.
When we setup the technical rule, we use the SAVCustomQuery in the action object:
SAVCUSTOMQUERY::ev.customproperty1= substring_index(substring_index('${user.customproperty12}','#',2),'#',-1)
11/22/2023 11:19 AM
any idea if SAVCUSTOMQUERY works for enterprise roles as well? or is it limited to entitlement_values only?
11/22/2023 07:09 PM
As long as object exposed you should be able to use.
11/23/2023 03:16 AM - edited 11/23/2023 03:38 AM
Ok,thanks. None of the documentation talks about roles in SAVCUSTOMQUERY. So just wanted to see if anyone has done this successfully for roles as well. As I understand entitlements and roles both objects are exposed in rules.
11/26/2023 11:49 PM
Hi @shibinvpkvr
Can you try with SAVCUSTOMQUERY::ev.entitlement_value like 'RoleName% and see if it works.
Regards,
Dhruv Sharma