SHOWQUERY
Used to show the results of a FormQueryPlugin query,
%SHOWQUERY
accepts all the same parameters as
%TABLEFORMAT
(except
name
), and also the following parameters:
Parameter |
Description |
query |
Required, gives the name of the query to show |
start |
Optional, first row to display |
limit |
Optional, number of rows to display, or all |
For example,
%SHOWQUERY{ query=AFORMQUERY format=ATBLFMT }%
Note: If you render your results in Foswiki table format and limit the rows displayed using
limit
(e.g. first 10 from 99 rows), and also use
TablePlugin to allow sorting on the headers, then only the 10 displayed rows will be sorted by
TablePlugin (and not the full 99 rows in the table).
See also:
FormQueryPlugin,
%SUMFIELD%,
%FORMQUERY%,
%QUERYTOCALC%,
%TABLEFORMAT%,
%SHOWCALC%,
%MATCHCOUNT%,
%SHOWQUERY%