Multi-faceted searches of articles

Jason <[email protected]> Tue, 08 Sep 2009 14:41:59 +0100
Newsgroups gmane.comp.cms.xaraya.devel
Organization Xaraya
Message-ID <[email protected]>
In case anyone is interested, I have pushed some changes recently to xarpages
that allows you to perform multi-faceted searches on articles. It uses a new
xarpages page type, with a custom function.

It also requires a two-line change to the categories module to allow a filtering
sub-query to be injected into the categories 'deep' counts API. Since
sub-queries are only supported by MySQL 5+, I have not made that change to
Xaraya 1. It may be possible to use it on Xaraya 2, but I have not tested that.

The search is in operation below, and this is what it looks like "out of the
box". The category tree structure in this case is fairly flat, but the structure
can be a deep tree if required.

http://www.iema.net/readingroom/consultationpapers

The categories 'deep counts' also has a small problem with the way the counts
are summed over the categories tree, which results in double-counting of items
with multiple categories as you move towards the root of the tree. A fix to this
would have to be at the database query level.

The searches are all cross-publication type, where the publication type is used
only to allow different templates to be used, different privileges, and
different category trees (which are all combined).

There are some restrictions, which area all listed in the appropriate readme
within xarpages.

Hope you find it useful, even if just for some ideas.

-- Jason