Re: Multi-faceted searches of articles

Jason wrote:
> Expanding this to include searches on date ranges would also be good. The counts
>  would need to be done in various contexts for this to work, e.g. counts for
> entire years when searching without a date range specified, counts for each
> month when a year is specified, counts for the day and/or week when the month is
> selected etc.
> ...
> -- Jason

The articles module already has an API function that lets you count the 
articles per month & optional categories : getmonthcount(). The getall() 
API function also lets you select articles by pubtype, category, month etc.

Maybe you could have a look at the SQL statements generated there for 
inspiration on how to adapt those of multi-faceted xarpages ?

Mike.
P.S.: nice organization of that site, btw :-)