Focal Point
[Solved]WebFocus Repository tables, how to determine if chart or report.

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/6257037096

August 31, 2018, 04:14 PM
Kpfliger
[Solved]WebFocus Repository tables, how to determine if chart or report.
Hi,

I would like to know how to determine if a .fex file is a chart or a report by using the webfocus repository files (wf_*). I can see that those files hold a lot of information about the content you can create in the webfocus tools, but I can't figure out how to determine if a .fex file is a chart or a report by using those tables. There must be a way to determine it as when you create a chart or a report they have specific icons for each.

Please let me know if you have any questions.
Thanks!
Kelly

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


WebFOCUS 8
Windows, All Outputs
September 02, 2018, 05:27 PM
Waz
Are they InfoAssist reports / Charts ?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

September 04, 2018, 09:19 AM
Kpfliger
Yes, the content is created using InfoAssist.

Thanks!
Kelly


WebFOCUS 8
Windows, All Outputs
September 04, 2018, 12:12 PM
Frans
table wf_objectprops, filter on PROPERTY = OutputFormat, in PROPVALUE you'll see the format. JSCHART is a chart for example.


Test: WF 8.2
Prod: WF 8.2
DB: Progress, REST, IBM UniVerse/UniData, SQLServer, MySQL, PostgreSQL, Oracle, Greenplum, Athena.
September 04, 2018, 01:16 PM
BabakNYC
It looks like WHERE PROPVALUE = infoAssist,chart,IAFull then you have a Chart and WHERE PROPVALUE = infoAssist,report,IAFull then you have a report. But how do you figure out what the fex name is?


WebFOCUS 8206, Unix, Windows
September 04, 2018, 01:35 PM
Kpfliger
Thank You Frans that's exactly what I'm looking for.

Thanks again!
Kelly


WebFOCUS 8
Windows, All Outputs
September 04, 2018, 01:37 PM
FP Mod Chuck
Hi BabakNYC

Join the wf_reposobj table with the HANDLE field to the wf_objprops OBJ_HANDLE field.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats