Oracle SQL to copy items from a collection to a folder

[CherylAnderton]

Does anyone know how to copy items from a collection to another folder? Similar to:

insert into collections (collectionid, dataid) values (132614881,130121674);

Cheryl Anderton

 

[appnair]

You need to use a API if you have WR it is very easy otherwise in SOAP it will be like

CopyNode(130121674,<DataiD Of Folder>,"whatver more you want to do with the copy");

LL does not have a easily data manipulatable SQL tool the closets like DCTM DQL is WR

Not sure but I also think if you open a collection may be you can use that standards move/copy to get it over

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937
Certified OT Developer,Livelink ECM Champion 2008,Livelink ECM Champion 2010

http://www.tek-tips.com/faqs.cfm?fid=2884

http://www.linkedin.com/in/appunair

http://www.livelink.in

 

[CherylAnderton]

Thank you!!!