Skip to Content
0

Passing special characters in SAP Design Studio Query

Dec 26, 2017 at 03:43 PM

111

avatar image
Former Member

We have a query on SAP Design Studio with a prompt on a dimension. This dimension contains values with '(' and ')'. We are displaying this on a list box and then trying to pass the selected value to the prompt in the query. The query refresh fails with an error "Invalid Format". Any solution to this would be highly appreciated. Thanks!!

10 |10000 characters needed characters left characters exceeded

Hi,

How are you displaying your list box values?.

Thru a code?.

Thanks,

Jothi

0
Former Member

Hi Jothi,

List box values are populated through code - LISTBOX_1.setItems. The values contain '('.

0
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Tammy Powlas
Dec 26, 2017 at 03:48 PM
0

Hi - I recommend searching for this; I searched and found these threads: https://archive.sap.com/discussions/thread/3703975

https://archive.sap.com/discussions/thread/3686092

If this doesn't help, please share some screen shots, along with version and SP of Design Studio you are using

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Dec 26, 2017 at 04:17 PM
0

Hi Tammy,

Thanks for the links and appreciate your quick response. Even in the threads I couldn't find the right answer. I have the same issue when trying to replace special characters with a '\'. Design studio throws an error "Invalid Escape Sequence". Screenshots attached.special-characters-error-2.jpg special-characters-error.jpg

Code:

X_Filter_BUG = Convert.replaceAll(X_Filter_BUG, "(", "\(");

We are using SAP Lumira Designer 2.0 SP2 Patch 1.


Share
10 |10000 characters needed characters left characters exceeded