Sparse not only allows you to navigate amongst data (by using sqlnavigation or the previous/next sqlaction buttons) it also allows
you to search for specific values quickly and easily. You can navigate
amongst the returned values the same way you can with regular ones!
Here's a quick demonstration.
Note that the search terms are appended
(ANDed) to the existing constraints, and each search term is ANDed
together (i.e. all terms must match). Search terms are substring
matches (using SQL's "LIKE" syntax).
Finally, you can use the sqlsearch
tag to streamline things. Similar to quick
replaces itself with several other tags. For example:
<sqlsearch names="name, email" />
will replace itself with
Name: <sqlfield isSearch="true" name="name"
<sqlfield isSearch="true" name="email" />
You can use Linking to search via a form or
a URL from a different page - this is useful to e.g. show only a
specific row as identified by ID.