create new tag
, view all tags

SID-01302: Search and Categorize

Status: Answered Answered TWiki version: 5.0.2 Perl version:
Category: CategorySearch 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
Topic 1
Topic 3
Topic 4

Is there anyway to achieve something similar with a single search ?

-- RonMascarenhas - 2011-10-23

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: StatusAsked containing the list of topics with status "Asked", and StatusAnswered 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:

Status Asked:
SID-02101: How to create a report from the TWiki logs based on TWikiGro
SID-02098: Active Directory Login not working
SID-02097: Trouble "upgrading" LdapContrib after installing CPAN deps
SID-02095: how to create a app that can classify the files
SID-02094: Though External IP can't access view page
SID-02093: Textarea
SID-02076: Doubt about database store of the topics
SID-02075: Can't access to the frontpage
SID-02073: Underscores Missing in TOC

Status Answered:
SID-02100: export WebStatistics into Excel
SID-02099: Can I return Twiki search results to another page?
SID-02096: Layout not working correctly
SID-02092: CALC inside nested search that is inside calc
SID-02091: Programmatically change form field via POST call
SID-02090: Unable to deploy Twiki on Amazon EC2 linux instance
SID-02089: Set WebLeftBar Width
SID-02088: Open document from wiki Topic
SID-02087: Changing the WebHeader image
SID-02086: Disable SSO - mod_auth
SID-02085: Trying to modify the "Access denied" message
SID-02084: How do I remove the grey "twiki.org" link and image
SID-02083: topic with multiple indentifications
SID-02082: Custom plugin params _DEFAULT behavior disagreement
SID-02081: Twiki-Vm installation: This page can't be displayed
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

View the raw topic for details.

-- PeterThoeny - 2011-10-24

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.

-- RonMascarenhas - 2011-10-24

You could simply do a SEARCH and sort by the category, such as with order="formfield(Category)". Details in VarSEARCH.

-- PeterThoeny - 2011-10-25

-- RonMascarenhas - 2011-11-18

      Change status to:
ALERT! 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.
Status Answered
Title Search and Categorize
SupportCategory CategorySearch
TWiki version 5.0.2
Server OS Linux SLES 11
Web server apache2
Perl version

Edit | Attach | Watch | Print version | History: r6 < r5 < r4 < r3 < r2 | Backlinks | Raw View | Raw edit | More topic actions
Topic revision: r6 - 2011-11-18 - RonMascarenhas
  • Learn about TWiki  
  • Download TWiki
This site is powered by the TWiki collaboration platform Powered by Perl Hosted by OICcam.com Ideas, requests, problems regarding TWiki? Send feedback. Ask community in the support forum.
Copyright © 1999-2015 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.