nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

User Groups List

Michael_Fennell

Hi ForumDoes anyone here know of some oracle sql that i could use to basically list the groups a user is a member of in our livelink system.I wanted to allow our records admins the ablility to be able to see this info from the users account like an admin but was told that they needed admin privilage so that idea was out.Next step a live report.Any help would be greatly appreciated.RegardsMike.

Find more posts tagged with

Comments

Al Picard

Message from Al Picard <apicard@opentext.com> via eLink

eLink

Hi Michael,

Your question has been keenly addressed by Bhupinder Singh in a Previous Topic.

Have a look at https://knowledge.opentext.com/knowledge/llisapi.dll?func=ll&objId=2627549&objAction=view&show=2 and particularly the link he included with the comment:

If you wish to set up a LiveReport to produce a list of all groups to which a user belongs, and are using an Oracle database with Livelink, an exhaustive answer to this question can be found at the following location in the Open Text Knowledge Centre: https://knowledge.opentext.com/knowledge/llisapi.dll?func=ll&objId=2627549&objAction=view&show=2

Regards,

Al Picard

OpenText Corporation, Ottawa, Ontario, Canada

From: eLink Discussion: Live Reports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Wednesday, March 02, 2011 8:02 AM
To: eLink Recipient
Subject: User Groups List

User Groups List

Posted by michael.fennell@fsa.gov.uk (Fennell, Michael) on 2011/03/02 08:01

Hi Forum
Does anyone here know of some oracle sql that i could use to basically list the groups a user is a member of in our livelink system.
I wanted to allow our records admins the ablility to be able to see this info from the users account like an admin but was told that they needed admin privilage so that idea was out.
Next step a live report.

Any help would be greatly appreciated.
Regards
Mike.

[To reply to this thread, use your normal E-mail reply function.]
Discussion:	Live Reports Discussion
Livelink Server:	knowledge-wlweb01

To Unsubscribe from this Discussion, send an e-mail to unsubscribe.livereportsdiscussion@elinkkc.opentext.com.

Michael_Fennell

Hi AlOk thanks very much for your reply i will have a look at the above documents.RegardsMike.

Al Picard

Message from Al Picard <apicard@opentext.com> via eLink

eLink

Hi Michael,

Sounds good.

Let me know if it is sufficient.

Regards,

/Al

From: eLink Discussion: Live Reports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Wednesday, March 02, 2011 10:13 AM
To: eLink Recipient
Subject: Re- User Groups List

Re- User Groups List		Posted by michael.fennell@fsa.gov.uk (Fennell, Michael) on 2011/03/02 10:09
In reply to: RE User Groups List		Posted by apicard (Picard, Alan on 2011/03/02 09:40

Hi Al

Ok thanks very much for your reply i will have a look at the above documents.

Regards
Mike.

[To reply to this thread, use your normal E-mail reply function.]
Topic:	User Groups List
Discussion:	Live Reports Discussion
Livelink Server:	knowledge-wlweb01

To Unsubscribe from this Discussion, send an e-mail to unsubscribe.livereportsdiscussion@elinkkc.opentext.com.

Michael_Fennell

Hi AlThat was perfect did not have to do much to get the report to return the information i wanted.One other question i did have was if you knew if i could use a sub-report to use the click through to open each of the groups up from the returned results.What i am trying to do here is give our Records managers the type of functionality offered to administrators in allowing them to view the groups a specific user is a member of then allowing them to browse the group.It would be great if you could even point me at some good documention on this or else some advice ?..RegardsMike.

Al Picard

Message from Al Picard <apicard@opentext.com> via eLink

eLink

Hi Mike,

I’m including an attachment that may give your Records Managers that functionality.

It allows them to, first, see the Groups, then click on a pass-through that reveals the users within.

Let me know if it serves your purpose.

Regards,

/Al

From: eLink Discussion: Live Reports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Wednesday, March 02, 2011 11:52 AM
To: eLink Recipient
Subject: Re-User Groups List

Re-User Groups List		Posted by michael.fennell@fsa.gov.uk (Fennell, Michael) on 2011/03/02 11:49
In reply to: RE Re- User Groups List		Posted by apicard (Picard, Alan on 2011/03/02 10:23

Hi Al

That was perfect did not have to do much to get the report to return the information i wanted.

One other question i did have was if you knew if i could use a sub-report to use the click through to open each of the groups up from the returned results.
What i am trying to do here is give our Records managers the type of functionality offered to administrators in allowing them to view the groups a specific user is a member of then allowing them to browse the group.
It would be great if you could even point me at some good documention on this or else some advice ?..

Regards
Mike.

[To reply to this thread, use your normal E-mail reply function.]
Topic:	User Groups List
Discussion:	Live Reports Discussion
Livelink Server:	knowledge-wlweb01

To Unsubscribe from this Discussion, send an e-mail to unsubscribe.livereportsdiscussion@elinkkc.opentext.com.

Michael_Fennell

Hi AlThanks very much for the live reports, had a look and even though i can follow to a point what is happening it is a bit beyond my SQL knowledge.But anyway after i have imported the live reports and try to run them i am getting this error"[ORA-32033: unsupported column aliasing - WITH cte"I am wondering if it is MSSQL server or oracle you are using as it seems to have some issue with the alias names or that is what i am thinking.Any thoughts on this ?.RegardsMike.

Lindsay_Davies

Message from Lindsay Davies <ldavies@opentext.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

Hi Mike,

You are right - with <name> as.... is the SQL server construct that is used to simulate the Connect By Prior technique that Oracle supports.

I don't know what statement you were using or quite where you got it from, so I suggest you search the discussion again and look for a connect by prior type of statement to use in Oracle.

Regards

Lindsay

From: eLink Discussion: Live Reports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: 2011 March 03, Thu 10:18
To: eLink Recipient
Subject: Re - User Groups

Re - User Groups		Posted by michael.fennell@fsa.gov.uk (Fennell, Michael) on 2011/03/03 05:13
In reply to: RE Re-User Groups List		Posted by apicard (Picard, Alan on 2011/03/02 13:30

Hi Al

Thanks very much for the live reports, had a look and even though i can follow to a point what is happening it is a bit beyond my SQL knowledge.
But anyway after i have imported the live reports and try to run them i am getting this error
"[ORA-32033: unsupported column aliasing - WITH cte"
I am wondering if it is MSSQL server or oracle you are using as it seems to have some issue with the alias names or that is what i am thinking.
Any thoughts on this ?.

Regards
Mike.