[CLOSED] Chained Dropdowns with 2000 rows

December 17, 2010, 10:49 AM

Winfred Gunter

Hello,

I have 5 chained dropdowns (using composer). The first 4 work as expected. The 5th is working too, but it loads 2000 (initially). When it loads it causes a "script warning" and is slow.

I have read everything I can find on FOCAL POINT about chaining and can't seem to resolve this.

Is there a way to NOT populate #5 until the parent is selected?

If/when a user navigates down the chain to #5, there should only be a reasonable number of items returned for #5 (not 2000).

Thanks,
--wg

This message has been edited. Last edited by: Winfred Gunter,

December 17, 2010, 01:06 PM

Tom Flynn

WG,

make sure the List/Combo box has AUTO EXECUTE equal to FALSE... The only one that AUTO EXECUTE is equal to TRUE is the Parent box...

hth

Tom

This message has been edited. Last edited by: Tom Flynn,

December 17, 2010, 03:03 PM

Winfred Gunter

Tom,

You're going to make me reveal my ignorance! And where is this AUTO EXECUTE option?

I'm on dev studio 7610.

I don't see it in properties, nor parameters nor code (html tab).

--wg

December 17, 2010, 03:30 PM

Tom Flynn

WG,

You are not displaying ignorance! FYI, I always populate my boxes with fex's, not metadata.
So, when you go into the HTML code, you'll see something like this(search for autoExecute):

  
<META content="MSHTML 6.00.6000.17092" name=GENERATOR></HEAD>
<BODY style="OVERFLOW: auto" elementtype="21" edaconnectionrequired="true" nextelementuniquenumber="8">
<IFRAME id=iframe1 style="Z-INDEX: 61; LEFT: 3px; WIDTH: 947px; POSITION: absolute; TOP: 100px; HEIGHT: 1150px" tabIndex=58 src="" frameBorder=no autoExecute=False" HEIGHTOLD="946" WIDTHOLD="912" name="iframe1"></IFRAME>
<FORM id=form2 style="Z-INDEX: 62; LEFT: 0px; WIDTH: 960px; POSITION: absolute; TOP: 0px; HEIGHT: 90px" tabIndex=59 onsubmit="OnExecute(this);return false;" method=post form_type="2" fexlist_list="form2" requests_list="1" default_slider_type="4" form_prompt_location="1" form_number_of_visible_rows="4" form_number_of_columns="4" vert_dist_between_controls="10" form_hor_dist_between_controls="10" form_dist_between_desc_and_input="10" name="form2">
<INPUT id=form2Submit style="Z-INDEX: 63; LEFT: 430px; BACKGROUND-IMAGE: url(/ibi_html/javaassist/ibi/html/describe/run16.gif); WIDTH: 38px; BACKGROUND-REPEAT: no-repeat; POSITION: absolute; TOP: 68px; HEIGHT: 22px; BACKGROUND-COLOR: lavender" tabIndex=60 type=submit value=" " name="ITEM1"> 
<INPUT id=form2Reset style="Z-INDEX: 64; LEFT: 470px; BACKGROUND-IMAGE: url(/ibi_html/javaassist/ibi/html/describe/reset.gif); WIDTH: 38px; BACKGROUND-REPEAT: no-repeat; POSITION: absolute; TOP: 68px; HEIGHT: 22px; BACKGROUND-COLOR: lavender" tabIndex=61 type=reset value=" " name="reset1"> 
<FIELDSET id=form2_formbodyid style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; Z-INDEX: 65; LEFT: 5px; PADDING-BOTTOM: 0px; OVERFLOW: auto; WIDTH: 955px; BORDER-TOP-STYLE: none; PADDING-TOP: 0px; BORDER-RIGHT-STYLE: none; BORDER-LEFT-STYLE: none; POSITION: absolute; TOP: 0px; HEIGHT: 70px; BORDER-BOTTOM-STYLE: none" tabIndex=62 tempheight="134" tempwidth="312" formbody="1">
<SPAN id=pane1 style="Z-INDEX: 66; LEFT: 0px; WIDTH: 115px; POSITION: absolute; TOP: 0px; HEIGHT: 51px" tabIndex=63 elementtype="32" name="TERM">
<STRONG>Term</STRONG>

Look for autoExecute...

hth

December 17, 2010, 03:42 PM

Winfred Gunter

Tom,

Previous note said I didn't see it in the html code either.

My code is generated with composer. The chaining is done by composer. On the parameters tab, I have "embedded procedure" checked and it puts a little TABLE request with XML out.

There's an option to "Limit values returned", but it kills the chaining if I select it.

Still no "autoExec" found in the code (that I see).

Sorry,
--wg

December 17, 2010, 03:44 PM

Winfred Gunter

Tom,

Are you saying you select the External Procedure and give a fex to populate your control?

I'll try that, to see if it inserts and autoExec parm that I can then change to 'False'

--wg

December 17, 2010, 03:50 PM

Tom Flynn

WG,

Yes, External Procedure. Say you have 4 boxes, chained. Each calls a fex. The 1st one(Parent) executes onload, the other 3 do not. Then, upon a selection, send the Parent value to the 2nd fex with a WHERE:

WHERE column_name EQ 'selected_value1';

Then in, in the 3rd fex:

WHERE column_name EQ 'selected_value1';
WHERE column_name EQ 'selected_value2';

Then in, in the 4th fex:

WHERE column_name EQ 'selected_value1';
WHERE column_name EQ 'selected_value2';
WHERE column_name EQ 'selected_value3';

That's how I do mine, there are many other variations. Hopefully, someone else will chime in, although, getting close to vacation time (mine begins in 1 hour).

December 17, 2010, 04:44 PM

Winfred Gunter

Tom,

So, you are coding by hand or thru the composer?
I guess I need a simple car example to follow doing it your way. I'm new to this gui stuff
and would prefer to code everything (for better control purposes).

I'm use to coding the chained controls (building the js arrays and such), then discovered how fast the composer can do this and am trying to convert to using the composer (to be faster).

Thanks and I wish for you a happy holiday vacation...

--wg

December 17, 2010, 05:06 PM

Tom Flynn

WG,

No, I do what you do, develop everything in the composer, then I "tinker" with the code.
Showing/Hiding combo/list boxes based on selection, JS date validation, etc.

Usually can't open in the GUI afterwards, though. Yes, with an embedded procedure, it will
execute immediately. Maybe you can set a recordlimit the 1st time through, onload, then,
generate the list after the parents are selected.

Again, hard to show quickly here.

Search on chain or chaining, lot's of examples. Just need to find the right thread...

Happy Holidays to you and yours, as well!!!

Tom

December 17, 2010, 05:49 PM

Winfred Gunter

All,

I'm going to close this discussion. I got it working by using Tom's suggestion. That is, I took the 5th component (combobox) and changed it to pop from an external procedure. Then added a recordlimit of 100.
That did the trick. However, I never received or found an autoExecute setting. I can live with it not getting a complete list initially (which is useless). Everyone will be instructed to go down the chain anyway. By the time you reach the 5th combobox, there's not more than a 100.

Thanks,
--wg