SID-01302: Search and Categorize
|| TWiki version:
|| Perl version:
|| Server OS:
|| Linux SLES 11
|| Last update:
|| 3 years ago
I have topics with a formfield 'Category' and I need to do a single search and to display topics under different categories.
For example if I have topics under categories Apples Oranges and I need to display the topics under each category
Is there anyway to achieve something similar with a single search ?
Discussion and Answer
You can do that by assigning each search hit to a SpreadSheetPlugin
variable, using one variable per category.
Here is an example doing a SEARCH on the latest 30 support questions. We keep two spreadsheet variables:
containing the list of topics with status "Asked", and
containing the list of topics with status "Answered". We then use the LISTMAP function to iterate over the list to create table rows showing all topics of a category:
View the raw topic
| Status Answered:
| SID-02082: Custom plugin params _DEFAULT behavior disagreement
| SID-02080: Macros and Interwiki links
| SID-02079: Configure error Failed to load the perl module CGI qw(:any).
| SID-02077: How to move the format field for a Search into a Topic variable?
| SID-02074: Construction of hash with list elements
| SID-02072: Compatibility of twiki 4.2 on Windows 2008
| SID-02071: Multiple Wiki's in Apache virtual hosts - Configure Issue
| SID-02070: Migrated from 4.2.4 to 6.0.1 and users are all red
| SID-02068: Customize top menu
| SID-02066: STARTFLOATBOX
| SID-02065: unexplained loss of permission for twiki/pub
| SID-02062: Is it possibility to modify pages/documents in a batch mode?
| SID-02061: Enabling Review Date Notifications
| SID-02060: Wysiwyg does not work after reboot
| SID-02055: indexed search with attachments?
| SID-02053: How to filter search results by the date in a formfield
Thanks Peter that solution suits me fine.
However just for my information , is there any way to generate the list, not knowing beforehand what the categories would be. For example there may be many categories or maybe the categories keep increasing and I don't want to have to edit the search every time.
You could simply do a SEARCH and sort by the category, such as with
. Details in VarSEARCH
If you answer a question - or someone answered one of your questions - please remember to edit the page and set the status to answered. The status selector is below the edit box.