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: 4 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-02197: User Registration gets error message on login
SID-02196: Twiki to Confluence Migration
SID-02193: 500 Internal Server Error after Apache 2.4 update
SID-02191: Troubleshooting Custom Templates After Upgrade
SID-02188: TWiki Registration Questions: Email Confirmation
SID-02187: Skin per Web
SID-02186: Page "editor" or owner
SID-02184: Twiki install
SID-02183: Unable to save twiki configuration
SID-02177: ApprovalPlugin; Reset Approved Status
SID-02175: Insecure dependency in sysopen while running with -T switch
SID-02173: TWiki Installation Error Template "oopsattention" not found.
SID-02170: Internal error when sending email to xxxx

Status Answered:
SID-02199: Problems TWikiSheetPlugin
SID-02198: SpreadSheetPlugin LISTMAP missing
SID-02195: Accessing a users FirstName and LastName etc
SID-02194: Background colors for webs does not seem to work correctly
SID-02192: Problem with the TWiki installation
SID-02190: Purchased VM but no link
SID-02189: What is a HTML document enabled directory?
SID-02185: If Formfield Blank then do nothing
SID-02182: csv2twiki error
SID-02181: Default signature shows full name instead of WikiName
SID-02180: Problem with AdminUser
SID-02179: Identification of the owner of a sub-web
SID-02176: Internal Server Error
SID-02174: USERNAME Variable on Template page
SID-02172: Please remove my account.
SID-02171: Replacing the HTML::Entities Perl module

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-2016 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.