Obtain the DQL of the corresponding format and template.

1. Format:

SELECT name, description FROM dm_format WHERE
Name IN
(Select distinct a_content_type FROM dm_sysobject WHERE
R_object_type = 'dm _ menu_system'AND I _has_folder = true and I _is_deleted = FALSE AND
ANY I _folder_id IN
(SELECT r_object_id FROM dm_folder WHERE
ANY I _ancestor_id in (select r_object_id from dm_sysobject where object_name = 'templates' and r_object_type = 'dm _ cabinet ')
) AND is_hidden = FALSE
Order by description, name

 

2. Template:

Select
R_object_id, object_name
From
Dm_sysobject
Where
R_object_type = 'dm _ menu_system'
AND
I _has_folder = TRUE
AND
I _is_deleted = FALSE
AND
A_content_type = 'crtext'
AND
ANY
I _folder_id IN
(SELECT r_object_id FROM dm_folder WHERE
ANY I _ancestor_id in (select r_object_id from dm_sysobject where object_name = 'templates' and r_object_type = 'dm _ cabinet ')
)