Mark Gonzales Posted November 4, 2020 Share Posted November 4, 2020 Has anyone created a report from the repository that has schedule information along with the Access List (ACL) information for the libraries I have the following code that will report the ACL information tied to a report caster library but I do not know how to tie it back to the schedule. Any ideas JOIN BOTACCES.BOTACCES.ACCESSID IN botacces TO MULTIPLE BOTLIST.BOTLIST.ACCESSID IN botlist TAG J0 AS J0 END TABLE FILE BOTACCES BY BOTACCES.BOTACCES.ACCESSDESC BY J0.BOTLIST.MEMBER BY J0.BOTLIST.INDEXVALUE END Link to comment Share on other sites More sharing options...
Manoj Chaurasia Posted November 5, 2020 Share Posted November 5, 2020 Hi Mark Welecom to myibi!!! I looked at the database relationship diagram and there are no relationships between the botaccess and botlist tables back to the botsched table. I find that strange. You may want to check with techsupport to see if there is a way. Link to comment Share on other sites More sharing options...
Mark Gonzales Posted November 5, 2020 Author Share Posted November 5, 2020 Thanks Chuck and it is good to hear from you. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now