 |
|||||
|
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
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. | |||||
Read-Only TopicGo | Search | Notify | Tools |
| [SOLVED] devstu 766 & chaining | Login/Join |
| Expert |
We can't chain in a launch page in 766. it dies. We can't do it in 765, it dies. I'm told it works in 764, but i haven't seen a working example Yes, i've opened a case...but its languishing in the nobody cares pile. If anyone would be kind enought to try: here's the fex APP PATH ibisamp -SET &ECHO = ALL ; TABLE FILE CAR SUM SALES BY COUNTRY BY CAR BY MODEL WHERE COUNTRY IS '&COUNTRY' WHERE CAR IS '&CAR' END and here's the launch page(just the body tag bit), allegedly chained, by 766
<BODY style="OVERFLOW: auto" edaconnectionrequired="true">
<IFRAME id=report1 title=app/carchainfex.fex style="Z-INDEX: 1; LEFT: 160px; OVERFLOW: auto; WIDTH: 450px; POSITION: absolute; TOP: 195px; HEIGHT: 315px" tabIndex=1 name=report1 elementtype="2" autoExecute="False" WIDTHOLD="430" HEIGHTOLD="245" requests_list="0" executebuttonId="form2Submit"></IFRAME>
<FORM id=form2 style="Z-INDEX: 2; LEFT: 160px; WIDTH: 440px; POSITION: absolute; TOP: 90px; HEIGHT: 105px" tabIndex=2 name=form2 onsubmit="OnExecute(this);return false;" method=post requests_list="0" form_dist_between_desc_and_input="10" form_hor_dist_between_controls="10" vert_dist_between_controls="10" form_number_of_columns="4" form_number_of_visible_rows="4" form_prompt_location="1" default_slider_type="4" fexlist_list="report1">
<INPUT id=form2Submit style="Z-INDEX: 3; LEFT: 5px; BACKGROUND-IMAGE: url(/ibi_html/javaassist/ibi/html/describe/run16.gif); WIDTH: 38px; BACKGROUND-REPEAT: no-repeat; POSITION: absolute; TOP: 78px; HEIGHT: 22px; BACKGROUND-COLOR: lavender" tabIndex=3 type=submit value=" " name=ITEM1>
<FIELDSET id=form2_formbodyid style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; Z-INDEX: 6; LEFT: 5px; PADDING-BOTTOM: 0px; OVERFLOW: auto; WIDTH: 415px; BORDER-TOP-STYLE: none; PADDING-TOP: 0px; BORDER-RIGHT-STYLE: none; BORDER-LEFT-STYLE: none; POSITION: absolute; TOP: 5px; HEIGHT: 73px; BORDER-BOTTOM-STYLE: none" tabIndex=6 formbody="1" tempwidth="202" tempheight="73">
<SPAN id=pane1 style="Z-INDEX: 7; LEFT: 0px; WIDTH: 85px; POSITION: absolute; TOP: 0px; HEIGHT: 51px" tabIndex=7 elementtype="32" name="COUNTRY">COUNTRY
<SELECT id=combobox1 style="Z-INDEX: 8; LEFT: 0px; WIDTH: 75px; POSITION: absolute; TOP: 29px" tabIndex=8 size=1 name=COUNTRY cacheruntimedata="1" inchainindex="1" chainnumber="0" dynalldisplayvalue="ALL" datafield="COUNTRY" ibiformat="A10" sourcetype="typeMaster" datatype="1" requiredfield="1458106" boundtovariable="1" datasource="car.mas" selectedvalue="ALL" operation accept="0" addalloption="1" defaultlocation="29,0,51,34" displayfield newchainnumber="0"></SELECT></SPAN>
<SPAN id=pane2 style="Z-INDEX: 9; LEFT: 275px; WIDTH: 85px; POSITION: absolute; TOP: 5px; HEIGHT: 51px" tabIndex=9 elementtype="32" name="CAR">CAR
<SELECT id=combobox2 style="Z-INDEX: 10; LEFT: 0px; WIDTH: 85px; POSITION: absolute; TOP: 29px" tabIndex=10 size=1 name=CAR cacheruntimedata="1" inchainindex="2" chainnumber="0" dynalldisplayvalue="ALL" datafield="CAR" ibiformat="A16" sourcetype="typeMaster" datatype="1" requiredfield="1458106" boundtovariable="1" datasource="car.mas" selectedvalue="ALL" operation accept="0" addalloption="1" defaultlocation="29,0,51,85" displayfield="CAR" newchainnumber="0" dfformat="A16"></SELECT></SPAN></FIELDSET></FORM>
<INPUT id=layoutinfo style="LEFT: -100px; POSITION: absolute; TOP: -100px" type=hidden inputcontrolids="combobox1;combobox2">
<INPUT id=IBIMR_domain style="LEFT: -100px; POSITION: absolute; TOP: -100px" type=hidden value=untitled/untitled.htm name=IBIMR_domain>
<INPUT id=IBIMR_folder style="LEFT: -100px; POSITION: absolute; TOP: -100px" type=hidden value=#wfvergroupjj name=IBIMR_folder>
<INPUT id=ibif_ex style="LEFT: -100px; POSITION: absolute; TOP: -100px" type=hidden value=app/carchain_launch.htm name=ibif_ex>
<INPUT id=ibiapp_app style="LEFT: -100px; POSITION: absolute; TOP: -100px" type=hidden value=ibisamp name=ibiapp_app ismre="1">
<INPUT id=ibic_server style="LEFT: -100px; POSITION: absolute; TOP: -100px" type=hidden value=EDASERVE name=ibic_server>
<SCRIPT id=IBI_ChainScript type=text/javascript>
<!--
window.chain0=new Array(1);
window.chain0[0]=new String("combobox1;combobox2");
window.chain0[1]=1
//--></SCRIPT>
<xml id=ibi_requests>
<script>
<requests>
<request requestid="0" targettype="iframe" targetname="report1" sourcetype="typeFex" ibif_ex="app/carchainfex.fex" IBIMR_domain="untitled/untitled.htm" IBIMR_folder="#wfvergroupjj" IBIMR_sub_action="MR_STD_REPORT" ibiapp_app="" activereport="0" reportcolumns="">
<variables>
<variable parametercreatedinreslay="0" displayfield="COUNTRY" format="" field="COUNTRY" file="car.mas" desc="COUNTRY" datatype="0" operation="" default="" name="COUNTRY" textvarname="" accept="0" type="unresolved" select="0" min="" max="" controltype="7" create="1"></variable>
<variable parametercreatedinreslay="0" displayfield="CAR" format="" field="CAR" file="car.mas" desc="CAR" datatype="0" operation="" default="" name="CAR" textvarname="" accept="0" type="unresolved" select="0" min="" max="" controltype="7" create="1"></variable></variables></request>
</requests></script>
</xml></BODY>
I've tried setting that cacheruntimedata to 0, i read that was for loading w/ fexes. I just can't get it to work at all. making me crazy.This message has been edited. Last edited by: Kerry,
| ||||
|
| Expert |
it works! thank you tom flynn!!!! ok i'll compare line by line and see what the difference is... you seem to have taken the cacheruntimedata parm out completely... how did you do that in the gui? so your gui technique is to: pick box 1, click dynam, hold down shift, pick 2. When you click dynam, have you already done the specifying for both box1 and box2 of the dynam file? When do you pick the chain link icon? I pick 1, shift key, pick2, then click chain. Is that wrong? well, obviously that's wrong... 
| |||||
|
| Expert |
tom, i still can't create a chain in my devstu... but i can run yours just fine. now when i take your parms, and change them from 'dynamic' to 'fex'... i can't chain. the little fexes work fine, unchained. TABLE FILE CAR SUM CAR BY CAR ON TABLE PCHOLD FORMAT XML END and the same for country then chaining doesn't work i change the cacheruntimedata="0", (there is a 'solution' on the css site )..but that doesn't work. Can I impose upon your kindness again to see if you can make that work? thanks Tom -s. im in IE7...are you? | |||
|
| Expert |
Susannah, Are you trying to create this launch page in Apps folders or MRE? T
| |||||||||
|
| Expert |
That is very interesting, Tom, as my developers do this all the time. They are mostly business users so tend to use the GUI more than the folks on this forum. I can provide working examples using the CAR file if you would be interested. Let me know. 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 | |||
|
| Expert |
T, i'm creating them for MRE. and creating them via DevStu accessing the MRE domain directly. Ginny, if you can show me a working example with the car file, that uses wee little fexes to pop CAR and COUNTRY and chains them... I'll definitely buy you a beer at the White Horse next June. | |||
|
| Expert |
Tom, I did the example in the book and then tried yours. When I did the one from the book, I got the same error that you did. Then I put quotes around the amper variables in the select fexes and the page started working. So the error is in the doc. Here is the second fex: -* File ggsales_state.fex TABLE FILE GGSALES SUM FST.ST BY ST WHERE REGION EQ '®ION'; ON TABLE PCHOLD FORMAT XML END Change the third one the same way. Then I copied the first page and change the Region dropdown to be from a master. This worked as well. I did not do the test with caching on and a single xml fex. Let me know if this helps you at all. 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 | |||
|
| Expert |
Try taking out the HOLDLIST PRINTONLY line. That is not in the manual. I'm doing this from 7.6.5 BTW. 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 | |||
|
| Expert |
I copied mine from the 5.3 manual and I see it has changed in the 7.6 manual. Let me change my test and get back to you on the results. 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 | |||
|
| Expert |
I changed FST to DST and added the HOLDLIST line to each of the focexecs. Both of my pages worked fine. What release are you doing this in, Tom? 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 | |||
|
| Expert |
Well, I did store codes instead of cities, but yes. I did have to turn caching off. But yes, it is working. And I did it both ways, with a focexec for region and another page with master for region. Just to make sure, I copied the fexes and the pages up to my Unix environment (did it on localhost before) and the pages worked unchanged. Maybe it is case opening time for you guys. But before you do that, try doing a fex for region and see if that works. 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 | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |