[CASE-OPENED] Chaining - is this a bug or am I doing something wrong?

March 26, 2009, 04:35 PM

I've tried with customer support but I am getting no where so I am curious if anyone out there knows if the following is a bug or if I'm doing something wrong.

As I said previously, we are trying to use the same field - and it doesn't matter if you try to load it from our own fex (which you say is not formed correctly) or directly out of the database - it still doesn't work.

Let's say I want my users to be able to run a report for cars whose sales were greater than a certain amount but less than a different amount.

I would put two listboxes on the form. One for the starting point and one for the ending point. I'd tell the listboxes to dynamically populate themselves from the CAR file off the SALES field. Then I'd chain them and apply the chaining logic. In all cases, other than greater than or greather than equal to, it works. When we try greater than or greater than equal to, there is a javascript error.

Is this a bug or am I doing something wrong?

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

March 27, 2009, 07:55 AM

gregv

ChannyS:

What are you using for 'Greater Than' and 'Greater Than Equal To' for your dropdown value?

Could you submit some sample html/js code that does not work?

March 27, 2009, 09:34 AM

ChannyS

I am using the HTML Resource Layout tool to create the HTML file (see below). The operator is either ">" or ">=". The other operators work correctly.

  
<!-- 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: 240px; WIDTH: 180px; POSITION: absolute; TOP: 60px" tabIndex=1 name=combobox1 newchainnumber="0" datasource="car.mas" datatype="1" sourcetype="typeMaster" ibic_server ibiapp_app="dev ibisamp baseapp" chainnumber="0" inchainindex="1" cacheruntimedata="1" expression=">=" displayfield="SALES" datafield="SALES" ibiformat="I6" dfformat="I6"></SELECT>
<SELECT id=combobox2 style="Z-INDEX: 2; LEFT: 240px; WIDTH: 190px; POSITION: absolute; TOP: 110px" tabIndex=2 name=combobox2 newchainnumber="0" datasource="car.mas" datatype="1" sourcetype="typeMaster" ibic_server ibiapp_app="dev ibisamp baseapp" chainnumber="0" inchainindex="2" cacheruntimedata="1" expression=">=" displayfield="SALES" datafield="SALES" ibiformat="I6" dfformat="I6"></SELECT>
<INPUT id=layoutinfo style="LEFT: -100px; POSITION: absolute; TOP: -100px" type=hidden inputcontrolids="combobox1;combobox2">
<INPUT id=ibiapp_app style="LEFT: -100px; POSITION: absolute; TOP: -100px" type=hidden value="dev ibisamp baseapp" name=ibiapp_app>
<SCRIPT id=IBI_ChainScript type=text/javascript>
<!--
window.chain0=new Array(1);
window.chain0[0]=new String("combobox1;combobox2");
window.chain0[1]=1
//--></SCRIPT>
</BODY>
<SCRIPT id=IBI_loader type=text/javascript>
doBeforeLoad();
</SCRIPT>
</HTML>

March 27, 2009, 09:50 AM

gregv

ChannyS:

This code works for me in 7.6.6 with both '>=' and '>'.

I don't have 7.6.8 to test it there.

March 27, 2009, 10:01 AM

ChannyS

Thanks - I guess it's a 7.6.8 bug then.

March 27, 2009, 10:18 AM

Tom Flynn

No bug, it works on 7.6.8 as well.

Click on the 1st box, hold the Ctrl key down, click on the second box, click on the chain +, on the toolbar, that is highlighted in yellow.

March 27, 2009, 10:25 AM

ChannyS

Tom,

That is how I created the above HTML but when I run it, the second box does not get populated. Are you able to run the above HTML successfully?

And, like I said, it does work when I do the same exact steps but apply one of the other operators.

March 27, 2009, 10:40 AM

Tom Flynn

I ran your code, Clicked on the 1st box, held the Ctrl key down, clicked on the second box, clicked on the chain +, on the toolbar, that is highlighted in yellow, clicked the run button.

Tom

March 27, 2009, 10:47 AM

ChannyS

Did you apply the "greater than" or "greater than or equal to" chaining logic to it before running?

March 27, 2009, 10:52 AM

Tom Flynn

quote:
I ran your code;

I didn't say anything about making changes

March 27, 2009, 10:59 AM

ChannyS

Since you said you clicked on the toolbar and clicked on the plus button, it sounded to me like you re-chained them. I don't understand how you and I can run the same thing against the same version of WebFOCUS and have different results.

March 27, 2009, 11:04 AM

Tom Flynn

You asked about "code" changes.
The instructions given were what I did to "chain" the boxes.

The chaining function in 7.6.8 works for all the HTML forms I've created under this release.

Signing out...

March 27, 2009, 11:11 AM

ChannyS

I guess I wasn't clear - the basic chaining is working for me as well. It's when I apply chaining logic - greater than, or greater than or equal to that doesn't work. I believe that is what I provided in the HTML above.

March 27, 2009, 11:30 AM

Tom Flynn

C,

When I initially ran your code, the 2nd box wasn't populated, so, that was what I thought your error was.

The chaining logic does not seem to work, it seems to ALWAYS use the default, equal to.

So, my bad, I don't use that feature, AND, it does seem to be a bug...

Tom

March 27, 2009, 11:37 AM

ChannyS

OK - thanks for confirming. At least I know that it's not something I am doing wrong. I will continue to try to work with IBI on this.

March 27, 2009, 12:25 PM

Tom Flynn

Just to follow up:

I edited the HTML and changed:

cacheruntimedata="1" to cacheruntimedata="0"

This allowed the expression to work - for the 1st time only!

After another selection from the 1st box, it did not work...

FYI

March 27, 2009, 12:37 PM

ChannyS

And the plot thickens

March 30, 2009, 07:50 AM

Lucas

I am just shooting in the dark, but try to encode the > and >=.
Change the > to

%3E

and the >= to

%3E%3D

So in the source where you have the expression=">=" attribute of the select tag it should look like

expression="%3E%3D"

.

I have no clue if this will actually solve your problem, but it is worth a shot......