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 firstname.lastname@example.org for further assistance. Reference the community FAQ to learn more about the community.
We're having a problem where one or more Report Caster access lists may have been accidently deleted. We're tying to identify schedules that should have access lists but don't.
If anyone is aware of the database field containing the 'private' indicator, it would be very helpful. We have thousands of schedules and many are 'private' so we need to filter the 'private' access option out of our results. Our results should return all non-private, Library Report distributions that do not have an access list.
Here's the basic query before any filtering. I have not been able to identify the 'Private' indicator.
SELECT * --BOTACCES.ACCESSNAME,BOTACCES.CASTER_USER, BOTSCHED.JOBDESC FROM BOTSCHED LEFT JOIN BOTCAT ON BOTCAT.SCHEDULEID = BOTSCHED.SCHEDULEID LEFT JOIN BOTLIST ON BOTLIST.ACCESSID = BOTCAT.ACCESSNAME LEFT JOIN BOTACCES ON BOTACCES.ACCESSID = BOTLIST.ACCESSID LEFT JOIN BOTDIST ON BOTDIST.SCHEDULEID = BOTSCHED.SCHEDULEID ORDER BY BOTACCES.ACCESSNAME, BOTSCHED.JOBDESCThis message has been edited. Last edited by: FP Mod Chuck,
When you say "need to filter the 'private' access option out of our results" do you mean that you are looking for all published schedules?
If so, maybe this SQL can help.
AS (SELECT ur.ID
, ur.NAME 'OBJNAME'
, CAST('' AS VARCHAR(MAX)) 'PRT_PATH'
, CAST('' AS VARCHAR(MAX)) 'FULL_PATH'
FROM UOA_RESOURCES ur
, CAST(rc.FULL_PATH AS VARCHAR(MAX))
, CAST(rc.FULL_PATH + '/' + ur.NAME AS VARCHAR(MAX))
FROM UOA_RESOURCES ur
INNER JOIN RESOURCES_CTE rc
SELECT wr.PRT_PATH 'parentPath'
, wr.OBJNAME 'fileName'
, wi.DATATYPE 'fileType'
, wn.OBJDESC 'title'
, IIF(u.DESCRIPTION IS NULL
AND NOT wr.PRT_PATH LIKE '/WFC%/~%', 'Y', 'N') 'published'
, ISNULL(rc.SHARES, '') 'shared'
, ISNULL(u.DESCRIPTION, '') 'owner'
FROM WF_REPOSOBJ wr
LEFT JOIN WF_ITEM wi
LEFT JOIN WF_NLSOBJ wn
LEFT JOIN RESOURCES_CTE rc
LEFT JOIN UOA_USERS u
AND wr.PRT_PATH LIKE '/WFC/Repository/%'
ORDER BY wr.PRT_PATH
This message has been edited. Last edited by: Hallway,
Posts: 608 | Location: Salt Lake City, UT, USA | Registered: November 18, 2015
Thanks for your reply Hallway. We're not looking for published schedules. Too bad screen shots can't be posted here ... 'Private' is a radio button in 'Access Options' for 'Report Library' distribution. The two Access Options are 'Private' and 'Shared with'. 'Shared with' requires an access list. 'Private' does not require and access list.