how to retry Repository path location starting form content_url

[peodrom]

Hi to all,

using Alfresco DB I should retry information about the path in repository starting from content_url

for example if I have "store://2016/2/26/9/52/14cd3e4d-82dc-4de5-b7a0-05ebec18e53d.bin" i like to know that for Alfresco it is in
"Repository> Sites> my-site> my-folder> my-subfolder"


thanks

[gravitonian]

To resolve the display path do something like this:

NodeRef nodeRef = new NodeRef(StoreRef.STORE_REF_WORKSPACE_SPACESSTORE, "14cd3e4d-82dc-4de5-b7a0-05ebec18e53d");
NodeService ns = serviceRegistry.getNodeService();
PermissionService ps = serviceRegistry.getPermissionService();
String nodePath = ns.getPath(nodeRef).toDisplayPath(ns, ps);
String nodeName = (String)ns.getProperty(nodeRef, ContentModel.PROP_NAME);
String nodeLocation = nodePath + "/" + nodeName;
‍‍‍‍‍‍‍‍

This assumes that the node is located in the workspace://SpacesStore (live content).

Note that "Repository> Sites> my-site> my-folder> my-subfolder", will resolve to Company Home/Sites/my-site/my-folder/my-subfolder. Company Home is the name of the top folder under the hood, not Repository.

[peodrom]

thanks Gravitonian, i will try this way.
do you know if there is also a sql query that can manage this point?

[gravitonian]

Hi,

There is probably a way to do this via SQL. However, it is not supported to access the database directly. Also, the schema can change and your code would then break.