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,

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
  

Thanks Chuck, that's interesting...

There are so many 'hidden gems' out there... Just need to do some mining...

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

Anatess

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