EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB486778: When the default prompt answer is set as "#;#", MicroStrategy Web and Library automatically add a backslash before the semicolon and the value is displayed as “#\;#”


Yanqing Liu

Cloud Support Expert I • MicroStrategy


The KB article explains the behavior change introduced in MicroStrategy 2019 Update 3. From version 2019 Update 3, if "a;b" is entered as the prompt answer in MicroStrategy Developer, it will be considered as one element by default. To escape this special character, a backslash is added before the semicolon (for example: a\;b) in the prompt page for MicroStrategy Web and Library. "\" can be deleted from the prompt answer manually if the value needs to be treated as multiple elements.

SYMPTOM


In Strategy Developer, create an attribute qualification prompt, and set the display style to “Text Box” and Operator to “In list” or “Not in list”. The default prompt answer is set to for example “a;b”:

ka0PW0000002Ey9YAE_0EMPW000006kaJZ.png

In previous versions of Strategy, such as version 10.4, when the prompt is executed in Strategy Web, “a;b” is treated as 2 elements.
After upgrading to Strategy One, March 2024, when the same prompt is executed in Strategy Web or Library, a backslash is added before the semicolon:

ka0PW0000002Ey9YAE_0EMPW000006kaJa.png

CAUSE:


Strategy introduced a behavior change in Strategy 2019 Update 3.
To support multiple elements in a prompt, a semicolon is used as a delimiter when the prompt’s display style is set to “Text Box” and Operator is set to “In list” or “Not in list”. For example, if “a;b” is entered as the prompt answer, it will be treated as 2 elements: “a” and “b”.
Before Strategy 2019 Update 3, there was a limitation where if a value contained a semicolon, it was always treated as a delimiter and could not be part of the value.
To address this limitation, Strategy made a change in Strategy 2019 Update 3. Now, if "a;b" is entered as the prompt answer in Strategy Developer, it will be considered as one element by default. To escape this special character, a backslash is added before the semicolon (for example: a\;b) in the prompt page for Strategy Web and Library.

ka0PW0000002Ey9YAE_0EMPW000006kaJb.png

Check the prompt details and the prompt answer is “a;b”.

ACTION:


Users upgrading from versions before 2019 Update 3 must manually make the change in order to maintain the same behavior as in previous versions. Currently, there is no option to make bulk changes:
Run the prompt in Strategy Web or Library. Manually modify the value and delete “\” in the prompt page:

ka0PW0000002Ey9YAE_0EMPW000006kaJd.png

Check the prompt details. The prompt answer is changed to “a” and “b”:

ka0PW0000002Ey9YAE_0EMPW000006kaJe.png

 


Comment

0 comments

Details

Knowledge Article

Published:

May 28, 2024

Last Updated:

May 28, 2024