Skip to content

Instantly share code, notes, and snippets.

@fintanmm
Created December 14, 2016 16:06
Show Gist options
  • Save fintanmm/abf274fb8d6efed6a3b2c352fa7e494c to your computer and use it in GitHub Desktop.
Save fintanmm/abf274fb8d6efed6a3b2c352fa7e494c to your computer and use it in GitHub Desktop.
List the models paths in Alfresco
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