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; } } }

Query for Folder name at last level of hierarchy on SQL server

Prem_K

Hi ,

Can someone please tell me the query to display the folder name,dataid and path at the last level of folder hierarchy

Ex. Enterprise\Folder1\Folder2\Folder3

Find more posts tagged with

Comments

Lindsay_Davies

Hi,

If you have a search in this forum you will find an answer.

When posting questions, it helps those who might respond if you state whether you are using Oracle or Microsoft SQL server.

Regards

Lindsay

Lindsay Davies
Information Systems Administrator
RES
D +44 (0)1923 299 378

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: 13 June 2016 11:01
To: eLink Recipient
Subject: Query for Folder name at last level of hierarchy on SQL server

Query for Folder name at last level of hierarchy on SQL server

Posted by K, Prem Sagar On 06/13/2016 05:56 AM

Hi ,

Can someone please tell me the query to display the folder name,dataid and path at the last level of folder hierarchy

Ex. Enterprise\Folder1\Folder2\Folder3

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

CONFIDENTIALITY NOTICE: This e-mail, including any attachments, contains information that may be confidential, and is protected by copyright. It is directed to the intended recipient(s) only. If you have received this e-mail in error please e-mail the sender by replying to this message, and then delete the e-mail. Unauthorised disclosure, publication, copying or use of this e-mail is prohibited. Any communication of a personal nature in this e-mail is not made by or on behalf of any RES group company. E-mails sent or received may be monitored to ensure compliance with the law, regulation and/or our policies.

Prem_K

Thanks Lindsay

I have tried searching but no results.

I have specified it database as SQLserver in the title.

Regards,

Prem

eLink User

None of these can be re-purposed?

https://knowledge.opentext.com/knowledge/cs.dll?func=ll&objId=19679519&objAction=viewincontainer&ShowReplyEntry=20077222#forum_topic_20077222

https://knowledge.opentext.com/knowledge/llisapi.dll?func=ll&objId=3367908&objAction=viewincontainer&ShowReplyEntry=3371354#forum_topic_3371354

Newer code bases of OT livelink stresses the use of WEBREPORTS for all kinds of reporting activity and using it to get commonly done things.One of the things you get with that is full node info.

IN SQL SERVER the connect by does not exist,you will have to create a CTE or a function. Check your sqlserver databses for utility functions or CTE's OT themselves must have put ,one of them may be useful who knows...

.....appu appnair appunair

Well, if I called the wrongnumber, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937

On Mon, Jun 13, 2016 at 9:28 AM, eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com> wrote:

RE Query for Folder name at last level of hierarchy on SQL server Posted byK, Prem SagarOn 06/13/2016 10:27 AM

Thanks LindsayI have tried searching but no results.I have specified it database as SQLserver in the title.Regards,Prem
[To post a comment, use the normal reply function]Topic:Query for Folder name at last level of hierarchy on SQL serverForum:Content Server LiveReports ForumContent Server:Knowledge Center

Lindsay_Davies

Hi Prem,

Sorry, I was obviously rushing this morning and overlooked the subject line.

What version of sql server are you using?

Regards

Lindsay

Lindsay Davies
Information Systems Administrator
RES
D +44 (0)1923 299 378

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: 13 June 2016 15:28
To: eLink Recipient
Subject: RE Query for Folder name at last level of hierarchy on SQL server

RE Query for Folder name at last level of hierarchy on SQL server

Posted by K, Prem Sagar On 06/13/2016 10:27 AM

Thanks Lindsay

I have tried searching but no results.

I have specified it database as SQLserver in the title.

Regards,

Prem

[To post a comment, use the normal reply function]
Topic:	Query for Folder name at last level of hierarchy on SQL server
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center

Prem_K

Hello Lindsay,

No problem.

We are using Microsoft SQL Server 2014 - 12.0.4422.0 (X64) version

Lindsay_Davies

Hi Prem,

I posted an answer at the bottom of this topic which contains all you need to know.

https://knowledge.opentext.com/knowledge/llisapi.dll?func=ll&objId=62000187&objAction=viewincontainer&ShowReplyEntry=62313748#forum_topic_62313748

Regards

Lindsay

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: 13 June 2016 16:42
To: eLink Recipient
Subject: RE RE Query for Folder name at last level of hierarchy on SQL server

RE RE Query for Folder name at last level of hierarchy on SQL server

Posted by K, Prem Sagar On 06/13/2016 11:29 AM

Hello Lindsay,

No problem.

We are using Microsoft SQL Server 2014 - 12.0.4422.0 (X64) version

[To post a comment, use the normal reply function]
Topic:	Query for Folder name at last level of hierarchy on SQL server
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center

Prem_K

Hi Lindsay,

Thanks for the info but how can we limit the records only to folders that are at the last level.

Lindsay_Davies

Hi Prem,

I can’t imagine what that output would look like.

I assume you want the lowest level of each branch.

How many rows are you getting back at the moment?

What is the deepest (highest number) level?

I suppose you could do something like number the rows in SubTree then compare the current row with the previous row and if the current level is not lower print it out.

Can you give me some sample output and show which rows you want to lose and which you want to display?

Lindsay

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: 13 June 2016 18:18
To: eLink Recipient
Subject: RE RE RE Query for Folder name at last level of hierarchy on SQL server

RE RE RE Query for Folder name at last level of hierarchy on SQL server

Posted by K, Prem Sagar On 06/13/2016 01:13 PM

Hi Lindsay,

Thanks for the info but how can we limit the records only to folders that are at the last level.

[To post a comment, use the normal reply function]
Topic:	Query for Folder name at last level of hierarchy on SQL server
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center