Editing 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 table attribute is required, and 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.

The criteria is optional.  Specifying this allows you to specify which records to return.  Options are currently ''very'' limited, partly due to limitations of passing in an attribute.  Currently you can provide a comma-separated list of "field=value" or "field!=value" pairs, which are ANDed together.

The sort contains a comma separated list of fields with an optional 'DESC' modifier (e.g. "Field1,Field2 DESC,Field3").  The rows are sorted by the fields in the order specified.

== 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}}}<br>
|-
<footer>
|}
</footer>
</repeat>
</pre>

<repeat Table="Companies3">
<header>
{| class="wikitable"
! Name !! Revenue
|-
</header>
| '''{{{Name}}}''' <small>{{{Location}}}</small> || {{{Revenue}}}<br>
|-
<footer>
|}
</footer>
</repeat>
@@ Line 5: / Line 5: @@
   &lt;repeat table="..." criteria="..." sort="...">Any old wiki text, with {{{variable}}} substitution.&lt;/repeat>
-The tag recognises the following attributes:
+The table attribute is required, and 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.
-; table (required)
+The criteria is optional.  Specifying this allows you to specify which records to return.  Options are currently ''very'' limited, partly due to limitations of passing in an attribute.  Currently you can provide a comma-separated list of "field=value" or "field!=value" pairs, which are ANDed together.
-: 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.
+The sort contains a comma separated list of fields with an optional 'DESC' modifier (e.g. "Field1,Field2 DESC,Field3").  The rows are sorted by the fields in the order specified.
 == Controlling the rendering ==
@@ Line 36: / Line 31: @@
 |-
 </header>
-| '''{{{Name}}}''' <small>{{{Location}}}</small> || {{{Revenue|Unknown}}}<br>
+| '''{{{Name}}}''' <small>{{{Location}}}</small> || {{{Revenue}}}<br>
 |-
 <footer>
@@ Line 50: / Line 45: @@
 |-
 </header>
-| '''{{{Name}}}''' <small>{{{Location}}}</small> || {{{Revenue|Unknown}}}<br>
+| '''{{{Name}}}''' <small>{{{Location}}}</small> || {{{Revenue}}}<br>
 |-
 <footer>