How can i retrieve all the documents which are inside the folder and virtual documents from a particular cabinet
select * from dm_document where folder('name of Folder')
?,c,select r_object_id from dm_document where any i_folder_id in(select r_object_id from dm_folder where object_name='<folder_name')
?,c,select r_object_id from dm_document where i_cabinet_id in(select r_object_id from dm_cabinet where object_name='<cabinet name>')
Thanks,
Anitha