DQL:Finding all the noncurrent version of document and moving to current folder location

Dear All,

I have one requirement to find all the noncurrent version of the documents present in a particular folders and subfloders.

And then check if noncurrent version and current version presnet in the same folders or not. If noncurrent version is not present in the location of current version of document then i have to move to that location of current version document.

I have lot of documents . Could any one provide me any DQL to achive this.Thanks a lot inadvance

Find more posts tagged with

Comments

Viswa

To dispaly non-current versions of a document:

select * from dm_document (all) where folder('/<folder path>',descend) and any r_version_label <> ’CURRENT'

I guess you have to write a DFC program to implement your requiremnt

pramodbarik

Hi,

Thanks for your reply. I need some DQL to achive this .It is not allow to implement dfc in my Production envirinmnet as all my codes are freezeed.

DCTM_Guru

Your business logic includes IF condition. DQL cannot support this directly. You could try to write multiple DQL queries.