Question

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.

Environment

-- FredanLangam - 22 Nov 2007

Answer

If you answer a question - or have a question you asked answered by someone - please remember to edit the page and set the status to answered. The status is in a drop-down list 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