Sql quey to get only folder names

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

arroju_srikanth

Hello All
Im  generating the reports through pentaho
i require to get only folder names list through sql query not the document names

CREATE ALGORITHM=UNDEFINED DEFINER=`alfresco`@`localhost` SQL SECURITY DEFINER VIEW `ZKT_VIEWSUBFOLDER` AS select `alf_node`.`id` AS `node_id`,`alf_node_properties`.`string_value` AS `sub_folder_name` from (`alf_node_properties` join `alf_node` on(((`alf_node_properties`.`node_id` = `alf_node`.`id`) and (`alf_node_properties`.`qname_id` = 280))));
‍‍‍

CREATE ALGORITHM=UNDEFINED DEFINER=`alfresco`@`localhost` SQL SECURITY DEFINER VIEW `ZKT_VIEWSUBFOLDER2` AS select `ZKT_VIEWSUBFOLDER`.`node_id` AS `node_id`,`alf_node_properties`.`string_value` AS `folder`,substring_index(substring_index(substring_index(`ZKT_VIEWSUBFOLDER`.`sub_folder_name`,'|',-(2)),',',-(1)),'|',1) AS `name` from (`ZKT_VIEWSUBFOLDER` join `alf_node_properties` on(((`alf_node_properties`.`node_id` = `ZKT_VIEWSUBFOLDER`.`node_id`) and (`alf_node_properties`.`qname_id` = 280))));
‍‍‍

but wth this query im also getting document names. and some names which doesn' t have .extension are also in the
result.
is there any other way of getting folder names in sql
Thanks,
Srikanth A

mikeh

I strongly recommend you do NOT try to query the private data structures of the Alfresco database and instead use one of the many public APIs available.

Thanks,
Mike