Focal Point
[SOLVED] Number of Focexecs in a Domain

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

October 15, 2019, 12:25 PM
Anatess
[SOLVED] Number of Focexecs in a Domain
Hi All,

I was wondering if there's an easy way to know how many focexecs are there in a domain in WF 8.2?

Regards,
Anatess

This message has been edited. Last edited by: FP Mod Chuck,


WF 8.1.05 Windows
October 15, 2019, 02:55 PM
FP Mod Chuck
Anatess

Try this...
TABLE FILE WF_REPOSOBJ
SUM 
     CNT.WF_REPOSOBJ.WF_REPOSOBJ.OBJNAME AS 'Fex,Count'
BY  WF_REPOSOBJ.WF_REPOSOBJ.PRT_PATH AS 'Domain'
WHERE WF_REPOSOBJ.WF_REPOSOBJ.OBJTYPE EQ 109;
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/warm.sty,
$
ENDSTYLE
END
  



Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
October 15, 2019, 10:59 PM
Doug
Thanks Chuck, that's interesting...

There are so many 'hidden gems' out there... Just need to do some mining...
October 21, 2019, 10:02 AM
Anatess
Hi Chuck,
Thank you so much for the help. Unfortunately, I don't have WF_REPOSOBJ. Is that something that requires admin authorization?

Regards,
Anatess


WF 8.1.05 Windows
October 21, 2019, 10:11 AM
FP Mod Chuck
Anatess

No.. You need to set up and adapter connection to your WebFOCUS repository tables and then create a synonym for WF_REPOSOBJ


Thank you for using Focal Point!

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