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 on directory structure

Mario_Rodriguez_(sglcadmin52_-_(deleted))

Please, I'd like to know how can I query all files inside a folders ?e.g.:DIR A DIR A1 DIR A2 zzz.txt ****.txt DIR A3 DIR A3.1 DIR A3.2 aaa.txt bbb.txtthanks

Find more posts tagged with

Comments

Lindsay_Davies

Message from Lindsay Davies via eLinkAre you using SQL Server or Oracle as your database? -----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: 19 March 2007 18:31To: eLink RecipientSubject: Query on directory structureQuery on directory structurePosted by Rodriguez, Mario on 03/19/2007 02:28 PMPlease, I'd like to know how can I query all files inside a folders ?e.g.:DIR A DIR A1 DIR A2 zzz.txt ****.txt DIR A3 DIR A3.1 DIR A3.2 aaa.txt bbb.txtthanks[To reply to this thread, use your normal E-mail reply function.]============================================================Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/llisapi.dll/open/2249677Livelink Server:https://knowledge.opentext.com/knowledge/llisapi.dllTo Unsubscribe from this Discussion, send an e-mail tounsubscribe.livereportsdiscussion@elinkkc.opentext.com.

Mario_Rodriguez_(sglcadmin52_-_(deleted))

I'm using SQL Server

Lindsay_Davies

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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">I'm using SQL Server

Hi Mario,

You can search for SQL server stored procedure examples on the Knowledge Center web site.

There are examples to be found such as the link below.

https://knowledge.opentext.com/knowledge/llisapi.dll?func=ll&objId=4610762&objAction=view

To summarize - you use a stored procedure to define a temporary table (beginning with "#") and loop through results populating it.

Then select from the temporary table at the end.

you would create a separate stored procedure for each 'select' or function.

Had you been using Oracle, you would use the "connect by prior" construct.

SQL server 2005 is supposed to support this too.

Good luck.

Lindsay

UK-Support

Open Text

From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Mon 19/03/2007 19:27
To: eLink Recipient
Subject: I'm using SQL Server

I'm using SQL Server
Posted by Rodriguez, Mario on 03/19/2007 03:25 PM

I'm using SQL Server

[To reply to this thread, use your normal E-mail reply function.]

============================================================

Topic: Query on directory structure
https://knowledge.opentext.com/knowledge/llisapi.dll/open/11729377

Discussion: Livelink LiveReports Discussion
https://knowledge.opentext.com/knowledge/llisapi.dll/open/2249677

Livelink Server:
https://knowledge.opentext.com/knowledge/llisapi.dll

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

Jeff Lang

You can always use the DTreeAncestors table to select objects that are children of a parent object.Try the statement:select * from DTree where DataID in ( select DataID from DTreeAncestors where AncestorID=XXXX or AncestorID=-XXXX)replace XXXX with the dataID of the parent node.

Hans Stoop

Message from Hans Stoop via eLinkThis will only work if recommender is activated.Hans > -----Original Message-----> From: eLink Discussion: Livelink LiveReports Discussion > [mailto:livereportsdiscussion@elinkkc.opentext.com] > Sent: dinsdag 20 maart 2007 8:17> To: eLink Recipient> Subject: Use DTreeAncestors> > Use DTreeAncestors> Posted by Lang, Jeff on 03/20/2007 03:11 AM> > You can always use the DTreeAncestors table to select objects > that are children of a parent object.> > Try the statement:> > select * from DTree where DataID in ( select DataID from > DTreeAncestors where AncestorID=XXXX or AncestorID=-XXXX)> > replace XXXX with the dataID of the parent node.> > [To reply to this thread, use your normal E-mail reply function.]> > ============================================================> > Topic: Query on directory structure> https://knowledge.opentext.com/knowledge/llisapi.dll/open/11729377> > Discussion: Livelink LiveReports Discussion> https://knowledge.opentext.com/knowledge/llisapi.dll/open/2249677> > Livelink Server:> https://knowledge.opentext.com/knowledge/llisapi.dll> > To Unsubscribe from this Discussion, send an e-mail to > unsubscribe.livereportsdiscussion@elinkkc.opentext.com.> > >

Mario_Rodriguez_(sglcadmin52_-_(deleted))

Thanks for the updates.What is "recommender"? How activate it ?

Lee_Butler

Message from Lee Butler via eLinkHi Mario,I'm not sure about your particular department but I know that some of you guys have the WebReports module. If you have access to it, you can use Ajax type behavior to do a dynamic drill down. I've attached a screenshot and an XML export of the code to do it. You need WebReport 4.0 installed and LiveReport Extensions (which is free with WebReports).All you need to do is issue the following URL to do the import and it should work straight away. ?func=admin.XmlImport&filename=c:\ajax_webreport.xml&objID=2345In this case the attached XML file is at the root of the C drive, it's still called ajax_webreport.xml and you're importing it to a folder with the dataid 2345.Within the WebReport you click the container icons on the left to expand/contract the view at any given level.Hope you find it useful.Thanks,Lee.-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: Montag, 19. März 2007 19:31To: eLink RecipientSubject: Query on directory structureQuery on directory structurePosted by Rodriguez, Mario on 03/19/2007 02:28 PMPlease, I'd like to know how can I query all files inside a folders ?e.g.:DIR A DIR A1 DIR A2 zzz.txt ****.txt DIR A3 DIR A3.1 DIR A3.2 aaa.txt bbb.txtthanks[To reply to this thread, use your normal E-mail reply function.]============================================================Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/llisapi.dll/open/2249677Livelink Server:https://knowledge.opentext.com/knowledge/llisapi.dllTo Unsubscribe from this Discussion, send an e-mail to unsubscribe.livereportsdiscussion@elinkkc.opentext.com.

Mario_Rodriguez_(sglcadmin52_-_(deleted))

I need a sp or report where I can see all filenames and categories on the directory structure.Please, see the example on attach.The directory structure has 5 levels. I didn't find a way to list all levels. 1st level - DIR A....2nd level - DIR A1..................DIR A2................. DIR A3.........3rd level - DIR A1.1......................DIR A1.2......................DIR A2.1....How can I list all folders and files that are inside DIR A ??Thank you!

ORA-12154_error.jpg

Bruno_De_Planchon

Hello,Not a livereport, but maybe that could help you :In LL 9.2, you can use project outline to see the structure of a folder, it may work with later versions. You just have to call this url :http://server/livelink/livelink.exe?func=Projects.ProjectOutline&objid=*******and replace ******* with the id of your folderRegards

Mario_Rodriguez_(sglcadmin52_-_(deleted))

Thanks for the help. Unfortunately is not possible get a list off all files inside a folder structure using Livelink tool. Or nobody knows how to do it. Maybe is easier develop a MSSQL query. Thanks.

Jim_Coursey

Message from Coursey, Jim <jim.coursey@ngc.com> via eLink

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

This may not be what you had in mind, but if you tailor the following:

http://server/livelink/livelink.exe?func=Projects.ProjectOutline&objid=*******

by updating "server" to be your server name and "********" to be the objID of the folder whose contents you're interested in and perhaps loading it into a URL object, you get a very nice "indentured" (hierarchical) outline of the content of the folder. Perhaps by figuring out how to execute the function from within the LiveReport...

The URL works in at least v9.2 and v9.5

From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Thursday, March 22, 2007 1:49 PM
To: eLink Recipient
Subject: Thanks for the help. Unfortunately is not possible get a list off all files...

Thanks for the help. Unfortunately is not possible get a list off all files...		Posted by sglcadmin52 (Rodriguez, Mario) on 03/22/2007 01:45 PM
In reply to: Hello,		Posted by lamondialeuser1 (De Planchon, Bruno) on 03/21/2007 06:47 AM

Thanks for the help. Unfortunately is not possible get a list off all files inside a folder structure using Livelink tool. Or nobody knows how to do it. Maybe is easier develop a MSSQL query. Thanks.

Paul Langham

The project outline works in 9.7 as well thou there are limitations outside of a project, but i have a similar requirement, were i need to report on new documents being added to a new file structure and displaying the document name its location and some attatched attributes, there seems to be ways of pulling back the file structure but associating it with attributes is not so easy. Has anyway done this any help will be much appreciated. thanks