create new tag
, view all tags


How can I do a formatted search to a form containing a field value, say, greater than 100 or less than or equal to 500? From the examples I've seen so far, form field data SEARCH is used to query for exact values. I'm doing some data filtering mechanism in a table containing data from a formatted search result and this is one of the things that came up.


TWiki version: TWikiRelease04x01x02
TWiki plugins: DefaultPlugin, EmptyPlugin, InterwikiPlugin
Server OS:  
Web server:  
Perl version:  
Client OS: Windows XP SP2
Web Browser: Mozilla Firefox
Categories: Search

-- FredanLangam - 22 Nov 2007


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.

The upcoming TWiki 4.2 release has more sophisticated query search capabilities: TWiki:QuerySearch.

With earlier TWiki versions you can do a workaround: Search for topics with that form, then in the format="" conditionally output a row. Untested example:
format="$percntCALC{$IF($formfield(Price) > 100, <nop>, | $topic | $formfield(Foo) |)}$percnt"

See details in VarSEARCH, FormattedSearch, SpreadSheetPlugin.

-- PeterThoeny - 01 Jan 2008

Change status to:
Edit | Attach | Watch | Print version | History: r2 < r1 | Backlinks | Raw View | Raw edit | More topic actions
Topic revision: r2 - 2008-01-01 - PeterThoeny
  • 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-2018 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.