[CPS-devel] Re: GROUP BY in portal catalog searchs

[Olivier Grisel]

JoseLuis de la Rosa Triviño a écrit :
> Hello,
> 
>  
> 
> I need to carry out searches in portal catalog in such a way that I can 
> "GROUP BY" some fields of the contents as it can be achieved with SQL. 
> Is this implemented?
> 
> If not, may somebody give me some ideas of where is best to do it? in 
> CatalogTool? In search.py?
> 
>  
> 
> I need to group results by author, location (relative url), date, type 
> of content, etc.

You can sort the results to get a similar effect in the resulting list of brains.

You can add 'sort-order' ans 'sort-limit' keys in your query to do that.

-- 
Olivier