[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! KellyThis 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.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
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.
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