and more in a single search tool across platforms. Read the announcement here. |
02/20/2024 04:57 AM - edited 02/20/2024 05:01 AM
Hello,
When I create a "SQL ENUM" dynamic attribute with following definition with REST API:
02/20/2024 05:06 AM
@alc can you send me full query please "attributevalue"
02/20/2024 05:20 AM
Hello CR, Thanks for your review.
Here is the SQL statement I use (note the comma at the end as this attribute is not last one in JSON):
"attributevalue": "SELECT ev.entitlement_value AS ID FROM entitlement_values ev JOIN entitlement_types et ON ev.entitlementtypekey = et.entitlementtypekey JOIN endpoints ep ON et.endpointkey = ep.endpointkey WHERE et.entitlementname = 'MyEntitlementType' AND ep.endpointname = 'MyEndpointName' ORDER BY ev.entitlement_value;",
I have verified the SQL statement in Data Analyzer before I use it.
Thanks
02/20/2024 05:44 AM - edited 02/20/2024 05:45 AM
@alc can you try like pass lower case please
select ev.entitlement_value as ID from entitlement_values ev join entitlement_types et on ev.entitlementtypekey = et.entitlementtypekey join endpoints ep on et.endpointkey = ep.endpointkey where et.entitlementname = 'myentitlementtype' and ep.endpointname = 'myendpointname' order by ev.entitlement_value;",
02/20/2024 05:53 AM
No luck with lower case either. do you have an env to try out please?
02/20/2024 05:28 AM
Use SQLENUM
02/20/2024 05:37 AM - edited 02/20/2024 05:54 AM
Hello Rushikesh,
I tried with SQLENUM, it does not work, it returns same error message. Can you try from your end?
By the way, I use V24.2, probably version issue? I remember it works before.
Thanks
02/20/2024 06:10 AM
Its defect with v24.2 Please raise support ticket