Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Content Management (Extended ECM)
API, SDK, REST and Web Services
How do you query all new documents added under a folder
Rashed_Al_Mekhyal_(x-theint01admin_-_(deleted))
I have a script which creates daily folders and adds document into those sub-folders. For example, today it will create Meeting Minutes (folder), March (folder), and inside it will create 17 (today's date) and then it will add the document(s)inside. I need to create a LR which will return daily all new documents which have been added under the root folder (supposing that Meeting Minutes is the root folder).Thx
Find more posts tagged with
Comments
eLink User
Message from Alex Kowalenko via eLinkin Oracle use something like the following:Select name, createdate from dtree where createdate >= sysdate - and subtype = 144 /* Document type */ start with dataid = connect by prior dataid = parentid-alex------Original Message-----From: knowledge@opentext.com [mailto:knowledge@opentext.com]On Behalf OfeLink Discussion: Livelink LiveReports DiscussionSent: Sunday, March 17, 2002 02:55To: eLink RecipientSubject: How do you query all new documents added under a folderHow do you query all new documents added under a folderPosted by THEINT01Admin on 03/17/2002 02:53 AMI have a script which creates daily folders and adds document into thosesub-folders. For example, today it will create Meeting Minutes (folder),March (folder), and inside it will create 17 (today's date) and then it willadd the document(s)inside.I need to create a LR which will return daily all new documents which havebeen added under the root folder (supposing that Meeting Minutes is the rootfolder).Thx[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=2249677&objAction=viewLivelink
Server:
https://knowledge.opentext.com/knowledge/livelink.exe
Thomas_Breit_(breitt_-_(deleted))
I need the same thing, but I have a MSSQL. Has anyone found out a way to do: start with dataid = connect by prior dataid = parentid on MSSQL?