nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

Search querys problems [SOLVED]

rhakaro

Hi all again!

I have a new problem developing a query search in my Java code.

I´m seeking some contents in alfresco, but it returns to me empty, only with the "Path" property fill.

I´m doing this:

                ………….
                ………….

                Query query = new Query(Constants.QUERY_LANG_LUCENE, "PATH:\"/app:company_home/cm:my_folder//*\" + @cm\\:name:plantilla*");
         
           // Execute the query
           final Store STORE = new Store(Constants.WORKSPACE_STORE, "SpacesStore");
           QueryResult queryResult = repositoryService.query(STORE, query, false);
           
           // Display the results
           ResultSet results = queryResult.getResultSet();
           ResultSetRow[] rows = results.getRows();
           
           System.out.println("La busqueda da algo asi:");
           if(rows != null){
              for(ResultSetRow row : rows){
                                      for (NamedValue namedValue : row.getColumns()){
                                             if (namedValue.getName().endsWith("path") == true)
                                                        System.out.println(namedValue.getValue());
                                              if (namedValue.getName().endsWith(Constants.PROP_CREATED) == true)
                                                        System.out.println(namedValue.getValue());
                                              else if (namedValue.getName().endsWith(Constants.PROP_NAME) == true){
                                                        System.out.println(namedValue.getValue());
                                             else if (namedValue.getName().endsWith(Constants.PROP_DESCRIPTION) == true){
                                                        System.out.println(namedValue.getValue());
                                               
                                               ………….
                                               ………….
                                               ………….
}
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

The only result that doesn´t null is the "path" property.

What could be happen??

Thak you very much!

Find more posts tagged with

Comments

maqsood

try this @cm\\:name:\"plantilla*\" or @\\{http\\

/www.alfresco.org/model/content/1.0\\}name:\'plantilla*\"

rhakaro

Hi maqsood,

It still not running ;(
I see exactly the same results. Doing debug, I can check that only the only "if" that becomes "true" is the next:

if (namedValue.getName().endsWith("path") == true){
…..
‍‍‍‍

The rest of them are false all times. If I inspect the object "NamedValue" during the execution, it only has fill the "path" property:

{http://www.alfresco.org/model/content/1.0}path

Explained otherwise (sorry for my english if it is too bad

), my "rows" only have one property (path).

Thanks for answering, I´m working on it, if I find the solution I will post here. Maybe is a strange problem…

tim-erwin

Hi,

same problem here. We are successfully getting all kinds of stuff out of Alfresco on Linux. However, since 3.2 lucene queries don't return any data besides the path any more. Switched on debug logging for webservice and it confirms (in Utils) that only the path property is created. Interestingly, on another System (Windows) it works as expected. Could this be an OS issue?

Regards
Tim

rhakaro

I´m using Windows as SO, but I think this is not the problem….

jonthomas500

We are also experiencing this problem. We're running the alfresco- 3.2 on Solaris and using the webservice api.
Using the sample code from the developer website - the query result that's returned has a result set that contains only the path property named value.
Has anyone made any progress with this.
It is a bit of a show stopper to any further development.

Thanks

Jon

tim-erwin

Sorry for the confusion of concerning the OS: the one that works (on Windows) simply is another version: Preview_2

That could be a temporary solution for some: use 3.2_Preview2 instead of 3.2r

I filed a bug for this, please have a look at it and support it so it gets fixed soon: https://issues.alfresco.com/jira/browse/ALFCOM-3660

Cheers,
Tim

maqsood

try this:

Store STORE = new Store(Constants.WORKSPACE_STORE, "SpacesStore");
String ROOT = "/app:company_home/cm:"+ISO9075.encode("Folder Name");
String path = "PATH:\"/" + ROOT + "//.\" AND TYPE:\"{http://www.alfresco.org/model/content/1.0}content\""; 
final List<String> result = new ArrayList<String>();
final Query query = new Query(Constants.QUERY_LANG_LUCENE, path);
Node [] nodes = null;
try {&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
nodes = WebServiceFactory.getRepositoryService().get(new Predicate(null,STORE,query));&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
} catch (RepositoryFault e) {
e.printStackTrace();
} catch (RemoteException e) {
e.printStackTrace();
}
if (null != nodes){
NamedValue[] props = null;
for (final Node node : nodes) {
&nbsp;&nbsp;&nbsp;props = node.getProperties();
&nbsp;&nbsp;&nbsp;for(NamedValue prop : props) {
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if(prop.getName().endsWith(Constants.PROP_NAME) == true) {&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;result.add(prop.getValue());
&nbsp;&nbsp;&nbsp;}
}
}‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

hope it may resolve your problem

rhakaro

Thank you very much maqsood!!!!!!!!!!!

It runs!!! It runs!!! hehe

I don´t know where is the problem with my code, maybe adding "ISO9075.encode" or "TYPE:\"{http://www.alfresco.org/model/content/1.0}content\" it´s all done. I don´t understand where is the problem, but now it is running and returning me all the properties I need.

I thik it´s posible that the problem was in acces to data in this way:

                    String nodeId = row.getNode().getId();
                    ContentResult contentResult = new ContentResult(nodeId);
                    
                    for (NamedValue namedValue : row.getColumns()){
                        if (namedValue.getName().endsWith(Constants.PROP_CREATED) == true){
                                     ………
                        }
                        ……………
                        ……………
                    }
‍‍‍‍‍‍‍‍‍‍‍‍

instead of:

                        NamedValue[] props = null;
         for (final Node node : nodes) {
            props = node.getProperties();
            int i = 0;
            for(NamedValue prop : props) {
               if(prop.getName().endsWith(Constants.PROP_NAME) == true) {                   
                  ………..
               }
               ………………
               ………………
            }
‍‍‍‍‍‍‍‍‍‍‍‍‍

Again, thank you a lot!

tim-erwin

The big difference seems to be the web service method: you used query - the same I used, because it seemed to be the one for such kind of queries (http://wiki.alfresco.com/wiki/Repository_Web_Service#query) and it worked. maqsood suggests using get which I usually use for stuff I explicitly want to retrieve via uuid and so on.

What's the difference between get and query? Which one to use when?

Regards,
Tim

rhakaro

That´s true, I did`t realize about that detail. I don´t know where is the diference, but I will work on to resolve it!

maqsood

Even i don't know, I just try in the other way round and it works. me also working around it to find out which one to use and when.

dcastro2716

Somebody know if this is going to be like this from now on?? or is something with 3.2r2? because some books say that query is the rigth way to go, but it doesnt work to get all the properties anymore. We should use only get in the future?
thx.

dA.

openpj

In Alfresco 3.2 Enterprise if you try to get results from the query method of the Repository Service, Alfresco will return only nodes with the following fields: uuid, types and aspects.
The columns field contains only the path of the node, but it should contain all the properties (as the previous versions of Alfresco).

The queryParents and queryChildren methods correctly return all the properties as expected.
It could be a bug or is this a wanted feature of Alfresco 3.2?

relax

Hello,
I also have a problem for a search query problem. I want to search a group for some operation as rename display name.

public static void renameGroup2(String groupName, String newName) {
         String query = "+PATH:\"/sys:system/sys:authorities//*\" + @usr\\:authorityName:\""
               + groupName + "\""; 
         RepositoryServiceSoapBindingStub repositoryService = WebServiceFactory
               .getRepositoryService();
         try {
            Node[] nodes = repositoryService.get(new Predicate(null, new Store(
                  "user", "alfrescoUserStore"), new Query(
                  Constants.QUERY_LANG_LUCENE, query)));
// but nodes is null!!!
            CMLUpdate update = new CMLUpdate(new NamedValue[] {Utils.createNamedValue("{http://www.alfresco.org/model/user/1.0}authorityName", newName)},
                  new Predicate(new Reference[] { nodes[0].getReference() },
                        null, null), null);‍‍‍‍‍‍‍‍‍‍‍‍‍

but nodes is null.
I tested query with:
+PATH:"/sys:system/sys:authorities//*" + @usr\:authorityName:"GROUP_test"
or
+PATH:"/sys:system/sys:authorities//*" + @usr\:authorityName:"test"

where rootgroup name is test.

I suppose have a problem in query. In Alfresco Node Browser
http://localhost:8080/alfresco/faces/jsp/admin/node-browser.jsp
I select

user://alfrescoUserStore

for

lucene search

what's the search text to search a rootgroup with name test?

Thank you

relax

Hello,
this is XPath for a Group named test

/{http://www.alfresco.org/model/system/1.0}system/{http://www.alfresco.org/model/system/1.0}authorities/{http://www.alfresco.org/model/content/1.0}GROUP_test

present in store
workspace://SpacesStore

maschlosser

Hi Folks,

I'm a little confuse here. After all what is the wright to go? get or query?

tks
MS