Hi, We need to hide/remove the parameter values showing in URL when we click drilldown link from report page. Is there any options available to mask parameters in FOCEXEC ?This message has been edited. Last edited by: Kerry,
WF7.6.9, Windows HTML / PDF / Excel
July 19, 2011, 10:47 AM
Severus.snape
Hi,
I dont think you can hide the params when you use WF FOCEXEC in the style sheet to drill down..
You can call a Javascript in the style sheet passing the params to that function and use a form in the HTML to call the drill down report using POST method..
here is the code:
TABLE FILE CAR
PRINT
RETAIL_COST
BY COUNTRY
ON TABLE SET STYLE *
TYPE=DATA,
COLUMN=COUNTRY,
JAVASCRIPT=drillToThis(N1 N2),
$
END
-HTMLFORM BEGIN
<HTML>
<SCRIPT>
function drillToThis(fld1,fld2)
{
document.form1.PARAM1.value = fld1;
document.form1.PARAM2.value = fld2;
document.form1.submit();
}
</script>
<body>
<form method=post name=form1 id=form1>
<input type=hidden name=IBIAPP_app id=IBIAPP_app value = baseapp>
-*<input type=hidden name=IBIC_server id=IBIC_server value ="EDASERVE">
-*<input type=hidden name=IBIWF_msgviewer id=IBIWF_msgviewer value ="OFF">
-*<input type=hidden name=IBIMR_drill id=IBIMR_drill value ="X,producti/producti.htm">
<INPUT TYPE="hidden" id=IBIF_ex NAME="IBIF_ex" VALUE="drilldownfex.fex">
<input type=hidden id=PARAM1 name=PARAM1 value="">
<input type=hidden id=PARAM2 name=PARAM2 value="">
</form>
</body>
</html>
-HTMLFORM END
-EXIT
WF 7.7.03/Windows/HTML,PDF,EXL POC/local Dev Studio 7.7.03 & 7.6.11
I would open a case with Tech Support - I can't believe this isn't a SETable option.
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
July 19, 2011, 10:53 AM
Dave
Simple: no.
When you use a 'click drilldown' the parameters are passed to the next call on the URL.
Only way I can think of is to create some code yourself in html to emulate the hyperlink with a form with hidden inputs and using method=post. ( Like Francis saids a few minutes before me, making me edit this post )
Hiding or masking the parameters sounds like your solution to a problem. But what is the problem? There might be other solutions.
_____________________ WF: 8.0.0.9 > going 8.2.0.5
July 21, 2011, 05:13 AM
Karthikeyan
Hi Severus - Sample code was realy useful and helped for the solution. Thank you.
Hi Francis - Thanks for the action and let me know if you have any updates.
Hi Dave - The user dont want the parameter values visible in URL when drill down the report. It may cause any security attacks like SQL injection. So we are trying to remove the parameter values from Drill done URL
)