and more in a single search tool across platforms. Read the announcement here. |
03/27/2024 10:03 AM
Hi Team,
I am trying to add a list of values as ENUM to a dynamic attribute for an endpoint in order to display them as a part of dropdown field on the ARS form. However, I am getting an error stating that - Operation not allowed as you are entering a value that resembles or contains a script code.
Please find the list below:
Chinese (Simplified)|zh_CN,Chinese (Traditional)|zh_TW,Danish|da,Dutch|nl_NL,English|en_US,English (UK)|en_GB,Finnish|fi,French|fr,German|de,Hebrew|iw,Hungarian|hu,Italian|it,Japanese|ja,Norwegian|no,Polish|pl,Portuguese (Brazil)|pt_BR,Portuguese (European)|pt_PT,Russian|ru,Spanish|es,Spanish (Mexico)|es_MX,Spanish (Peru)|es_PE,Swedish|sv
Can anyone please suggest what am I doing wrong, or another way in order to achieve this requirement.
Thanks
Solved! Go to Solution.
03/27/2024 10:47 AM - edited 03/27/2024 10:49 AM
@Aashish-Handa - we can save character till 256 char , if pass more then it through error like above
please reduce the text and try.
you string will support till below end
Chinese (Simplified)|zh_CN,Chinese (Traditional)|zh_TW,Danish|da,Dutch|nl_NL,English|en_US,English (UK)|en_GB,Finnish|fi,French|fr,German|de,Hebrew|iw,Hungarian|hu,Italian|it,Japanese|ja,Norwegian|no,Polish|pl,Portuguese (Brazil)|pt_BR,
Portuguese (Europe - 256
an)|pt_PT,Russian|ru,Spanish|es,Spanish (Mexico)|es_MX,Spanish (Peru)|es_PE,Swedish|sv
03/27/2024 11:52 PM
Thanks for the response. I did try this earlier and was able to. Is there any other way I can store this list in a dynamic attribute and list them as a drop down?
03/28/2024 12:16 AM
try like single select query like below screenshot
value:
SELECT 'Chinese (Simplified)' AS id
UNION
SELECT 'Chinese (Traditional)|zh_TW' AS id
UNION
SELECT 'Danish|da' AS id
UNION
SELECT 'Dutch|nl_NL' AS id
UNION
SELECT 'English|en_US' AS id
UNION
SELECT 'English (UK)|en_GB' AS id
UNION
SELECT 'Finnish|fi' AS id
UNION
SELECT 'French|fr' AS id
UNION
SELECT 'German|de' AS id
UNION
SELECT 'Hebrew|iw' AS id
UNION
SELECT 'Hungarian|hu' AS id
UNION
SELECT 'Italian|it' AS id
UNION
SELECT 'Japanese|ja' AS id
UNION
SELECT 'Norwegian|no' AS id
UNION
SELECT 'Polish|pl' AS id
UNION
SELECT 'Portuguese (Brazil)|pt_BR' AS id
UNION
SELECT 'Portuguese (European)|pt_PT' AS id
UNION
SELECT 'Russian|ru' AS id
UNION
SELECT 'Spanish|es' AS id
UNION
SELECT 'Spanish (Mexico)|es_MX' AS id
UNION
SELECT 'Spanish (Peru)|es_PE' AS id
UNION
SELECT 'Swedish|sv';
03/27/2024 12:17 PM
Only 255 characters are supported. use Single select query with UNION logic
SELECT 'Chinese (Simplified)' AS id
UNION
SELECT 'Chinese (Traditional)|zh_TW' AS id
UNION
SELECT 'Danish|da' AS id
UNION
SELECT 'Dutch|nl_NL' AS id
UNION
SELECT 'English|en_US' AS id
UNION
SELECT 'English (UK)|en_GB' AS id
UNION
SELECT 'Finnish|fi' AS id
UNION
SELECT 'French|fr' AS id
UNION
SELECT 'German|de' AS id
UNION
SELECT 'Hebrew|iw' AS id
UNION
SELECT 'Hungarian|hu' AS id
UNION
SELECT 'Italian|it' AS id
UNION
SELECT 'Japanese|ja' AS id
UNION
SELECT 'Norwegian|no' AS id
UNION
SELECT 'Polish|pl' AS id
UNION
SELECT 'Portuguese (Brazil)|pt_BR' AS id
UNION
SELECT 'Portuguese (European)|pt_PT' AS id
UNION
SELECT 'Russian|ru' AS id
UNION
SELECT 'Spanish|es' AS id
UNION
SELECT 'Spanish (Mexico)|es_MX' AS id
UNION
SELECT 'Spanish (Peru)|es_PE' AS id
UNION
SELECT 'Swedish|sv';
03/28/2024 12:18 AM
This worked.
Thanks a lot @rushikeshvartak @CR