Hi,
We need DQL to find out all custom jars [TBO/SBO/Other] available under repository. Normal query would be : select * from dmc_jar
but not able to differentiate between custom jars and default documentum jar definitions. Kindly help.
something like select r_object_id, object_name from dmc_jar(ALL) where any i_folder_id in (select r_object_id from dm_folder where any i_ancestor_id in (select r_object_id from dmc_module where object_name not like 'dm\_%' escape '\' and object_name not like 'dmc\_%' escape '\' and object_name not like 'dmi\_%' escape '\' and object_name not like 'com.emc.%' and object_name not like 'com.documentum.%' and primary_class not like 'com.emc.%' and primary_class not like 'com.documentum.%'))
