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
Want to Exclude Recycle Bin Contents from LiveReport Results
Anthony_Dorsa_(anthony_dorsa_-_(deleted))
We use a lot of Live Reports to find documents with specific attribute values. Unfortunately, these reports have been turning up items in our Livelink Recycle Bin. I cannot find a reliable 'flag' in the database that I can use to exclude recycle bin contents from the results of our queries. Would anyone have a good answer to this question?We have Livelink 9.1.4 with the Recycle Bin module version 2.7.5. Tony Dorsa
Find more posts tagged with
Comments
Lindsay_Davies
Message from Lindsay Davies via eLinkHi Tony,RecycleBin is a volume. Therefore all objects in the volume have theOWNERID=Sample of recyclebin contentsselect dataid,parentid,ownerid,name,subtype from dtree where ownerid=-54327 or dataid=54327 order by ownerid DATAID PARENTID OWNERID NAMESUBTYPE---------- ---------- ---------- ---------------------------------------- 54327 -1 -54327 Recycle Bin3030 18357 165208 -54327 New Category131 48000 110341 -54327 Folder 10 48001 110341 -54327 Folder 20 48287 110341 -54327 Folder 30 48361 110341 -54327 Folder 40 48363 111880 -54327 Folder 60 48364 110341 -54327 Folder 00 48365 54330 -54327 TNO Test Template202 49226 48364 -54327 Small Project from Template202 50632 48364 -54327 Small Project clean kuaf202 50885 262329 -54327 pdf 2144 50888 262329 -54327 pdf 3144As you are bound to be selecting rows from dtree, you would add a clauseWHERE DTREE.OWNERID != -54327 assuming that the dataid of the recyclebin is 54327, from my example above.This should sort you out.RegardsLindsay DaviesOT UK-Support-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: 02 March 2006 17:13To: eLink RecipientSubject: Want to Exclude Recycle Bin Contents from LiveReport ResultsWant to Exclude Recycle Bin Contents from LiveReport Results Posted byDorsa, Anthony on 03/02/2006 12:11 PMWe use a lot of Live Reports to find documents with specific attributevalues. Unfortunately, these reports have been turning up items in ourLivelink Recycle Bin. I cannot find a reliable 'flag' in the databasethat I can use to exclude recycle bin contents from the results of ourqueries. Would anyone have a good answer to this question?We have Livelink 9.1.4 with the Recycle Bin module version 2.7.5. Tony Dorsa[To reply to this thread, use your normal E-mail reply function.]============================================================Discussion: Livelink LiveReports Discussion
https://knowledge.opentext.com/knowledge/livelink.exe/open/2249677Livelink
Server:
https://knowledge.opentext.com/knowledge/livelink.exeTo
Unsubscribe from this Discussion, send an e-mail tounsubscribe.livereportsdiscussion@elinkkc.opentext.com.
Anthony_Dorsa_(anthony_dorsa_-_(deleted))
Thanks Lindsay, for your reply. However, I find that the OWNERID is not sufficient to determine which items are in the recycle bin. We have entire projects that have been deleted to the recycle bin with contents. The items contained within deleted projects retain the volume id of the parent project even when they are moved to the recycle bin. So a query on (-1) * Recycle Bin dataid in OWNERID field leaves out many items in the recycle bin.I would welcome any other suggestions.Tony
Lindsay_Davies
Message from Lindsay Davies via eLinkOK, you are correct with this complication.A volume is discrete and has no parent.So if you delete a volume (like a project's workspace, it gets tougherto do this.The only way to cope with this is to cross the volume boundaries withsome SQL.This is easy in Oracle with the Connect By Prior construct but notpossible in SQL server without writing a stored procedure.Here is a document's hierarchy in a project, crossing boundaries .... 1* select dataid,parentid,ownerid,name,subtype from dtree connect byprior abs(parentid)=abs(dataid) start with dataid = 280076SQL> / DATAID PARENTID OWNERID NAMESUBTYPE---------- ---------- ---------- ---------------------------------------- 280076 -280406 280406 DeleteMeText.txt144 280406 143967 -2000 DeleteMe Project202 143967 35925 -2000 AAA0 35925 2000 -2000 Tickets0 2000 -1 -2000 Enterprise141 -280406 -1 280406 DeleteMe Project2016 rows selected.And here it is, when deleted.Elapsed: 00:00:00.19SQL> / DATAID PARENTID OWNERID NAMESUBTYPE---------- ---------- ---------- ---------------------------------------- 280076 -280406 280406 DeleteMeText.txt144 280406 280203 -54327 DeleteMe Project202 280203 280202 -54327 073033 280202 280201 -54327 March3032 280201 54327 -54327 20063031 54327 -1 -54327 Recycle Bin3030 -280406 -1 280406 DeleteMe Project2017 rows selected.As you can see the ownerid does not change.I could see how you could select the ownerid of the ownerid, so see ifthe workspace (project) was deleted, but that would only work for onegiven level.Your solution needs to become more procedural/programmatic, which isoutside my experience.I hope this extra detail helps.RegardsLindsay-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: 07 March 2006 16:50To: eLink RecipientSubject: volumeid not comprehensive 'flag' for recycle bin objectsvolumeid not comprehensive 'flag' for recycle bin objects Posted byDorsa, Anthony on 03/07/2006 11:45 AMThanks Lindsay, for your reply. However, I find that the OWNERID is notsufficient to determine which items are in the recycle bin. We haveentire projects that have been deleted to the recycle bin with contents.The items contained within deleted projects retain the volume id of theparent project even when they are moved to the recycle bin. So a queryon (-1) * Recycle Bin dataid in OWNERID field leaves out many items inthe recycle bin.I would welcome any other suggestions.Tony[To reply to this thread, use your normal E-mail reply function.]============================================================Topic: Want to Exclude Recycle Bin Contents from LiveReport Results
https://knowledge.opentext.com/knowledge/livelink.exe/open/4700712Discussion
: Livelink LiveReports Discussion
https://knowledge.opentext.com/knowledge/livelink.exe/open/2249677Livelink
Server:
https://knowledge.opentext.com/knowledge/livelink.exeTo
Unsubscribe from this Discussion, send an e-mail tounsubscribe.livereportsdiscussion@elinkkc.opentext.com.
Anthony_Dorsa_(anthony_dorsa_-_(deleted))
Thanks, Lindsay,I am thinking about building an Oracle statment to recurse through the volumes of the recycle bin to build a table of all items in the recycle bin. I might set up a scheduled Oracle procedure to rebuild this table daily, as we have many LiveReports that cannot otherwise exclude documents in the recycle bin.regards,Tony
