Skip to Content
0

Design Studio passing prompts with # value and special character to Child WebI report

Nov 22, 2016 at 04:01 PM

1.1k

avatar image

Hello Design Studio Gurus ,

We have 3 mandatory prompts that need to be passed to child reports to make them run .

Prompt 1 - everything fine

Prompt 2 - # value included

Prompt 3 - # value and special character .

While Prompt 1 & 2 are working fine , Prompt 3 is giving us nightmares . If # is selected then it's unable pass any value to the child report for that prompt

[screenshot of child report . child report fails to execute and gets stopped here ]

If We deselect # value and select rest of the values manually it stops the moment it encounters special character

Can this be handled using OpenDocument syntax where the LOV has special characters ?

I can see if the report name have a special character you can specifically mention how to interprete it . We can also handle leading and trailing spaces .

But dont think we can handle special characters in LOV in between .

Please help me out what should be the best approach here .

This is how we have defined the Open Document behaviour in the text fields OnClick behaviour -

var Sales_Org = TREND_ANALYSIS.getVariableValueExt("CICFCCSOAUTH");
var Div = TREND_ANALYSIS.getVariableValueExt("OCSDCMDIVI");
var Distr_channel=TREND_ANALYSIS.getVariableValueExt("OCSDCMDISCHA");


APPLICATION.openNewWindow("http://<BOSERVER>:8080/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=AWspn6A1SjtNnY5WseCAzK8&sType=wid&sRefresh=N"+"&lsMOCCFCMSOORG=" + Sales_Org +"&lsMOCSDCMDISCHA=" +Distr_channel +"&lsMOCSDCMDIVI=" +Div);

5opy0.png (69.6 kB)
ugf6g.png (107.2 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Andrey Surinov
Nov 23, 2016 at 04:54 AM
1

# is a special character in URL syntax so you have to convert it to %23 using Convert.urlEncode method

Show 6 Share
10 |10000 characters needed characters left characters exceeded

Hello Andrey ,

Thank you for responding . Can you please elaborate more on this ? I guess it has to be in the same OnClick event where I am defining the Open Document syntax .

More over the problem is apart from # we have & and / in the LOV in Development system it self . Chances are number of special characters might increase with real data .

Also I have heard the %23 approach does not work properly in all browsers . Can you please confirm on this?

Thank you !

0

Yes, you should modify your code to wrap the parameter values into Convert.urlEncode calls, this should cover all the special characters

APPLICATION.openNewWindow("http://<BOSERVER>:8080/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=AWspn6A1SjtNnY5WseCAzK8&sType=wid&sRefresh=N"+"&lsMOCCFCMSOORG=" + Convert.urlEncode(Sales_Org) +"&lsMOCSDCMDISCHA=" +Convert.urlEncode(Distr_channel) +"&lsMOCSDCMDIVI=" +Convert.urlEncode(Div));
0

This works like a charm !! Thank you very much !!

Is there anyway we can pull BO Server information dynamically in the OpenDocument URL ?

0

The reason I am asking is because I tried approaching dynamic URL like this -

APPLICATION.openNewWindow("/BOE/opendoc/openDocument.jsp?sIDType=CUID&iDocID=AWspn6A1SjtNnY5WseCAzK8&sType=wid&sRefresh=N"+"&lsMOCCFCMSOORG=" +Convert.urlEncode(Sales_Org) +"&lsMOCSDCMDISCHA=" +Convert.urlEncode(Distr_channel) +"&lsMOCSDCMDIVI=" +Convert.urlEncode(Div));

But it's not working for me .
0
0

I think you have a misprint. You should use

/BOE/OpenDocument/opendoc/openDocument.jsp?

0
Tammy Powlas
Nov 22, 2016 at 05:28 PM
0

Hi - your screen shots do not look like Design Studio; they look like Web Intelligence. Did you select the right tag?

Share
10 |10000 characters needed characters left characters exceeded
sourav roy Nov 22, 2016 at 07:21 PM
0

Yes Tammy . The tag is correct . I have shown here how the prompts are eventually passing down to WebIntelligence from Design Studio . If you notice I have mentioned the prompt formula I have used in Design Studio as well .

Share
10 |10000 characters needed characters left characters exceeded