Created
December 14, 2016 16:06
-
-
Save fintanmm/abf274fb8d6efed6a3b2c352fa7e494c to your computer and use it in GitHub Desktop.
List the models paths in Alfresco
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
select alf_content_url.content_url | |
from alf_node | |
left join alf_qname on alf_node.type_qname_id = alf_qname.id | |
left join alf_node_properties on alf_node_properties.node_id = alf_node.id | |
join alf_content_data on alf_content_data.id = alf_node_properties.long_value | |
left join alf_content_url on alf_content_url.id = alf_content_data.content_url_id | |
where | |
alf_qname.local_name = 'dictionaryModel' | |
and alf_content_url.content_url is not null |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment