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] Filter in source fex of dropdown list

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Filter in source fex of dropdown list
 Login/Join
 
ajayantony
Member
posted 
-*---<car_form.htm>-----

< !-- Generated by Report Layout Painter -->
<HTML>
<HEAD>
<script id=IBI_RelCallBack type=text/javascript>function AdjustChildrenPosition(){
}
</SCRIPT>
 
<script id=IBI_OptionsScript type=text/javascript>
var rltVersion = "764";
var cgipath = "cgipath";
var ibirls = "ibirls2";
 
var rltdyncalendar = "rltdyncalendar";
var gmap = "ibigmap";
var olap="olap";
var olappanebase="olappanebase";
var olapdrill="olapdrill";
 
var ibixmltree="ibixmltree";
 
var ibiOptions = new Array(cgipath,ibirls);
</SCRIPT>
 
<script id=IBI_nls src="/ibi_html/javaassist/nls.js" type=text/javascript></SCRIPT>
 
<script id=IBI_ibigbl src="/ibi_html/javaassist/ibi/html/js/ibigbl.js" type=text/javascript></SCRIPT>
 
<script id=IBI_ibigblloadCss type=text/javascript>
ibigblloadCss(null);</SCRIPT>
<TITLE>HtmlPage</TITLE>
<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
</SCRIPT>
 
<script for=window eventname="onload">window.onload = function() { window_onload(); }</SCRIPT>
</HEAD>
<BODY style="OVERFLOW: auto" edaconnectionrequired="true">
<SELECT id=combobox1 style="Z-INDEX: 1; LEFT: 280px; WIDTH: 390px; POSITION: absolute; TOP: 90px" tabIndex=1 name=combobox1 attvariables="con_list;" cacheruntimedata="1" ibiapp_app="ibi" ibic_server="EDASERVE" sourcetype="typeFex" datatype="1" datasource="car_data.fex"></SELECT> 
<INPUT id=con_list style="LEFT: -100px; WIDTH: 150px; POSITION: absolute; TOP: -100px; HEIGHT: 120px" type=hidden name=con_list cacheruntimedata="1"> 
<INPUT id=layoutinfo style="LEFT: -100px; POSITION: absolute; TOP: -100px" type=hidden inputcontrolids="combobox1;con_list">
<INPUT id=ibiapp_app style="LEFT: -100px; POSITION: absolute; TOP: -100px" type=hidden value=IBI name=ibiapp_app></BODY>
<script id=IBI_loader type=text/javascript>
doBeforeLoad();
</SCRIPT>
</HTML>

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


WebFOCUS 7.6.6
Windows XP
Output: Excel, PDF, HTML
 
Posts: 13 | Registered: March 31, 2008Report This Post
ajayantony
Member
posted Hide Post
-*-------

-* File car_data.fex
-* File bdm_data.fex
-SET &ECHO=ALL;
-DEFAULT &con_list = 'ENGLAND';
TABLE FILE CAR
SUM
COUNTRY
BY COUNTRY
WHERE COUNTRY EQ '&con_list.EVAL'
ON TABLE HOLD
END
-RUN

TABLE FILE HOLD
PRINT
COUNTRY
BY
COUNTRY
ON TABLE PCHOLD
END


WebFOCUS 7.6.6
Windows XP
Output: Excel, PDF, HTML
 
Posts: 13 | Registered: March 31, 2008Report This Post
ajayantony
Member
posted Hide Post
-*----------

-* File main.fex

-SET &con_list = 'FRANCE';

-HTMLFORM car_form


WebFOCUS 7.6.6
Windows XP
Output: Excel, PDF, HTML
 
Posts: 13 | Registered: March 31, 2008Report This Post
ajayantony
Member
posted Hide Post
Hi,
I have an html form (car_form.htm) which has a drop down list. The source to this drop down list car_data.fex file.
If you look at this fex, i have added a where condition to it, the where condition being,

WHERE COUNTRY EQ '&con_list.EVAL'


I am setting &con_list = 'FRANCE' in the fex (main.fex) and calling the html form (car_form.htm), but the drop down list is not getting filtered for the country 'FRANCE'.

Can you please suggest a way to achieve this filter?


The fexes can be found above this post

Thanks,
Ajay


WebFOCUS 7.6.6
Windows XP
Output: Excel, PDF, HTML
 
Posts: 13 | Registered: March 31, 2008Report This Post
Tony A
Expert
posted Hide Post
I could suggest a lot of things, like go on a course, read the manual, search through previous postings and read them, etc. etc. etc. But your main problem is not understanding how all these things hang together. Perhaps that should be your first step, find out how the HTML form control names affect the WebFOCUS variable values and when these values get passed via JavaScript to the AJAX method of obtaining the data and then populating the combobox.

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
GinnyJakes
Expert
posted Hide Post
And the output of the fex needs to be XML.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Darin Lee
Virtuoso
posted Hide Post
A little more along Tony's comments - without a couple of extra steps, you can't pass a parameter to a dynamic procedure which populates a control to set another parameter. The key, as Tony says, is to understand how these components work together, and making the names of your controls match the parameters names used in your fex.

There was another very recent post regarding this same issue, if you do a search or just scroll through the last few days of posts.


Regards,

Darin


In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
ajayantony
Member
posted Hide Post
Thank you all.
I have figured it out.

Thank you very much.


WebFOCUS 7.6.6
Windows XP
Output: Excel, PDF, HTML
 
Posts: 13 | Registered: March 31, 2008Report 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] Filter in source fex of dropdown list

Copyright © 1996-2020 Information Builders