View source for WikiDB/Repeat tag syntax

<small style="border: 1px solid #CCCCCC; padding: 0.2em; background-color: #F0F0F0;">See [[WikiDB/Repeat tag syntax/Archive]] for old development discussion.</small>

The '''&lt;repeat&gt;''' tag allows you to query the data.

 &lt;repeat table="..." criteria="..." sort="...">Any old wiki text, with {{{variable}}} substitution.&lt;/repeat>

The tag recognises the following attributes:

; table (required)
: This defines where the data comes from.  The table does not need to be defined on the wiki - the tag will pull data for all rows that specified this table, even if the table does not exist.
; criteria (optional)
: Specifying this allows you to restrict the set of records that are displayed.  If no criteria is specified, all rows are included.
; sort (optional)
: The rows are sorted by the fields in the order specified.  If no sort is specified, then the sort order is undefined and may vary between page views.

Full syntax for the criteria and sort attributes is the same as is used on the 'viewdata' tab to live-filter the data.  See [[WikiDB/Querying data]] for full details.  Note that, in the context of an HTML attribute, the <code>&lt;</code> character is not allowed, therefore you should use <code>LT</code> and <code>LTE</code> instead of <code>&lt;</code> and <code>&lt;=</code> in this context.

== Controlling the rendering ==

There are currently two ways for the results of the query to be rendered:

* If the repeat tag is empty (or just contains white-space) then WikiDB will output the data as a table, in a standard format.
* If the repeat tag contains any text, then this will be repeated for each row returned by the query.  Any field name inside three curly brackets (e.g. <code><nowiki>{{{FieldName}}}</nowiki></code>) will be replaced by the value of the field for the current row, and the result will be parsed as wiki text.
** Field aliases are resolved correctly, so if you defined 'name' as an alias for 'first name' then using either field will give the same result.
** [[WikiDB/Defining data#Multi-value fields|Multi-value fields]] will be pre-rendered into a single string value.  Currently there is no way to iterate over the individual values for multi-value fields.

=== Headers and footers ===

It is possible to specify a header and/or footer section within your repeat tag, and if present these are output before/after the individual rows.  For most use-cases you could achieve the same result by putting the header/footer content outside the tag, but due to the way MediaWiki rendering works it is not possible to do this if you want to output a table.  To output a custom table, you will need to open it in your header section and close it in your footer, like this:

<pre>
<repeat Table="Companies3">
<header>
{| class="wikitable"
! Name !! Revenue
|-
</header>
| '''{{{Name}}}''' <small>{{{Location}}}</small> || {{{Revenue|Unknown}}}<br>
|-
<footer>
|}
</footer>
</repeat>
</pre>

<repeat Table="Companies3">
<header>
{| class="wikitable"
! Name !! Revenue
|-
</header>
| '''{{{Name}}}''' <small>{{{Location}}}</small> || {{{Revenue|Unknown}}}<br>
|-
<footer>
|}
</footer>
</repeat>