topic Re: Pager with Lucene Search in Alfresco Archive

Pager with Lucene Search

emmy — Thu, 18 Oct 2007 08:32:10 GMT

Hi,I have created a webscript that search all the nodes having specified some parameters (i.e name, update date, created date…).I have used the function childrenByLuceneSearch in the template, but if the results are 1500 for example the wait time is too long. Is possible to limit those results for e

Re: Pager with Lucene Search

kevinr — Fri, 26 Oct 2007 11:08:11 GMT

The repository Lucene search does not yet supported paged result sets. You will have to implement the paging yourself in the client. We perform a similar pattern with our OpenSearch webscripts. The search is performed in the repo, but only the requested page of the results are returned in XML to the template.

You can use the ?size operator in freemarker to find the size of a sequence (list) from the results of the childrenByLuceneSearch operation.

Thanks,

Kevin

Re: Pager with Lucene Search

witho — Mon, 24 Aug 2009 12:45:00 GMT

I have the same problem with a doclit portlet I have created to find the last 20 documents uploaded to the repoitory. The thing is that I have to search every docs in the repository order by date and only print the first 20 documents and the others just set at display:none.

Is there any better solution in order to minimize the waiting time?

Thanks a lot!!!

Re: Pager with Lucene Search

kevinr — Mon, 24 Aug 2009 13:39:53 GMT

Set the maximum results to return to 20 items directly on the API call, then sort by date using the sorting options on the API call i.e. don't do the cropping/sorting post process it in javascript/freemarker.

http://wiki.alfresco.com/wiki/3.2_JavaScript_API#Search_API

Kev

Re: Pager with Lucene Search

witho — Mon, 07 Sep 2009 08:48:36 GMT

The problem is that I can't find where are the code of the search calls. These are the calls in the javascript/freemarker:

<#if args.h?exists>
   <#assign docs=companyhome.nodeByReference[args.h].children?sort_by(["properties","cm:created"])?reverse>
<#else>
   <#assign docs=companyhome.childrenByLuceneSearch[args.q]?sort_by(["properties","cm:created"])?reverse>
</#if>‍‍‍‍‍

Do you know where are the source of these calls where I could change the code to return only 20 items sorts by date?

Thanks!!!

Re: Pager with Lucene Search

kevinr — Mon, 07 Sep 2009 10:42:50 GMT

org.alfresco.repo.template.TemplateNode and it's associated base classes.

Re: Pager with Lucene Search

witho — Fri, 11 Sep 2009 07:53:02 GMT

Sorry kevinr, but I could not get with the code where I have to set the resuts return size to 20. I am looking into TemplateNode and its base classes but I can't get it.

Do you know where can I set these parameters?

Thank you.

Re: Pager with Lucene Search

kevinr — Fri, 11 Sep 2009 10:36:44 GMT

You would need to modify or extend the getChildrenByLuceneSearch() method.

To be honest, if possible you are much better using a WebScript for this - as then you have full access to the greatly improved JavaScript Search API which includes parameters for setting max results returned, multi-field sorting etc.etc. Obviously this is not possible if you have to perform the logic directly in the template…

Kev

Re: Pager with Lucene Search

witho — Thu, 17 Sep 2009 09:24:40 GMT

Hi,

Finally I got a valid solution for me. I replicate the method getChildrenByLuceneSearch the class LuceneSearchResultsMap and also the method get inside this class. I make a new lucene search that sort the documents by created date and get only the 20 first. This is my method get:


    public Object get(Object key)
    {
        // execute the search
        String search = key.toString();
       List<TemplateNode> nodes = null;
        HashSet<NodeRef> nodeRefs = new HashSet<NodeRef>();

        // check if a full Lucene search string has been supplied or extracted from XML
        if (search != null && search.length() != 0)
        {
            // perform the search against the repo
            ResultSet results = null;
            try
            {
                SearchParameters sp = new SearchParameters();
                sp.addStore(this.parent.getNodeRef().getStoreRef());
                sp.setLanguage(SearchService.LANGUAGE_LUCENE);
                sp.setQuery(search);
                sp.addSort("CREATED", false);
                sp.setLimitBy(LimitBy.FINAL_SIZE);
                int limit = 20;
                sp.setLimit(limit);

                results = this.services.getSearchService().query(sp);

                if (results.length() != 0)
                {
                    nodes = new ArrayList<TemplateNode>(results.length());
                    for (ResultSetRow row : results)
                    {
                        NodeRef nodeRef = row.getNodeRef();
                        if (!nodeRefs.contains(nodeRef))
                        {
                            nodes.add(new TemplateNode(nodeRef, services, this.parent.getImageResolver()));
                            nodeRefs.add(nodeRef);
                        }
                    }
                }
            }
            catch (Throwable err)
            {
                throw new AlfrescoRuntimeException("Failed to execute search: " + search, err);
            }
            finally
            {
                if (results != null)
                {
                    results.close();
                }
            }
        }

        return nodes != null ? nodes : (List) Collections.emptyList();
    }
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Thanks for your help and I hope this may help somebody too.