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.
I have a procedure that HOLDS a small line graph - a sparkline. I have this procedure -INCLUDed into a TABLE FILE procedure. It appears to work just fine and it will display the gif file that is created BUT when I change the parameters that are feeding this procedure it is not refreshing the graph as well. Am I missing a command?This message has been edited. Last edited by: Kerry,
Sorry about that - I should have just provided the information in the first post.
Here's a glimpse of what my procs look like.
HOLD graph:
APP FI 006SPARK DISK dash_phperform/006SPARK.GIF
GRAPH FILE...
PRINT...
BY...
ON GRAPH HOLD AS 006SPARK FORMAT GIF...
TABLE FILE proc:
-DEFAULT &timeframe='Most Current Results'
-DEFAULT ®ion='FOC_NONE'
-DEFAULT &facility='FOC_NONE'
-INCLUDE dash_phperform/pp_006_sparkline.fex
-SET &sparkline='<img src"/approot/dash_phperform/006SOARK.gif">';
DEFINE FILE...
Sparkline/A200='&sparkline';
END
TABLE FILE...
PRINT...
Sparkline AS ''
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET STYLE *
...
TYPE=DATA,
IMAGE=(Sparkline),
...
So in this second procedure what needs to be passed to the first one is really the ®ion and &facility parameters.
I haven't been testing it from the launch page - I was just working from the original step 2 procedure so I do not know the answer to your first question.
However, when I run the procedure with the &ECHO=ALL and view the source code it appears that the right parameters are being passed but the image is just not changing.
Are you able to check the image written to the dash_phperform directory, is it changing ?
If so, then it still may be a caching issue.
The other thing that you could try is when the new parameters are chosen and the report is run, refresh the page with Ctrl-F5 (on some browsers), this will refresh the page without referencing the browsers cache.
Your gif file is getting cached by either the web server or the app server. Make your gif file url unique.
DEFINE FILE...
Sparkline/A209='&sparkline' || '?' || HHMMSS('A8');
END
TABLE FILE...
PRINT...
Sparkline AS ''
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET STYLE *
...
TYPE=DATA,
IMAGE=(Sparkline),
"There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott
I'm not sure I exactly follow. Add the syntax that you provided just adds the timestamp after my gif file. I still get the old image with the new timestamp.
So...here's what I did instead. Nothing appeared to work when I -INCLUDE(d) the graphic into the TABLE FILE. Instead I had both fexes - the graphic and the table file - HOLD to HTMTABLE format and then -INCLUDE(d) them in another fex which used an HTMLFORM to display them. The graphic refreshes appropriately and everything looks the same as if I was to do it in the TABLE FILE. I'm not sure if this is the 'ideal' solution but it works so I'm running with it. Thanks everyone.
Focal Point Forums 
