SQL Query (not oracle) to find all the users and groups(along with group members) inside a group.

# SQL Query (not oracle) to find all the users and groups(along with group members) inside a group.

I am using content server 10 with sql server, I have the query for oracle (using connect by prior) but now needed it for sql server. I know it can be done using CTE but not able to make one.

Find more posts tagged with

Comments

Colin_Schmidt

Thequery here works in MS SQL for tracing the path of a document within CS. The “path” of a User in all the Group it’s in might be a similar structure that this could be used in because the Oracle method you cited can also be used on this to find all Groups.

Colin J. Schmidt

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Tuesday, September 12, 2017 12:58 PM
To: eLink Recipient <devnull@elinkkc.opentext.com>
Subject: SQL Query (not oracle) to find all the users and groups(along with group members) inside a group.

SQL Query (not oracle) to find all the users and groups(along with group members) inside a group.

Posted by ****, Sachin On 09/12/2017 12:54 PM

# SQL Query (not oracle) to find all the users and groups(along with group members) inside a group.

I am using content server 10 with sql server, I have the query for oracle (using connect by prior) but now needed it for sql server. I know it can be done using CTE but not able to make one.

[To post a comment, use the normal reply function]
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center CS16

The information contained in this e-mail is confidential and/or proprietary to Capital One and/or its affiliates and may only be used solely in performance of work or services for Capital One. The information transmitted herewith is intended only for use by the individual or entity to which it is addressed. If the reader of this message is not the intended recipient, you are hereby notified that any review, retransmission, dissemination, distribution, copying or other use of, or taking of any action in reliance upon this information is strictly prohibited. If you have received this communication in error, please contact the sender and delete the material from your computer.

Glanet_Castelino

Hi Sachin,

Am looking for a similar Report in SQL. Did you manage to do it.if so, can you share the query.

Thanks in advance

Colin_Schmidt

It's not hard to find the equivalent on the Internet. That's what I've had to do when I had to convert Oracle to MS SQL.

For simple example, concatenating: Oracle: "||" for MS SQL: "+"

For converting or referencing numbers, the CAST command is used and the format for either can be found on-line.

For MS SQL's relative to "Connect By Prior", check this link.

https://stackoverflow.com/questions/31827817/sql-server-equivalent-of-oracle-connect-by-prior-and-order-siblings-by