How to write a report to exclude specifc group in the results?

This is the pictureWe store confidential records in folders created by a specific group. We have custom attribute called "confidential". Checking this box doesn't make it confidential unless all the permissions are set correctly. We discourage users in creating confidential folders or documents, but it never gets thru. So I have to build a report which gives me all the folders and documents created other than the specific group. When I try to link three tables dtree,kuaf and custom categorytbl, I am not getting any results. I am linking dtree.groupid = kuaf.idPlease respond quickly. I am desparate to get this report done as soon as possible.

Find more posts tagged with

Comments

eLink User

Message from Alex Kowalenko via eLinkSo you want to know the objects created by users who are NOT in a specificgroup? Is this the base group or any group that the user belongs to? If it'sthe base group then your query should work. If it's any group then you coulduse KUAFRightsList to get a list of all groups that a user belongs to.-alex------Original Message-----From: knowledge@opentext.com [mailto:knowledge@opentext.com]On Behalf OfeLink Discussion: Livelink LiveReports DiscussionSent: Thursday, February 15, 2001 2:19 PMTo: eLink RecipientSubject: How to write a report to exclude specifc group in the results?How to write a report to exclude specifc group in the results?Posted by PMUser4 on 02/15/2001 02:17 PMThis is the pictureWe store confidential records in folders created by a specific group. Wehave custom attribute called "confidential". Checking this box doesn't makeit confidential unless all the permissions are set correctly. We discourageusers in creating confidential folders or documents, but it never gets thru.So I have to build a report which gives me all the folders and documentscreated other than the specific group.When I try to link three tables dtree,kuaf and custom categorytbl, I am notgetting any results.I am linking dtree.groupid = kuaf.idPlease respond quickly. I am desparate to get this report done as soon aspossible.[To reply to this thread, use your normal e-mail reply function.]============================================================Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server:https://knowledge.opentext.com/knowledge/livelink.exe

eLink User

Message from Kamalapuri, Ramani via eLinkThanks Alex, but I am afraid that there is no table called 'KUAF RightsList"in livelink 8.1.5Ramani KamalapuriPMUSA - Information ServicesPh: (804) 698-6678> -----Original Message-----> From: eLink Discussion: Livelink LiveReports Discussion> [SMTP:livereportsdiscussion@elinkkc.opentext.com]> Sent: Friday, February 16, 2001 2:47 PM> To: eLink Recipient> Subject: RE How to write a report to exclude specifc group in the> results? > > RE How to write a report to exclude specifc group in the results? > Posted by eLink on 02/16/2001 02:46 PM> > Message from Alex Kowalenko via eLink> > So you want to know the objects created by users who are NOT in a specific> group? Is this the base group or any group that the user belongs to? If> it's> the base group then your query should work. If it's any group then you> could> use KUAFRightsList to get a list of all groups that a user belongs to.> > -alex-> > -----Original Message-----> From: knowledge@opentext.com [mailto:knowledge@opentext.com]On Behalf Of> eLink Discussion: Livelink LiveReports Discussion> Sent: Thursday, February 15, 2001 2:19 PM> To: eLink Recipient> Subject: How to write a report to exclude specifc group in the results?> > > How to write a report to exclude specifc group in the results?> Posted by PMUser4 on 02/15/2001 02:17 PM> > This is the picture> > We store confidential records in folders created by a specific group. We> have custom attribute called "confidential". Checking this box doesn't> make> it confidential unless all the permissions are set correctly. We> discourage> users in creating confidential folders or documents, but it never gets> thru.> So I have to build a report which gives me all the folders and documents> created other than the specific group.> When I try to link three tables dtree,kuaf and custom categorytbl, I am> not> getting any results.> > I am linking dtree.groupid = kuaf.id> > Please respond quickly. I am desparate to get this report done as soon as> possible.> > > [To reply to this thread, use your normal e-mail reply function.]> > ============================================================> > Discussion: Livelink LiveReports Discussion> https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=224967> 7&> objAction=view> > Livelink Server:> https://knowledge.opentext.com/knowledge/livelink.exe> > [To reply to this thread, use your normal e-mail reply function.]> > ============================================================> > Topic: How to write a report to exclude specifc group in the results?> > https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=245597> 3&objAction=view> > Discussion: Livelink LiveReports Discussion> https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=224967> 7&objAction=view> > Livelink Server:> https://knowledge.opentext.com/knowledge/livelink.exe> >

eLink User

Message from Alex Kowalenko via eLinkAccording to the System Schema Reference Document (#2071815.1) the table iscalled "KUAFRightsList" (no spaces) and is re-generated for each userwhenever they log in and if there were any changes to the user-groupmemberships since they last logged in. The table has two columns: (1) RLID -a user ID (foreign key to ID in KUAF) and (2) RLRightID - the rights groupsthat the user belongs to.-----Original Message-----From: knowledge@opentext.com [mailto:knowledge@opentext.com]On Behalf OfeLink Discussion: Livelink LiveReports DiscussionSent: Monday, February 19, 2001 10:36To: eLink RecipientSubject: RE RE How to write a report to exclude specific group in the results?RE RE How to write a report to exclude specific group in the re sults?Posted by eLink on 02/19/2001 10:46 AMMessage from Kamalapuri, Ramani via eLinkThanks Alex, but I am afraid that there is no table called 'KUAF RightsList"in livelink 8.1.5Ramani KamalapuriPMUSA - Information ServicesPh: (804) 698-6678> -----Original Message-----> From: eLink Discussion: Livelink LiveReports Discussion> [SMTP:livereportsdiscussion@elinkkc.opentext.com]> Sent: Friday, February 16, 2001 2:47 PM> To: eLink Recipient> Subject: RE How to write a report to exclude specifc group in the> results?>> RE How to write a report to exclude specifc group in the results?> Posted by eLink on 02/16/2001 02:46 PM>> Message from Alex Kowalenko via eLink>> So you want to know the objects created by users who are NOT in a specific> group? Is this the base group or any group that the user belongs to? If> it's> the base group then your query should work. If it's any group then you> could> use KUAFRightsList to get a list of all groups that a user belongs to.>> -alex->> -----Original Message-----> From: knowledge@opentext.com [mailto:knowledge@opentext.com]On Behalf Of> eLink Discussion: Livelink LiveReports Discussion> Sent: Thursday, February 15, 2001 2:19 PM> To: eLink Recipient> Subject: How to write a report to exclude specifc group in the results?>>> How to write a report to exclude specifc group in the results?> Posted by PMUser4 on 02/15/2001 02:17 PM>> This is the picture>> We store confidential records in folders created by a specific group. We> have custom attribute called "confidential". Checking this box doesn't> make> it confidential unless all the permissions are set correctly. We> discourage> users in creating confidential folders or documents, but it never gets> thru.> So I have to build a report which gives me all the folders and documents> created other than the specific group.> When I try to link three tables dtree,kuaf and custom categorytbl, I am> not> getting any results.>> I am linking dtree.groupid = kuaf.id>> Please respond quickly. I am desparate to get this report done as soon as> possible.>>> [To reply to this thread, use your normal e-mail reply function.]>> ============================================================>> Discussion: Livelink LiveReports Discussion> https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=224967> 7&> objAction=view>> Livelink Server:> https://knowledge.opentext.com/knowledge/livelink.exe>> [To reply to this thread, use your normal e-mail reply function.]>> ============================================================>> Topic: How to write a report to exclude specifc group in the results?>> https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=245597> 3&objAction=view>> Discussion: Livelink LiveReports Discussion> https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=224967> 7&objAction=view>> Livelink Server:> https://knowledge.opentext.com/knowledge/livelink.exe>>[To reply to this thread, use your normal e-mail reply function.]============================================================Topic: How to write a report to exclude specifc group in the results?https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2455973&objAction=viewDiscussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server:https://knowledge.opentext.com/knowledge/livelink.exe