topic Re: Sort by column in Alfresco Archive

Sort by column

filipousiss — Tue, 14 Nov 2006 12:54:57 GMT

Hi,I'm wondering if it's possible to make a query like in sql where you can order by column with lucene?? SQLSELECT *FROM "spacename"[WHERE "condition"]ORDER BY "modified" [ASC, DESC]LUCENEnew Query(Constants.QUERY_LANG_LUCENE, PATH:\"/app:company_home/cm:"+spacename+"//*\ AND (TEXT:" word ")));

Re: Sort by column

kevinr — Wed, 15 Nov 2006 10:39:25 GMT

Yes it can be performed programatically when executing the lucene search:
http://wiki.alfresco.com/wiki/Search#Queries_That_Sort


        SearchParameters sp = new SearchParameters();
        sp.addStore(getStoreRef());
        sp.setLanguage(SearchService.LANGUAGE_LUCENE);
        sp.setQuery("PATH:\"//.\"");
        sp.addSort("ID", true);
        ResultSet results = null;
        try
        {
            results = serviceRegistry.getSearchService().query(sp);
            for(ResultSetRow row : results)
            {
                NodeRef currentNodeRef = row.getNodeRef();
                …
            }
        }
        finally
        {
            if(results != null)
            {
                results.close();
            }
        } 
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Thanks,

Kevin

Re: Sort by column

filipousiss — Wed, 15 Nov 2006 13:38:13 GMT

thx kevin for your reply.

I'm using webservices to send queries to the repository…
So I've looked into the functions of the webservices but I didn't found a function that have a paramter of the type SearchParameters.

Am I wrong or just blind ??

That's what I'm doing now


query=new Query(Constants.QUERY_LANG_LUCENE, PATH:\"/app:company_home/cm:"+spacename+"//*\ AND (TEXT:" word "))); 
QueryResult queryResult = repositoryService.query(STORE, query, false);
‍‍‍‍

Thx in advance

Re: Sort by column

rwetherall — Wed, 15 Nov 2006 14:39:10 GMT

Hi,

I dont believe that you can currently pass search parameters using the current web service API.

I would have thought you would have to resolve the parameter values on the client before sending the query to the web service API.

Perhaps this is a feature we should add thou. Could you add this as a Jira task. That way you'll be able to track its progress and we'll be able to prioritise it effectively.

Cheers,
Roy

Re: Sort by column

luba_s — Tue, 13 Feb 2007 13:10:54 GMT

Hi,

I dont believe that you can currently pass search parameters using the current web service API.

I would have thought you would have to resolve the parameter values on the client before sending the query to the web service API.

Perhaps this is a feature we should add thou. Could you add this as a Jira task. That way you'll be able to track its progress and we'll be able to prioritise it effectively.

Cheers,
Roy

Hello, are there any news about this? I would really appreciate ability to pass search parameters. Thanks

Re: Sort by column

lfuller — Thu, 05 Apr 2007 19:34:08 GMT

I can create a SearchParameters object, set the field and run the query. My problem is that, thus far, I've been unable to hit upon anyway to determine what the field names are I should pass in. If I use ID, then I notice that the field is found and the results are sorted differently. How would one sort by cm:name or cm:description or cm:created?

Re: Sort by column

lfuller — Thu, 05 Apr 2007 20:30:55 GMT

cm:name maps to @{http://www.alfresco.org/model/content/1.0}name
cm:description maps to @{http://www.alfresco.org/model/content/1.0}description

However, I can't seem to figure out a valid field name for the aspect cm:created.

@{http://www.alfresco.org/model/content/1.0}created does not work. Anyone out there know what does?