Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS Designer Forum on Focal Point     [CLOSED] Get Parameter Value in Page Designer
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Get Parameter Value in Page Designer
 Login/Join
 
Gold member
posted
Hi All,

Am using page designer webfocus 8206, i developed charts using info assist

My requirement is: Need to add "Export to Excel" option in the Menu and when the user click the "Export to Excel", the chart data should get download in excel in a tabular form

I able to add "Export to Excel" in menu and when user click am using window.open to execute the procedure to download the data into excel. Please find the below code
/********Assign Static Values***********************************
var CLIENTID1 = '000050';
var CURRCLIENT = 'USD';
var SUBCLIENTID = '_FOC_NULL';
var CLIENTDATE_YEAR_D_FROM = '20180101';
var CLIENTDATE_YEAR_D_TO = '20190916';
var WFHTML = 'XLSX';
/*******************************************************************
var myurl = '/ibi_apps/run.bip?BIP_REQUEST_TYPE=BIP_LAUNCH&BIP_folder=IBFS%253A%252FWFC%252FRepository%252FReDi_RedShield%252FFraud%252FFraudSubTab%252FExport_Procedures%252F&BIP_item=Fraud_Items_by_Recommendation_Value_Export.fex&CLIENTID='+CLIENTID1+'&SUBCLIENTID='+SUBCLIENTID+'&WFHTML='+WFHTML+'&CLIENTDATE_YEAR_D_FROM='+CLIENTDATE_YEAR_D_FROM+'&CLIENTDATE_YEAR_D_TO='+CLIENTDATE_YEAR_D_TO+'&CURRCLIENT='+CURRCLIENT;
window.open(myurl,"_blank");
  


the above code is working fine with static values and able to generate the excel output

Problem: how to get the selected parameter values dynamically in page designer?

I tried by giving like below
var proc_name = '!IBI.AMP.CLIENTID;';
alert(proc_name);

but getting error. Can anyone please help how to get the parameter value dynamically in page designer to pass in window.open

Thanks,
Madhu

This message has been edited. Last edited by: FP Mod Chuck,
 
Posts: 53 | Registered: September 30, 2008Reply With QuoteReport This Post
Member
posted Hide Post
Hi,

-SET &A='ABCD';

-*you can set the &A value from page designer filter, as per your requirement.

////////////////////////////
//YOUR TABLE FILE REQUEST///
///////////////////////////

-HTMLFORM BEGIN

<script>

//using below code you can use WebFOCUS variables in javascript.

var val="!IBI.AMP.A;"
alert(val);


-HTMLFORM END

This worked for me.


Webfocus 8.x
Windows
PDF,HTML,XLSX
 
Posts: 25 | Location: India | Registered: June 01, 2018Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS Designer Forum on Focal Point     [CLOSED] Get Parameter Value in Page Designer

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.