[SOLVED] Filter in source fex of dropdown list

May 26, 2009, 11:41 PM

-*---<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,

May 26, 2009, 11:43 PM

ajayantony

-*-------

-* 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

May 26, 2009, 11:44 PM

ajayantony

-*----------

-* File main.fex

-SET &con_list = 'FRANCE';

-HTMLFORM car_form

May 26, 2009, 11:45 PM

ajayantony

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

May 27, 2009, 02:08 AM

Tony A

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

May 27, 2009, 09:02 AM

GinnyJakes

And the output of the fex needs to be XML.

May 28, 2009, 11:40 AM

Darin Lee

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.

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