SOLVED: SearchService and iso9075 problem

[shmoula]

Hi!
  I have following piece of code and it does very interesting things:

private Node getReportNode(Node noda) {      String path = noda.getPath();      path = path.replaceAll("\\{http://www.alfresco.org/model/application/1.0\\}", "app:");      path = path.replaceAll("\\{http://www.alfresco.org/model/content/1.0\\}", "cm:");      String query = "PATH:\"" + path + ".xml\"";      StoreRef storeRef = new StoreRef(StoreRef.PROTOCOL_WORKSPACE, "SpacesStore");      ResultSet resultSet = getSearchService().query(storeRef, SearchService.LANGUAGE_LUCENE, query);      for (ResultSetRow row : resultSet) {         Node foundNode = new Node(row.getNodeRef());         if (foundNode.hasAspect(ArchivaceModel.archProfileDescription))            return foundNode;      }            return null;   }‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

When I'm logged in as an Administrator, it works as expected. When I'm logged in as normal user, it does not work:

Unable to delete File due to system error: Failed to parse query: PATH:"/app:company_home/app:user_homes/{http://www.alfresco.org/model/system/1.0}xbalak00/cm:Profile/cm:kcab.png.xml"‍‍‍

So I found that I need to encode it as an ISO9075, I did:

String query = org.alfresco.util.ISO9075.encode("PATH:\"" + path + ".xml\"");‍‍‍

But it doesn't work, it finds nothing :-(. Where can be problem?

Thanks in advance!

[mikeh]

Try

String query = "PATH:\"" + org.alfresco.util.ISO9075.encode(path + ".xml") + "\"";‍

As you only need to encode the parameters.

Mike

[shmoula]

Hi, Mike, thanks for reply!
  I tried to encode parameters, as you wrote:

String query = "PATH:\"" + org.alfresco.util.ISO9075.encode(path + ".xml")   + "\"";‍

But it still doesn't work. Whole query now looks like this:

PATH:"_x002f_app_x003a_company_home_x002f_cm_x003a_Profile_x002f_cm_x003a_kcab.png.xml"‍

(note: that double extension - .png.xml is ok)

[mikeh]

Sorry, ignore the previous comment.

Change "{http://www.alfresco.org/model/system/1.0}" to "sys:" and try again.

Mike

[shmoula]

Heey, that's it!!! 🙂

path = path.replaceAll("\\{http://www.alfresco.org/model/system/1.0\\}", "sys:");‍

Many thanks, Mike! And before I click on yes on your profile I have to ask one more question: really don't I need to ISO9075.encode() anywhere?

[mikeh]

Technically, each part after the "cm:" or "app:" or "sys:" parts of the path should be run though the ISO9075.encode() function.

e.g. the Office Add-in webscripts when searching for tags or keywords:

searchString = search.ISO9075Encode(searchString);if (searchType == "tag"){   queryString = "PATH:\"/cm:categoryRoot/cm:taggable/cm:" + searchString + "/member\"";}else{   queryString = "(TEXT:\"" + searchString + "\") OR (@cm\\:name:*" + searchString + "*)";}‍‍‍‍‍‍‍‍‍‍‍

Thanks,
Mike

[shmoula]

Ok, I'll  experiment with that, now it works, thank you!