Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] reading IBIMR_domain in html form

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] reading IBIMR_domain in html form
 Login/Join
 
Gold member
posted
Hi,
How to read &IBIMR_domain in html launch page and pass the value back to Fex?
Our Fex resides in domain: generic_domain
but the launch page could be in different domains. So depending on the launch page where the user is running from, we need to capture the domain_name/folder of that launch page and pass it to the Fex where clause and show the related domain data.

Thanks,
DD

This message has been edited. Last edited by: Kerry,


WebFocus 7.7.01
Desktop: Windows and Server: Unix
Excel, HTML, PDF
 
Posts: 69 | Registered: September 12, 2009Report This Post
Platinum Member
posted Hide Post
Have you search forum for "MR DOMAIN". Earlier post mention "MR_GET_USER_DOMAINS" to have XML. Is this possible for you?

Kofi


Client Server 8.1.05: Apache; Tomcat;Windows Server 2012
Reporting Server 8.1.05; Oracle; MS SQL; Windows Server 2012
 
Posts: 106 | Registered: April 06, 2009Report This Post
<JJI>
posted
quote:
&IBIMR_domain

This is actualy very easy. Just put the following code in your site.wfs:
  <sendvar>
DOMAIN    = &IBIMR_domain
<endsendvar>  


You can do this from the administration console--> configuration --> Custom Settings

When you run a fex the site.wfs will now capture the domain name before the fex is actualy executed and you can pass the value of &DOMAIN (or whatever variable name you have chosen to contain the &IBIMR_domain value) to your fex.

Hope this helps;

Kind regards,

This message has been edited. Last edited by: <JJI>,
 
Report This Post
Gold member
posted Hide Post
Thanks for the quick reply. Iam able to read IBIMR_domain in the Fex. But as I said earlier, I need to read this in Html launch form and pass it back to Fex. Because the Fex resides in one generic domain and it will have more than one launch form residing in different domains.


WebFocus 7.7.01
Desktop: Windows and Server: Unix
Excel, HTML, PDF
 
Posts: 69 | Registered: September 12, 2009Report This Post
Expert
posted Hide Post
You want to obtain the value of &MR_Domain within your launch page? - Use AJAX method to retrieve it.

Passing it onto the fex that is called upon form usbmission is just a case of creating an input control and assigning the value retrieved.

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
Expert
posted Hide Post
DD,

We do this:

Within the HTML Launch page:
  
<SCRIPT id=clientEventHandlersJS type=text/javascript>
//Begin function window_onload
function window_onload() {
UpdateData();
// TODO: Add your event handler code here
//add onInitialUpdate() function to make changes before initial run of the reports
}
//End function window_onload
document.formname.DOMAIN.value = '!IBI.AMP.IBIMR_domain;';
 </SCRIPT>


Within the BODY tag:
 
<INPUT value=!IBI.AMP.DOMAIN; type=hidden name=DOMAIN operation="NONE">


Passing to another fex:
  
<variables>

<variable field="DOMAIN" file="ANY_MASTER.mas" desc="DOMAIN" datatype="0" operation="" default="" name="DOMAIN" textvarname="" accept="0" type="unresolved" select="0" min="" max="" controltype="7" create="1"></variable></variables></request>

hth


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report This Post
Expert
posted Hide Post
quote:
'!IBI.AMP.IBIMR_domain;'

Only if your launch page is held within -HTMLFORM BEGIN and -HTMLFORM END.

If this is the case then Tom's suggestion is the better way to go, but if pure HTML then use AJAX.

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
Gold member
posted Hide Post
Thanks Alot Tom. How to assign it to a parameter defined in the Fex?
Here is my sample Fex which resides in
Domain: main_domain
TABLE FILE DEPT_DOMAIN
PRINT
'DEPT_DOMAIN.DEPT_DOMAIN.DEPT_NO'
'DEPT_DOMAIN.DEPT_DOMAIN.DOMAIN_NAME'
WHERE DEPT_DOMAIN.DEPT_DOMAIN.DOMAIN_NAME EQ '&P_DOMAIN_NAME.(FIND DOMAIN_NAME,DEPT_DOMAIN.DEPT_DOMAIN.DOMAIN_NAME IN dept_domain).DOMAIN_NAME.';
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='TIMES NEW ROMAN',
SIZE=10,
$
ENDSTYLE
END

I have created Html launch form which resides in another Domain: dept10_domain and calls the above Fex. When the user press the run button, it needs to pass dept10_domain name to Parameter: &P_DOMAIN_NAME and the output should show related department data.

Thanks,
DD


WebFocus 7.7.01
Desktop: Windows and Server: Unix
Excel, HTML, PDF
 
Posts: 69 | Registered: September 12, 2009Report This Post
Expert
posted Hide Post
1. Do what JJI gave to you via the Administrator Console; this is a must
2. In dept10_domain, create a fex with this 1 line of code:
 
-MRNOEDIT -INCLUDE your_html_pgm.htm

3. Add the code I gave into the above HTM pgm, changing DOMAIN to P_DOMAIN_NAME
4. Modify your fex to do this:
  
TABLE FILE &P_DOMAIN_NAME.EVAL
PRINT
  DEPT_NO
  DOMAIN_NAME
WHERE DOMAIN_NAME EQ '&P_DOMAIN_NAME';
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='TIMES NEW ROMAN',
SIZE=10,
$
ENDSTYLE
END


Just winging it here, hth...

Tom


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report This Post
Gold member
posted Hide Post
Thanks Alot Tom!!!
Somehow it does not work.
The luanch page is spinning forever with out showing the parameter.

Why should I create another Fex dept10_domain with -MRNOEDIT -INCLUDE your_html_pgm.htm ??

Thanks again.


WebFocus 7.7.01
Desktop: Windows and Server: Unix
Excel, HTML, PDF
 
Posts: 69 | Registered: September 12, 2009Report This Post
Expert
posted Hide Post
DD,

For the site.wfs to kickoff, you need to execute a fex from MRE.
Open up any fex, in any Domain, and, at the top of the fex, add these lines:

 
-? &
-EXIT

All your amper variables available will be listed; see if &IBIMR_domain is listed AND has a value...
Do not save, and get out of the program.

Verify the variable is populated and get back...


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report This Post
Gold member
posted Hide Post
Thanks Alot Tom!!!

It worked great.

Once again I appreciate all of your time and help.


WebFocus 7.7.01
Desktop: Windows and Server: Unix
Excel, HTML, PDF
 
Posts: 69 | Registered: September 12, 2009Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] reading IBIMR_domain in html form

Copyright © 1996-2020 Information Builders