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
Does LL support using UPDATE statements?
Michael_Lipton_(intria01user4_-_(deleted))
Quick question: Does Livelink 8.1.5 (or any version) support using UPDATE SQL statements to modify the database? If so, could you provide a small example?I've been trying to get a few things working to make administration easier using UPDATE statements, but they don't seem to do anything. They don't return an error, per se, but they return "No results found." and make no changes to the objects I want changed.Thanks!
Find more posts tagged with
Comments
eLink User
Message from David Slimmon via eLinkHi there,I assume you're referring specifically to database updates made throughLivereports, correct? If so, yes...you can update your Livelink databasethrough SQL statements in a Livereport, but it requires that you check thebox in the Add: Livereport page for "Allow Database Modification". Withoutthis checkbox being checked, your Livereports can and will not update thedatabase.Now, because it is possible to use a Livereport to remove items from thedatabase, it is very important that you use this feature carefully. Pleasebe careful about what SQL you pass to the Livereport and which users areallowed access to run/modify the Livereport.Regards,Dave-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: Tuesday, July 04, 2000 2:51 PMTo: eLink RecipientSubject: Does LL support using UPDATE statements?Does LL support using UPDATE statements?Posted by I-HPUser4 on 07/04/2000 03:46 PMQuick question: Does Livelink 8.1.5 (or any version) support using UPDATESQL statements to modify the database? If so, could you provide a smallexample?I've been trying to get a few things working to make administration easierusing UPDATE statements, but they don't seem to do anything. They don'treturn an error, per se, but they return "No results found." and make nochanges to the objects I want changed.Thanks![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
Michael_Pate_(aflacadmin_-_(deleted))
Here's a sample of a query I set up for a group of users I do not want to grant administrator access, but they need to share ownership of groups they create. As long as they create the group with the "CS" prefix, the other users can run the report. It is a bit of a kludge, but it works and these power users were delighted to be able to share ownership of a group in this manner. I have created 3 such queries for the CS groups, changing only the OWNERID.update KUAF set OWNERID = '6900' where type = 1 and Name Like "CS%%"
Liz_Connors_(sunvalleyfoodadmin_-_(deleted))
It does if you set the databse modification tickbox on the LiveReport's definition page, you may get a no results found message as there is nothing to return from the query.
Michael_Lipton_(intria01user4_-_(deleted))
Ok, ensuring that Allow Database Modifications works (thanks everyone for that).Now here's another question: Can I use an Update statement to change the ownership of an object? If so, how do I do it, and on which tables do I find who is the owner of the object?
Liz_Connors_(sunvalleyfoodadmin_-_(deleted))
Values are :DTREE.CREATEDBY - object creatorDTREE.USERID - current ownerjust change these to be the KUAF.ID value of the required user and it all pulls through.All in the schema.
John_Palesis_(pmuser4_-_(deleted))
Hi David,Is it possible to delete documents from database thru livereport using 'delete' function in sql?this is in reference to your earlier response"Now, because it is possible to use a Livereport to remove items from the database, it is very important that you use this feature carefully. Please be careful about what SQL you pass to the Livereport and which users are allowed access to run/modify the Livereport"Any help is appreciated. Thank you.
eLink User
Message from David Slimmon via eLinkHi there,Yes you can perform SQL DELETE operations through LiveReports. I just triedthis on the Livelink 9 database on my laptop. Here's what I did:1. I added a document to the Enterprise Workspace called "test.txt".2. I made sure that it was successfully added to the Enterprise Workspace3. I created a LiveReport that contains the following SQL statement:delete from dtree where name='test.txt'4. In the LiveReport, I made sure that I checked the checkbox for "AllowDatabase Modification:"5. The next time you run that report, it will delete anything in the DTreetable called 'text.txt'.Works like a charm.Cheers,Dave___________________________________________O P E N T E X T C O R P O R A T I O NDavid Slimmon, M.L.I.S.Supervisor - iRIMS Customer SupportOttawa, Canada
https://knowledge.opentext.comdslimmon@opentext.com-----Original
Message-----Hi David,Is it possible to delete documents from database thru livereport using'delete' function in sql?this is in reference to your earlier response"Now, because it is possible to use a Livereport to remove items from thedatabase, it is very important that you use this feature carefully. Pleasebe careful about what SQL you pass to the Livereport and which users areallowed access to run/modify the Livereport"Any help is appreciated. Thank you.
eLink User
Message from Bax Ruud, F.C. via eLinkL.s.Doesn't this interfere with the integrity of the database ?!I guess it only deletes the entry in dtree and not related entries, ie ACL,in other tables.Kind regards,Ruud> -----Oorspronkelijk bericht-----> Van: eLink Discussion: Livelink LiveReports Discussion> [SMTP:livereportsdiscussion@elinkkc.opentext.com]> Verzonden: dinsdag 13 februari 2001 19:58> Aan: eLink Recipient> Onderwerp: RE Does LL support using UPDATE statements? > > RE Does LL support using UPDATE statements? > Posted by eLink on 02/13/2001 01:57 PM> > Message from David Slimmon via eLink> > Hi there,> > Yes you can perform SQL DELETE operations through LiveReports. I just> tried> this on the Livelink 9 database on my laptop. Here's what I did:> > 1. I added a document to the Enterprise Workspace called "test.txt".> 2. I made sure that it was successfully added to the Enterprise Workspace> 3. I created a LiveReport that contains the following SQL statement:> > delete from dtree where name='test.txt'> > 4. In the LiveReport, I made sure that I checked the checkbox for "Allow> Database Modification:"> 5. The next time you run that report, it will delete anything in the DTree> table called 'text.txt'.> > Works like a charm.> > Cheers,> Dave> > > ___________________________________________> O P E N T E X T C O R P O R A T I O N> David Slimmon, M.L.I.S.> Supervisor - iRIMS Customer Support> Ottawa, Canada>
https://knowledge.opentext.com>
; dslimmon@opentext.com> > -----Original Message-----> > Hi David,> > Is it possible to delete documents from database thru livereport using> 'delete' function in sql?> > this is in reference to your earlier response> > "Now, because it is possible to use a Livereport to remove items from the> database, it is very important that you use this feature carefully. Please> be careful about what SQL you pass to the Livereport and which users are> allowed access to run/modify the Livereport"> > Any help is appreciated. Thank you.> > [To reply to this thread, use your normal e-mail reply function.]> > ============================================================> > Topic: Does LL support using UPDATE statements?>
https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=230949>
; 1&objAction=view> > Discussion: Livelink LiveReports Discussion>
https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=224967>
; 7&objAction=view> > Livelink Server:>
https://knowledge.opentext.com/knowledge/livelink.exe>
; >
eLink User
Message from David Slimmon via eLinkYour point is a good one - but I only used the simple example of delete *from dtree where name='test.txt' to show that one can perform databaseupdates through LiveReports, that's all. It wasn't meant to be an exampleof a LiveReport that people should use, but one that shows that Livelinkobjects can be deleted through LiveReports.Make sense?ds___________________________________________O P E N T E X T C O R P O R A T I O NDavid Slimmon, M.L.I.S.Supervisor - iRIMS Customer SupportOttawa, Canada
https://knowledge.opentext.comdslimmon@opentext.com-----Original
Message-----From: knowledge@opentext.com [mailto:knowledge@opentext.com]On Behalf OfeLink Discussion: Livelink LiveReports DiscussionSent: Wednesday, February 14, 2001 2:02 AMTo: eLink RecipientSubject: RE RE Does LL support using UPDATE statements?RE RE Does LL support using UPDATE statements?Posted by eLink on 02/14/2001 02:02 AMMessage from Bax Ruud, F.C. via eLinkL.s.Doesn't this interfere with the integrity of the database ?!I guess it only deletes the entry in dtree and not related entries, ie ACL,in other tables.Kind regards,Ruud> -----Oorspronkelijk bericht-----> Van: eLink Discussion: Livelink LiveReports Discussion> [SMTP:livereportsdiscussion@elinkkc.opentext.com]> Verzonden: dinsdag 13 februari 2001 19:58> Aan: eLink Recipient> Onderwerp: RE Does LL support using UPDATE statements?>> RE Does LL support using UPDATE statements?> Posted by eLink on 02/13/2001 01:57 PM>> Message from David Slimmon via eLink>> Hi there,>> Yes you can perform SQL DELETE operations through LiveReports. I just> tried> this on the Livelink 9 database on my laptop. Here's what I did:>> 1. I added a document to the Enterprise Workspace called "test.txt".> 2. I made sure that it was successfully added to the Enterprise Workspace> 3. I created a LiveReport that contains the following SQL statement:>> delete from dtree where name='test.txt'>> 4. In the LiveReport, I made sure that I checked the checkbox for "Allow> Database Modification:"> 5. The next time you run that report, it will delete anything in the DTree> table called 'text.txt'.>> Works like a charm.>> Cheers,> Dave>>> ___________________________________________> O P E N T E X T C O R P O R A T I O N> David Slimmon, M.L.I.S.> Supervisor - iRIMS Customer Support> Ottawa, Canada>
https://knowledge.opentext.com>
; dslimmon@opentext.com>> -----Original Message----->> Hi David,>> Is it possible to delete documents from database thru livereport using> 'delete' function in sql?>> this is in reference to your earlier response>> "Now, because it is possible to use a Livereport to remove items from the> database, it is very important that you use this feature carefully. Please> be careful about what SQL you pass to the Livereport and which users are> allowed access to run/modify the Livereport">> Any help is appreciated. Thank you.>> [To reply to this thread, use your normal e-mail reply function.]>> ============================================================>> Topic: Does LL support using UPDATE statements?>
https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=230949>
; 1&objAction=view>> Discussion: Livelink LiveReports Discussion>
https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=224967>
; 7&objAction=view>> Livelink Server:>
https://knowledge.opentext.com/knowledge/livelink.exe>>[To
reply to this thread, use your normal e-mail reply function.]============================================================Topic: Does LL support using UPDATE statements?
https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2309491&objAction=viewDiscussion
: Livelink LiveReports Discussion
https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink
Server:
https://knowledge.opentext.com/knowledge/livelink.exe
Robert_Davies_(unlondonadmin_-_(deleted))
If you want an update statement to work you have to tick the box that allows you to use the Livereport for update.With regard to the 'no results found' - this is a misleading message. To give you an example I needed to undelete a User the other day, I wrote the SQl that selected the correct User, then adapted this to 'Update' the record as well as checking the box that allows a LiveReport to update the database, I got 'no results found' when I ran this. When I did another report to look at the data I found that the required field had been updated i.e. the message was completely misleading. Hope this helps.Anne Callanan
eLink User
Message from Alex Kowalenko via eLinkAlthough you can change the database with LiveReports I would not useLiveReports to delete a document because:1. Selecting from DTree by name will select ALL entries of that name, notjust documents and not just the one document with that name.2. The related table entries are not deleted or otherwise updated... forexample DTreeACL, DVersData and ProviderData. This will result in databaseintegrity errors.3. The document files (stored in BlobData if internal or stored in a filesystem with the name from ProviderData if external) are not deleted.To do it properly you would have to execute a series of SQL commands. Thiscould be done through a LiveReport and is not a trivial task.My question is why you would want to use a LiveReport to delete documents?Alex KowalenkoSenior Consultant - Open Text Professional Services-----Original Message-----From: knowledge@opentext.com [mailto:knowledge@opentext.com]On Behalf OfeLink Discussion: Livelink LiveReports DiscussionSent: Tuesday, February 13, 2001 1:58 PMTo: eLink RecipientSubject: RE Does LL support using UPDATE statements?RE Does LL support using UPDATE statements?Posted by eLink on 02/13/2001 01:57 PMMessage from David Slimmon via eLinkHi there,Yes you can perform SQL DELETE operations through LiveReports. I just triedthis on the Livelink 9 database on my laptop. Here's what I did:1. I added a document to the Enterprise Workspace called "test.txt".2. I made sure that it was successfully added to the Enterprise Workspace3. I created a LiveReport that contains the following SQL statement:delete from dtree where name='test.txt'4. In the LiveReport, I made sure that I checked the checkbox for "AllowDatabase Modification:"5. The next time you run that report, it will delete anything in the DTreetable called 'text.txt'.Works like a charm.Cheers,Dave___________________________________________O P E N T E X T C O R P O R A T I O NDavid Slimmon, M.L.I.S.Supervisor - iRIMS Customer SupportOttawa, Canada
https://knowledge.opentext.comdslimmon@opentext.com-----Original
Message-----Hi David,Is it possible to delete documents from database thru livereport using'delete' function in sql?this is in reference to your earlier response"Now, because it is possible to use a Livereport to remove items from thedatabase, it is very important that you use this feature carefully. Pleasebe careful about what SQL you pass to the Livereport and which users areallowed access to run/modify the Livereport"Any help is appreciated. Thank you.[To reply to this thread, use your normal e-mail reply function.]============================================================Topic: Does LL support using UPDATE statements?
https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2309491&objAction=viewDiscussion
: Livelink LiveReports Discussion
https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink
Server:
https://knowledge.opentext.com/knowledge/livelink.exe
eLink User
Message from David Slimmon via eLinkYes! I am in 100% agreement with you Alex.My point about showing others that database deletions 'can' be done with aLiveReport should not take away from the fact that we really would notrecommend this! This whole thread highlights the difference betweensomething that *can* be done in Livelink versus something that *should* bedone in Livelink.Just because you can do it, doesn't mean that you should. In other words,BE CAREFUL with the "Allow Database Modification" checkbox people :)Cheers,Dave-----Original Message-----Message from Alex Kowalenko via eLinkAlthough you can change the database with LiveReports I would not useLiveReports to delete a document because:1. Selecting from DTree by name will select ALL entries of that name, notjust documents and not just the one document with that name.2. The related table entries are not deleted or otherwise updated... forexample DTreeACL, DVersData and ProviderData. This will result in databaseintegrity errors.3. The document files (stored in BlobData if internal or stored in a filesystem with the name from ProviderData if external) are not deleted.To do it properly you would have to execute a series of SQL commands. Thiscould be done through a LiveReport and is not a trivial task.My question is why you would want to use a LiveReport to delete documents?Alex Kowalenko
eLink User
Message from Kamalapuri, Ramani via eLinkThanks everybody for timely responsesAlex, this is in response to your question The question was - why would I want to use a LiveReport to delete documents?We are using Livelink 8.1.5 to store our company wide records. We need todispose the records when they reach their disposal dates based on theirretention periods. I created a livereport which gives me all the records,which have reached their retention limits. Our coordinator has to deletethem from the system. It is very difficult for the coordinator to go to thefunction menu of each record and delete them. I tried to display ' Delete 'button as an 'Action Item' in LiveReport. But it doesn't work! (it is a bugin Livelink). So I was looking for different options. We are not going touse Livelink 9 for this system. Ramani KamalapuriPMUSA - Information ServicesPh: (804) 698-6678> -----Original Message-----> From: eLink Discussion: Livelink LiveReports Discussion> [SMTP:livereportsdiscussion@elinkkc.opentext.com]> Sent: Wednesday, February 14, 2001 9:52 AM> To: eLink Recipient> Subject: RE RE Does LL support using UPDATE statements? 2> > RE RE Does LL support using UPDATE statements? 2> Posted by eLink on 02/14/2001 09:52 AM> > Message from Alex Kowalenko via eLink> > Although you can change the database with LiveReports I would not use> LiveReports to delete a document because:> > 1. Selecting from DTree by name will select ALL entries of that name, not> just documents and not just the one document with that name.> 2. The related table entries are not deleted or otherwise updated... for> example DTreeACL, DVersData and ProviderData. This will result in database> integrity errors.> 3. The document files (stored in BlobData if internal or stored in a file> system with the name from ProviderData if external) are not deleted.> > To do it properly you would have to execute a series of SQL commands. This> could be done through a LiveReport and is not a trivial task.> > My question is why you would want to use a LiveReport to delete documents?> > Alex Kowalenko> Senior Consultant - Open Text Professional Services> > -----Original Message-----> From: knowledge@opentext.com [mailto:knowledge@opentext.com]On Behalf Of> eLink Discussion: Livelink LiveReports Discussion> Sent: Tuesday, February 13, 2001 1:58 PM> To: eLink Recipient> Subject: RE Does LL support using UPDATE statements?> > > RE Does LL support using UPDATE statements?> Posted by eLink on 02/13/2001 01:57 PM> > Message from David Slimmon via eLink> > Hi there,> > Yes you can perform SQL DELETE operations through LiveReports. I just> tried> this on the Livelink 9 database on my laptop. Here's what I did:> > 1. I added a document to the Enterprise Workspace called "test.txt".> 2. I made sure that it was successfully added to the Enterprise Workspace> 3. I created a LiveReport that contains the following SQL statement:> > delete from dtree where name='test.txt'> > 4. In the LiveReport, I made sure that I checked the checkbox for "Allow> Database Modification:"> 5. The next time you run that report, it will delete anything in the DTree> table called 'text.txt'.> > Works like a charm.> > Cheers,> Dave> > > ___________________________________________> O P E N T E X T C O R P O R A T I O N> David Slimmon, M.L.I.S.> Supervisor - iRIMS Customer Support> Ottawa, Canada>
https://knowledge.opentext.com>
; dslimmon@opentext.com> > -----Original Message-----> > Hi David,> > Is it possible to delete documents from database thru livereport using> 'delete' function in sql?> > this is in reference to your earlier response> > "Now, because it is possible to use a Livereport to remove items from the> database, it is very important that you use this feature carefully. Please> be careful about what SQL you pass to the Livereport and which users are> allowed access to run/modify the Livereport"> > Any help is appreciated. Thank you.> > [To reply to this thread, use your normal e-mail reply function.]> > ============================================================> > Topic: Does LL support using UPDATE statements?>
https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=230949>
; 1&> objAction=view> > Discussion: Livelink LiveReports Discussion>
https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=224967>
; 7&> objAction=view> > Livelink Server:>
https://knowledge.opentext.com/knowledge/livelink.exe>
; > [To reply to this thread, use your normal e-mail reply function.]> > ============================================================> > Topic: Does LL support using UPDATE statements?>
https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=230949>
; 1&objAction=view> > Discussion: Livelink LiveReports Discussion>
https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=224967>
; 7&objAction=view> > Livelink Server:>
https://knowledge.opentext.com/knowledge/livelink.exe>
; >
eLink User
Message from Sean M Alderman via eLinkSpeaking of modifying the database via a livereport...We have recently had to set the system wide version limit for new documents to 5. The side effect of this is that for all existing documents this setting does not apply.We had planned to create a live report to do something like -update dtree set maxvers = 5 where subtype = 144 and maxvers <= 5which should select all dtree items that are Documents and set the maximum version limit to 5. We know that this does not delete existing versions through some testing we have done, so we'll still have to manually purge documents with versions greater than 5.Does anyone see any bad things happening from this?At 10:14 AM 02/14/2001 -0500, you (eLink Discussion: Livelink LiveReports Discussion) wrote:>RE RE RE Does LL support using UPDATE statements? 2>Posted by eLink on 02/14/2001 10:14 AM>>Message from David Slimmon via eLink>>Yes! I am in 100% agreement with you Alex.>>My point about showing others that database deletions 'can' be done with a>LiveReport should not take away from the fact that we really would not>recommend this! This whole thread highlights the difference between>something that *can* be done in Livelink versus something that *should* be>done in Livelink.>>Just because you can do it, doesn't mean that you should. In other words,>BE CAREFUL with the "Allow Database Modification" checkbox people
>>Cheers,>Dave>>-----Original Message----->>Message from Alex Kowalenko via eLink>>Although you can change the database with LiveReports I would not use>LiveReports to delete a document because:>>1. Selecting from DTree by name will select ALL entries of that name, not>just documents and not just the one document with that name.>>2. The related table entries are not deleted or otherwise updated... for>example DTreeACL, DVersData and ProviderData. This will result in database>integrity errors.>>3. The document files (stored in BlobData if internal or stored in a file>system with the name from ProviderData if external) are not deleted.>>To do it properly you would have to execute a series of SQL commands. This>could be done through a LiveReport and is not a trivial task.>>My question is why you would want to use a LiveReport to delete documents?>>Alex Kowalenko>>[To reply to this thread, use your normal e-mail reply function.]>>============================================================>>Topic: Does LL support using UPDATE statements?>
https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2309491&objAction=view>>Discussion
: Livelink LiveReports Discussion>
https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=view>>Livelink
Server:>
https://knowledge.opentext.com/knowledge/livelink.exe-
Sean M. AldermanVCIM Senior Systems AnalystNASA Glenn Research CenterCleveland, OH 44135(216) 433-2795
eLink User
Message from Alex Kowalenko via eLinkRamani, If that's what you want to do then I would suggest the following...Instead of deleting the documents why not move them to a special "** To BeDeleted **" folder. Then the folder can be deleted in its entirety in oneoperation or you can keep it in case you want to restore a document.In Livelink a "move" is really a change in the parent dataid with somepermission updates. Create a "Auto LiveReport" to list documents to bedeleted and then create a subreport to do the move without permissionupdates as:update dtree set parentid = where dataid =where can be the actual id number orcan be a subselect: (select dataid from dtree where name = '** To Be Deleted**' and subtype = 0)-alex------Original Message-----From: knowledge@opentext.com [mailto:knowledge@opentext.com]On Behalf OfeLink Discussion: Livelink LiveReports DiscussionSent: Wednesday, February 14, 2001 10:46 AMTo: eLink RecipientSubject: RE RE RE Does LL support using UPDATE statements? 2 2RE RE RE Does LL support using UPDATE statements? 2 2Posted by eLink on 02/14/2001 10:45 AMMessage from Kamalapuri, Ramani via eLinkThanks everybody for timely responsesAlex, this is in response to your questionThe question was - why would I want to use a LiveReport to delete documents?We are using Livelink 8.1.5 to store our company wide records. We need todispose the records when they reach their disposal dates based on theirretention periods. I created a livereport which gives me all the records,which have reached their retention limits. Our coordinator has to deletethem from the system. It is very difficult for the coordinator to go to thefunction menu of each record and delete them. I tried to display ' Delete 'button as an 'Action Item' in LiveReport. But it doesn't work! (it is a bugin Livelink). So I was looking for different options. We are not going touse Livelink 9 for this system.Ramani KamalapuriPMUSA - Information ServicesPh: (804) 698-6678> -----Original Message-----> From: eLink Discussion: Livelink LiveReports Discussion> [SMTP:livereportsdiscussion@elinkkc.opentext.com]> Sent: Wednesday, February 14, 2001 9:52 AM> To: eLink Recipient> Subject: RE RE Does LL support using UPDATE statements? 2>> RE RE Does LL support using UPDATE statements? 2> Posted by eLink on 02/14/2001 09:52 AM>> Message from Alex Kowalenko via eLink>> Although you can change the database with LiveReports I would not use> LiveReports to delete a document because:>> 1. Selecting from DTree by name will select ALL entries of that name, not> just documents and not just the one document with that name.> 2. The related table entries are not deleted or otherwise updated... for> example DTreeACL, DVersData and ProviderData. This will result in database> integrity errors.> 3. The document files (stored in BlobData if internal or stored in a file> system with the name from ProviderData if external) are not deleted.>> To do it properly you would have to execute a series of SQL commands. This> could be done through a LiveReport and is not a trivial task.>> My question is why you would want to use a LiveReport to delete documents?>> Alex Kowalenko> Senior Consultant - Open Text Professional Services>> -----Original Message-----> From: knowledge@opentext.com [mailto:knowledge@opentext.com]On Behalf Of> eLink Discussion: Livelink LiveReports Discussion> Sent: Tuesday, February 13, 2001 1:58 PM> To: eLink Recipient> Subject: RE Does LL support using UPDATE statements?>>> RE Does LL support using UPDATE statements?> Posted by eLink on 02/13/2001 01:57 PM>> Message from David Slimmon via eLink>> Hi there,>> Yes you can perform SQL DELETE operations through LiveReports. I just> tried> this on the Livelink 9 database on my laptop. Here's what I did:>> 1. I added a document to the Enterprise Workspace called "test.txt".> 2. I made sure that it was successfully added to the Enterprise Workspace> 3. I created a LiveReport that contains the following SQL statement:>> delete from dtree where name='test.txt'>> 4. In the LiveReport, I made sure that I checked the checkbox for "Allow> Database Modification:"> 5. The next time you run that report, it will delete anything in the DTree> table called 'text.txt'.>> Works like a charm.>> Cheers,> Dave>>> ___________________________________________> O P E N T E X T C O R P O R A T I O N> David Slimmon, M.L.I.S.> Supervisor - iRIMS Customer Support> Ottawa, Canada>
https://knowledge.opentext.com>
; dslimmon@opentext.com>> -----Original Message----->> Hi David,>> Is it possible to delete documents from database thru livereport using> 'delete' function in sql?>> this is in reference to your earlier response>> "Now, because it is possible to use a Livereport to remove items from the> database, it is very important that you use this feature carefully. Please> be careful about what SQL you pass to the Livereport and which users are> allowed access to run/modify the Livereport">> Any help is appreciated. Thank you.>> [To reply to this thread, use your normal e-mail reply function.]>> ============================================================>> Topic: Does LL support using UPDATE statements?>
https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=230949>
; 1&> objAction=view>> Discussion: Livelink LiveReports Discussion>
https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=224967>
; 7&> objAction=view>> Livelink Server:>
https://knowledge.opentext.com/knowledge/livelink.exe>>
; [To reply to this thread, use your normal e-mail reply function.]>> ============================================================>> Topic: Does LL support using UPDATE statements?>
https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=230949>
; 1&objAction=view>> Discussion: Livelink LiveReports Discussion>
https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=224967>
; 7&objAction=view>> Livelink Server:>
https://knowledge.opentext.com/knowledge/livelink.exe>>[To
reply to this thread, use your normal e-mail reply function.]============================================================Topic: Does LL support using UPDATE statements?
https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2309491&objAction=viewDiscussion
: Livelink LiveReports Discussion
https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink
Server:
https://knowledge.opentext.com/knowledge/livelink.exe
eLink User
Message from Kamalapuri, Ramani via eLinkThank you Alex, I will try this out and stay tuned for further questions.Ramani KamalapuriPMUSA - Information ServicesPh: (804) 698-6678> -----Original Message-----> From: eLink Discussion: Livelink LiveReports Discussion> [SMTP:livereportsdiscussion@elinkkc.opentext.com]> Sent: Wednesday, February 14, 2001 11:16 AM> To: eLink Recipient> Subject: RE RE RE RE Does LL support using UPDATE statements? 2> 2> > RE RE RE RE Does LL support using UPDATE statements? 2 2> Posted by eLink on 02/14/2001 11:15 AM> > Message from Alex Kowalenko via eLink> > Ramani, If that's what you want to do then I would suggest the> following...> > Instead of deleting the documents why not move them to a special "** To Be> Deleted **" folder. Then the folder can be deleted in its entirety in one> operation or you can keep it in case you want to restore a document.> > In Livelink a "move" is really a change in the parent dataid with some> permission updates. Create a "Auto LiveReport" to list documents to be> deleted and then create a subreport to do the move without permission> updates as:> > update dtree set parentid = where dataid => > > where can be the actual id number or> can be a subselect: (select dataid from dtree where name = '** To Be> Deleted> **' and subtype = 0)> > -alex-> > -----Original Message-----> From: knowledge@opentext.com [mailto:knowledge@opentext.com]On Behalf Of> eLink Discussion: Livelink LiveReports Discussion> Sent: Wednesday, February 14, 2001 10:46 AM> To: eLink Recipient> Subject: RE RE RE Does LL support using UPDATE statements? 2 2> > > RE RE RE Does LL support using UPDATE statements? 2 2> Posted by eLink on 02/14/2001 10:45 AM> > Message from Kamalapuri, Ramani via eLink> > Thanks everybody for timely responses> > Alex, this is in response to your question> > The question was - why would I want to use a LiveReport to delete> documents?> > We are using Livelink 8.1.5 to store our company wide records. We need to> dispose the records when they reach their disposal dates based on their> retention periods. I created a livereport which gives me all the records,> which have reached their retention limits. Our coordinator has to delete> them from the system. It is very difficult for the coordinator to go to> the> function menu of each record and delete them. I tried to display ' Delete> '> button as an 'Action Item' in LiveReport. But it doesn't work! (it is a> bug> in Livelink). So I was looking for different options. We are not going to> use Livelink 9 for this system.> > > Ramani Kamalapuri> PMUSA - Information Services> Ph: (804) 698-6678> > > > > > > -----Original Message-----> > From: eLink Discussion: Livelink LiveReports Discussion> > [SMTP:livereportsdiscussion@elinkkc.opentext.com]> > Sent: Wednesday, February 14, 2001 9:52 AM> > To: eLink Recipient> > Subject: RE RE Does LL support using UPDATE statements? 2> >> > RE RE Does LL support using UPDATE statements? 2> > Posted by eLink on 02/14/2001 09:52 AM> >> > Message from Alex Kowalenko via eLink> >> > Although you can change the database with LiveReports I would not use> > LiveReports to delete a document because:> >> > 1. Selecting from DTree by name will select ALL entries of that name,> not> > just documents and not just the one document with that name.> > 2. The related table entries are not deleted or otherwise updated... for> > example DTreeACL, DVersData and ProviderData. This will result in> database> > integrity errors.> > 3. The document files (stored in BlobData if internal or stored in a> file> > system with the name from ProviderData if external) are not deleted.> >> > To do it properly you would have to execute a series of SQL commands.> This> > could be done through a LiveReport and is not a trivial task.> >> > My question is why you would want to use a LiveReport to delete> documents?> >> > Alex Kowalenko> > Senior Consultant - Open Text Professional Services> >> > -----Original Message-----> > From: knowledge@opentext.com [mailto:knowledge@opentext.com]On Behalf Of> > eLink Discussion: Livelink LiveReports Discussion> > Sent: Tuesday, February 13, 2001 1:58 PM> > To: eLink Recipient> > Subject: RE Does LL support using UPDATE statements?> >> >> > RE Does LL support using UPDATE statements?> > Posted by eLink on 02/13/2001 01:57 PM> >> > Message from David Slimmon via eLink> >> > Hi there,> >> > Yes you can perform SQL DELETE operations through LiveReports. I just> > tried> > this on the Livelink 9 database on my laptop. Here's what I did:> >> > 1. I added a document to the Enterprise Workspace called "test.txt".> > 2. I made sure that it was successfully added to the Enterprise> Workspace> > 3. I created a LiveReport that contains the following SQL statement:> >> > delete from dtree where name='test.txt'> >> > 4. In the LiveReport, I made sure that I checked the checkbox for "Allow> > Database Modification:"> > 5. The next time you run that report, it will delete anything in the> DTree> > table called 'text.txt'.> >> > Works like a charm.> >> > Cheers,> > Dave> >> >> > ___________________________________________> > O P E N T E X T C O R P O R A T I O N> > David Slimmon, M.L.I.S.> > Supervisor - iRIMS Customer Support> > Ottawa, Canada> >
https://knowledge.opentext.com>
; > dslimmon@opentext.com> >> > -----Original Message-----> >> > Hi David,> >> > Is it possible to delete documents from database thru livereport using> > 'delete' function in sql?> >> > this is in reference to your earlier response> >> > "Now, because it is possible to use a Livereport to remove items from> the> > database, it is very important that you use this feature carefully.> Please> > be careful about what SQL you pass to the Livereport and which users are> > allowed access to run/modify the Livereport"> >> > Any help is appreciated. Thank you.> >> > [To reply to this thread, use your normal e-mail reply function.]> >> > ============================================================> >> > Topic: Does LL support using UPDATE statements?> >>
https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=230949>
; > 1&> > objAction=view> >> > Discussion: Livelink LiveReports Discussion> >>
https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=224967>
; > 7&> > objAction=view> >> > Livelink Server:> >
https://knowledge.opentext.com/knowledge/livelink.exe>
; >> > [To reply to this thread, use your normal e-mail reply function.]> >> > ============================================================> >> > Topic: Does LL support using UPDATE statements?> >>
https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=230949>
; > 1&objAction=view> >> > Discussion: Livelink LiveReports Discussion> >>
https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=224967>
; > 7&objAction=view> >> > Livelink Server:> >
https://knowledge.opentext.com/knowledge/livelink.exe>
; >> >> > [To reply to this thread, use your normal e-mail reply function.]> > ============================================================> > Topic: Does LL support using UPDATE statements?>
https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=230949>
; 1&> objAction=view> > Discussion: Livelink LiveReports Discussion>
https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=224967>
; 7&> objAction=view> > Livelink Server:>
https://knowledge.opentext.com/knowledge/livelink.exe>
; > [To reply to this thread, use your normal e-mail reply function.]> > ============================================================> > Topic: Does LL support using UPDATE statements?>
https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=230949>
; 1&objAction=view> > Discussion: Livelink LiveReports Discussion>
https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=224967>
; 7&objAction=view> > Livelink Server:>
https://knowledge.opentext.com/knowledge/livelink.exe>
; >
eLink User
Message from Alex Kowalenko via eLinkActually, it's not quite that simple I'm afraid. There are two other changesto make in the database to make this complete:1. The permissions entries' parents will also have to be changed: ie. changeDTreeACL.ParentID to the deleted folder DataID for all entries whereDTreeACL.DataID = DTree.DataID2. Child count for from and to folders will have to be changed: ie. changeDTree.ChildCount in both folders.-----Original Message-----From: knowledge@opentext.com [mailto:knowledge@opentext.com]On Behalf OfeLink Discussion: Livelink LiveReports DiscussionSent: Wednesday, February 14, 2001 12:41 PMTo: eLink RecipientSubject: RE RE RE RE RE Does LL support using UPDATE statements? 2 2RE RE RE RE RE Does LL support using UPDATE statements? 2 2Posted by eLink on 02/14/2001 12:40 PMMessage from Kamalapuri, Ramani via eLinkThank you Alex, I will try this out and stay tuned for further questions.Ramani KamalapuriPMUSA - Information ServicesPh: (804) 698-6678> -----Original Message-----> From: eLink Discussion: Livelink LiveReports Discussion> [SMTP:livereportsdiscussion@elinkkc.opentext.com]> Sent: Wednesday, February 14, 2001 11:16 AM> To: eLink Recipient> Subject: RE RE RE RE Does LL support using UPDATE statements? 2> 2>> RE RE RE RE Does LL support using UPDATE statements? 2 2> Posted by eLink on 02/14/2001 11:15 AM>> Message from Alex Kowalenko via eLink>> Ramani, If that's what you want to do then I would suggest the> following...>> Instead of deleting the documents why not move them to a special "** To Be> Deleted **" folder. Then the folder can be deleted in its entirety in one> operation or you can keep it in case you want to restore a document.>> In Livelink a "move" is really a change in the parent dataid with some> permission updates. Create a "Auto LiveReport" to list documents to be> deleted and then create a subreport to do the move without permission> updates as:>> update dtree set parentid = where dataid => >> where can be the actual id number or> can be a subselect: (select dataid from dtree where name = '** To Be> Deleted> **' and subtype = 0)>> -alex->> -----Original Message-----> From: knowledge@opentext.com [mailto:knowledge@opentext.com]On Behalf Of> eLink Discussion: Livelink LiveReports Discussion> Sent: Wednesday, February 14, 2001 10:46 AM> To: eLink Recipient> Subject: RE RE RE Does LL support using UPDATE statements? 2 2>>> RE RE RE Does LL support using UPDATE statements? 2 2> Posted by eLink on 02/14/2001 10:45 AM>> Message from Kamalapuri, Ramani via eLink>> Thanks everybody for timely responses>> Alex, this is in response to your question>> The question was - why would I want to use a LiveReport to delete> documents?>> We are using Livelink 8.1.5 to store our company wide records. We need to> dispose the records when they reach their disposal dates based on their> retention periods. I created a livereport which gives me all the records,> which have reached their retention limits. Our coordinator has to delete> them from the system. It is very difficult for the coordinator to go to> the> function menu of each record and delete them. I tried to display ' Delete> '> button as an 'Action Item' in LiveReport. But it doesn't work! (it is a> bug> in Livelink). So I was looking for different options. We are not going to> use Livelink 9 for this system.>>> Ramani Kamalapuri> PMUSA - Information Services> Ph: (804) 698-6678>>>>>> > -----Original Message-----> > From: eLink Discussion: Livelink LiveReports Discussion> > [SMTP:livereportsdiscussion@elinkkc.opentext.com]> > Sent: Wednesday, February 14, 2001 9:52 AM> > To: eLink Recipient> > Subject: RE RE Does LL support using UPDATE statements? 2> >> > RE RE Does LL support using UPDATE statements? 2> > Posted by eLink on 02/14/2001 09:52 AM> >> > Message from Alex Kowalenko via eLink> >> > Although you can change the database with LiveReports I would not use> > LiveReports to delete a document because:> >> > 1. Selecting from DTree by name will select ALL entries of that name,> not> > just documents and not just the one document with that name.> > 2. The related table entries are not deleted or otherwise updated... for> > example DTreeACL, DVersData and ProviderData. This will result in> database> > integrity errors.> > 3. The document files (stored in BlobData if internal or stored in a> file> > system with the name from ProviderData if external) are not deleted.> >> > To do it properly you would have to execute a series of SQL commands.> This> > could be done through a LiveReport and is not a trivial task.> >> > My question is why you would want to use a LiveReport to delete> documents?> >> > Alex Kowalenko> > Senior Consultant - Open Text Professional Services> >> > -----Original Message-----> > From: knowledge@opentext.com [mailto:knowledge@opentext.com]On Behalf Of> > eLink Discussion: Livelink LiveReports Discussion> > Sent: Tuesday, February 13, 2001 1:58 PM> > To: eLink Recipient> > Subject: RE Does LL support using UPDATE statements?> >> >> > RE Does LL support using UPDATE statements?> > Posted by eLink on 02/13/2001 01:57 PM> >> > Message from David Slimmon via eLink> >> > Hi there,> >> > Yes you can perform SQL DELETE operations through LiveReports. I just> > tried> > this on the Livelink 9 database on my laptop. Here's what I did:> >> > 1. I added a document to the Enterprise Workspace called "test.txt".> > 2. I made sure that it was successfully added to the Enterprise> Workspace> > 3. I created a LiveReport that contains the following SQL statement:> >> > delete from dtree where name='test.txt'> >> > 4. In the LiveReport, I made sure that I checked the checkbox for "Allow> > Database Modification:"> > 5. The next time you run that report, it will delete anything in the> DTree> > table called 'text.txt'.> >> > Works like a charm.> >> > Cheers,> > Dave> >> >> > ___________________________________________> > O P E N T E X T C O R P O R A T I O N> > David Slimmon, M.L.I.S.> > Supervisor - iRIMS Customer Support> > Ottawa, Canada> >
https://knowledge.opentext.com>
; > dslimmon@opentext.com> >> > -----Original Message-----> >> > Hi David,> >> > Is it possible to delete documents from database thru livereport using> > 'delete' function in sql?> >> > this is in reference to your earlier response> >> > "Now, because it is possible to use a Livereport to remove items from> the> > database, it is very important that you use this feature carefully.> Please> > be careful about what SQL you pass to the Livereport and which users are> > allowed access to run/modify the Livereport"> >> > Any help is appreciated. Thank you.> >> > [To reply to this thread, use your normal e-mail reply function.]> >> > ============================================================> >> > Topic: Does LL support using UPDATE statements?> >>
https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=230949>
; > 1&> > objAction=view> >> > Discussion: Livelink LiveReports Discussion> >>
https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=224967>
; > 7&> > objAction=view> >> > Livelink Server:> >
https://knowledge.opentext.com/knowledge/livelink.exe>
; >> > [To reply to this thread, use your normal e-mail reply function.]> >> > ============================================================> >> > Topic: Does LL support using UPDATE statements?> >>
https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=230949>
; > 1&objAction=view> >> > Discussion: Livelink LiveReports Discussion> >>
https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=224967>
; > 7&objAction=view> >> > Livelink Server:> >
https://knowledge.opentext.com/knowledge/livelink.exe>
; >> >>> [To reply to this thread, use your normal e-mail reply function.]>> ============================================================>> Topic: Does LL support using UPDATE statements?>
https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=230949>
; 1&> objAction=view>> Discussion: Livelink LiveReports Discussion>
https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=224967>
; 7&> objAction=view>> Livelink Server:>
https://knowledge.opentext.com/knowledge/livelink.exe>>
; [To reply to this thread, use your normal e-mail reply function.]>> ============================================================>> Topic: Does LL support using UPDATE statements?>
https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=230949>
; 1&objAction=view>> Discussion: Livelink LiveReports Discussion>
https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=224967>
; 7&objAction=view>> Livelink Server:>
https://knowledge.opentext.com/knowledge/livelink.exe>>[To
reply to this thread, use your normal e-mail reply function.]============================================================Topic: Does LL support using UPDATE statements?
https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2309491&objAction=viewDiscussion
: Livelink LiveReports Discussion
https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink
Server:
https://knowledge.opentext.com/knowledge/livelink.exe
Bax_Ruud
There is also the value rightid in dtreeacl which should be changed ! I forgot it once; the ownership seemed ok until the user tried to set permissions for other users.
