DQL query for folder name greater than 128 chars

Hi ..i am supporting documtnum webtop...my query is realted to DQL..

the question is like "How to find folder name length greate than 128 chars in webtop..i want dql query for that above question

Thanks Ravi

Find more posts tagged with

Comments

kravisankar

Please reply above question it is little urgest

jsilver

Discussion has been moved to the Documentum Community. The ECN Help forum is for questions about using the EMC Community site. Please post product specific questions to the appropriate product or support community.

KSMatson

Try this

select r_object_id, object_name from dm_folder where object_name in (select object_name from dm_folder where object_name not in (select substr(object_name, 1, 129) from dm_folder));

Cheers

kravisankar

Thank you so much ..above query worked....onemore question is like " how to find

'A list of folder locations (with paths) who’s path name to the folder exceeds 200 chars"...please suggest the query

Thanks for your help

DCTM_Guru

Just change the max numeric value in the query. Its not rocket science

KSMatson

If I understand you correctly, this query will give you the folder name along with the folder path that are greater than 200 characters, this query compliments the query provided in the earlier post by excluding the folder names with length greater than 128 characters.

select fr1.r_object_id, s1.object_name as folder_name, fr1.r_folder_path 
from dm_folder_r fr1, dm_sysobject_s s1
where fr1.r_object_id = s1.r_object_id
and fr1.r_object_id not in (select fr2.r_object_id from dm_folder_r fr2 
where fr2.r_folder_path in (select substr(fr3.r_folder_path, 1, 201) from dm_folder_r fr3)) 
and fr1.r_folder_path is not nullstring 
and s1.object_name not in (select s2.object_name from dm_sysobject_s s2 
where s2.object_name not in (select substr(s3.object_name, 1, 129) from dm_sysobject s3))
enable(row_based);

Cheers

kravisankar

Hi Sultan,

Thanks...in above query not execueting it saying illegel hint enable (rowbased).but iw ill try with out that but not abl to get the required deatils........is there any other process.

Thankas for your help.

Regrds

Ravi

DCTM_Guru

You can always use SQL (Instead DQL) statement to get the results. This way you can use native string functions that are available for your database.