https://www.kennel17.co.uk/testwiki/index.php?title=WikiDB/Defining_data&feed=atom&action=historyWikiDB/Defining data - Revision history2024-03-29T10:16:57ZRevision history for this page on the wikiMediaWiki 1.25.2https://www.kennel17.co.uk/testwiki/index.php?title=WikiDB/Defining_data&diff=19314&oldid=prevHappyDog: /* Dealing with edge-cases */ Clarification2022-04-15T19:03:05Z<p><span dir="auto"><span class="autocomment">Dealing with edge-cases: </span> Clarification</span></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black; text-align: center;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black; text-align: center;">Revision as of 19:03, 15 April 2022</td>
</tr><tr><td colspan="2" class="diff-lineno" id="L69" >Line 69:</td>
<td colspan="2" class="diff-lineno">Line 69:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>=== Dealing with edge-cases ===</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>=== Dealing with edge-cases ===</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>Because the multi-value field syntax is invoked by a value that starts with a <code>{</code>, field values that start with a brace ''must'' be represented in multi-value format <del class="diffchange diffchange-inline">(e.g</del>. <code>{{Value starting with a brace}</code>.</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>Because the multi-value field syntax is invoked by a value that starts with a <code>{</code>, field values that start with a brace ''must'' be represented in multi-value format. <ins class="diffchange diffchange-inline"> For example, to represent the value <code>{Value starting with a brace</code>, you would place it into a multi-field value, like this: </ins><code>{{Value starting with a brace}</code>.</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>Similarly, because <code>}</code> indicates the end of a multi-value field, it is not possible to include values ending in braces as part of a multi-value field in multi-line mode.  Closing braces have no special meaning outside of a multi-value field, so these are safe if they are the only value (but, this is not possible if it also starts with a brace).  Alternatively, if that is not possible, you can use field/value mode, as in this mode the closing brace will only end the value list if it is the last character on the line.</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>Similarly, because <code>}</code> indicates the end of a multi-value field, it is not possible to include values ending in braces as part of a multi-value field in multi-line mode.  Closing braces have no special meaning outside of a multi-value field, so these are safe if they are the only value (but, this is not possible if it also starts with a brace).  Alternatively, if that is not possible, you can use field/value mode, as in this mode the closing brace will only end the value list if it is the last character on the line.</div></td></tr>
<!-- diff cache key happydog_testwiki-wiki_:diff:version:1.11a:oldid:19300:newid:19314 -->
</table>HappyDoghttps://www.kennel17.co.uk/testwiki/index.php?title=WikiDB/Defining_data&diff=19300&oldid=prevHappyDog: /* Multi-value fields */ + edge cases2022-02-07T22:30:28Z<p><span dir="auto"><span class="autocomment">Multi-value fields: </span> + edge cases</span></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black; text-align: center;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black; text-align: center;">Revision as of 22:30, 7 February 2022</td>
</tr><tr><td colspan="2" class="diff-lineno" id="L64" >Line 64:</td>
<td colspan="2" class="diff-lineno">Line 64:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>Multi-value fields can be queried [[WikiDB/Querying data|just like any other field]] and all values for the record will be checked when the criteria is applied.  This means that expressions such as <code>Course = 'English' AND Course = 'French'</code> will find all records which include both of these values.  In addition, specifying a multi-field value as part of the sort will sort the values for each row accordingly (e.g. specifying a sort that includes "Course DESC" would result in John's courses being listed as "Geography, French, English".  If a sort is not specified, they will be listed in the order entered.</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>Multi-value fields can be queried [[WikiDB/Querying data|just like any other field]] and all values for the record will be checked when the criteria is applied.  This means that expressions such as <code>Course = 'English' AND Course = 'French'</code> will find all records which include both of these values.  In addition, specifying a multi-field value as part of the sort will sort the values for each row accordingly (e.g. specifying a sort that includes "Course DESC" would result in John's courses being listed as "Geography, French, English".  If a sort is not specified, they will be listed in the order entered.</div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">Note that a multi-value field with a single element is treated the same as a single-value field (i.e. <code>"English"</code> and <code>"{English}"</code> are identical) and an empty multi-value field is treated the same as an empty field (i.e. <code>""</code> and <code>"{}"</code> are identical).</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">=== Dealing with edge-cases ===</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">Because the multi-value field syntax is invoked by a value that starts with a <code>{</code>, field values that start with a brace ''must'' be represented in multi-value format (e.g. <code>{{Value starting with a brace}</code>.</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">Similarly, because <code>}</code> indicates the end of a multi-value field, it is not possible to include values ending in braces as part of a multi-value field in multi-line mode.  Closing braces have no special meaning outside of a multi-value field, so these are safe if they are the only value (but, this is not possible if it also starts with a brace).  Alternatively, if that is not possible, you can use field/value mode, as in this mode the closing brace will only end the value list if it is the last character on the line.</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">There is no way to override the use of braces to delineate multi-value fields.</ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>== Display options ==</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>== Display options ==</div></td></tr>
</table>HappyDoghttps://www.kennel17.co.uk/testwiki/index.php?title=WikiDB/Defining_data&diff=19299&oldid=prevHappyDog: /* Multi-value fields */ Syntax fix.2022-02-07T22:21:31Z<p><span dir="auto"><span class="autocomment">Multi-value fields: </span> Syntax fix.</span></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black; text-align: center;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black; text-align: center;">Revision as of 22:21, 7 February 2022</td>
</tr><tr><td colspan="2" class="diff-lineno" id="L48" >Line 48:</td>
<td colspan="2" class="diff-lineno">Line 48:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>The syntax for multiple values is to wrap the set of values in braces.  Wherever you might specify a single value (as per the above descriptions) you can instead specify multiple values.</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>The syntax for multiple values is to wrap the set of values in braces.  Wherever you might specify a single value (as per the above descriptions) you can instead specify multiple values.</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>; Example 1<del class="diffchange diffchange-inline">: </del>Field/value mode</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>; Example 1 <ins class="diffchange diffchange-inline">- </ins>Field/value mode</div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>  &lt;data table="Students"></div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>  &lt;data table="Students"></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>  Name = John</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>  Name = John</div></td></tr>
<tr><td colspan="2" class="diff-lineno" id="L55" >Line 55:</td>
<td colspan="2" class="diff-lineno">Line 56:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>  &lt;/data></div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>  &lt;/data></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>; Example 2<del class="diffchange diffchange-inline">: </del>Multi-line mode:</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>; Example 2 <ins class="diffchange diffchange-inline">- </ins>Multi-line mode:</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>  &lt;data table="Students" fields="Name,Course,Supervisor"></div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>  &lt;data table="Students" fields="Name,Course,Supervisor"></div></td></tr>
</table>HappyDoghttps://www.kennel17.co.uk/testwiki/index.php?title=WikiDB/Defining_data&diff=19298&oldid=prevHappyDog: Added documentation for multi-value fields.2022-02-07T22:20:58Z<p>Added documentation for multi-value fields.</p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black; text-align: center;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black; text-align: center;">Revision as of 22:20, 7 February 2022</td>
</tr><tr><td colspan="2" class="diff-lineno" id="L39" >Line 39:</td>
<td colspan="2" class="diff-lineno">Line 39:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>As you may have field values that need to contain commas, it is possible to specify an alternative separator via the <code>separator</code> attribute (which is optional).  Multi-character separators are allowed.  Note that the <code>separator</code> does not affect the way the <code>fields</code> attribute is defined - this ''always'' uses a comma as the separator.</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>As you may have field values that need to contain commas, it is possible to specify an alternative separator via the <code>separator</code> attribute (which is optional).  Multi-character separators are allowed.  Note that the <code>separator</code> does not affect the way the <code>fields</code> attribute is defined - this ''always'' uses a comma as the separator.</div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">=== Multi-value fields ===</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">It is also possible to define multi-value fields within WikiDB.  For example, if you had a Student table you might want to be able to specify that an individual student is taking multiple courses.  This is analogous to a many-to-many relationship in a standard relational database.</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">In WikiDB, this is not done as part of the table definition, but as part of the data.  Any field in any row of any table may be specified such that it contains multiple values.</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">The syntax for multiple values is to wrap the set of values in braces.  Wherever you might specify a single value (as per the above descriptions) you can instead specify multiple values.</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">; Example 1: Field/value mode</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> &lt;data table="Students"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> Name = John</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> Course = {English, Geography, French}</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> YearGroup = 2A</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> &lt;/data></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">; Example 2: Multi-line mode:</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> &lt;data table="Students" fields="Name,Course,Supervisor"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> John, {English, Geography, French}, Dr. Lucas</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> Jane, {Physics, Mathematics}, Dr. Aponsa</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> &lt;/data></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">Multi-value fields can be queried [[WikiDB/Querying data|just like any other field]] and all values for the record will be checked when the criteria is applied.  This means that expressions such as <code>Course = 'English' AND Course = 'French'</code> will find all records which include both of these values.  In addition, specifying a multi-field value as part of the sort will sort the values for each row accordingly (e.g. specifying a sort that includes "Course DESC" would result in John's courses being listed as "Geography, French, English".  If a sort is not specified, they will be listed in the order entered.</ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>== Display options ==</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>== Display options ==</div></td></tr>
<!-- diff cache key happydog_testwiki-wiki_:diff:version:1.11a:oldid:9631:newid:19298 -->
</table>HappyDoghttps://www.kennel17.co.uk/testwiki/index.php?title=WikiDB/Defining_data&diff=9631&oldid=prevHappyDog: Written, incorporating content from the WikiDB/Syntax page, which I plan to make into more of a syntax reference.2015-06-07T22:23:06Z<p>Written, incorporating content from the <a href="/testwiki/WikiDB/Syntax" title="WikiDB/Syntax">WikiDB/Syntax</a> page, which I plan to make into more of a syntax reference.</p>
<p><b>New page</b></p><div>WikiDB is a tool to create and query database-like data from within your wiki.<br />
<br />
This page describes how to add new data to your wiki.<br />
<br />
== Basic principles ==<br />
<br />
* You can create data anywhere on the wiki, simply by editing the page content to include a <code>&lt;data&gt;</code> tag (as described below).<br />
* You need to specify the name of a table into which the data will be placed, e.g. "People" or "Countries" so WikiDB knows where the data should go.<br />
* The table or fields that you use do not have to exist, but if it does then any data rules it defines will be applied to your data when it is displayed. However, the data you enter is never modified (except by subsequent page edits) and any changes to the table definition are reflected in the data in real-time.<br />
* Even if the data is sent to a table that doesn't exist it can still be viewed and queried, just as if the table did exist.<br />
<br />
== Creating data ==<br />
<br />
Data is defined using the <code>&lt;data&gt;</code> tag. There are two ways of using this tag - field/value mode or multi-line mode.<br />
<br />
=== Field/value mode ===<br />
<br />
This method defines a single row of DB data per tag. The tag's contents consist of multiple lines, each of which is a fieldname/value pair (if it contains an = sign) or a comment (if it doesn't).<br />
<br />
&lt;data table="..."><br />
Field1=Value1<br />
Field2=Value2<br />
Any line without an equals sign is ignored.<br />
&lt;/data><br />
<br />
=== Multi-line mode ===<br />
<br />
In multi-line mode, you define the field names in the <code>fields</code> attribute, and then each line is a comma-separated list of values.<br />
<br />
&lt;data table="..." fields="Field1,Field2,Field3,..." separator=","><br />
Row1 Field1, Row1 Field2, Row1 Field 3, ...<br />
Row2 Field1, Row2 Field2, Row2 Field 3, ...<br />
== Headings are ignored ==<br />
&lt;/data><br />
<br />
Each line in the tag's contents is treated as a row of data, except for blank rows or MediaWiki headings (e.g. <code>== Heading ==</code>) which are ignored. The <code>fields</code> attribute defines the names of the fields that appear in each row, in the form of a comma-separated list<br />
<br />
In the body of the tag, each row consists of field values separated, usually, by commas. If a row has fewer fields than are defined in the <code>fields</code> attribute then the remaining fields are left blank. If it has additional fields, then they are ignored.<br />
<br />
As you may have field values that need to contain commas, it is possible to specify an alternative separator via the <code>separator</code> attribute (which is optional). Multi-character separators are allowed. Note that the <code>separator</code> does not affect the way the <code>fields</code> attribute is defined - this ''always'' uses a comma as the separator.<br />
<br />
== Display options ==<br />
<br />
When you define data in your page, you are essentially instructing WikiDB to place the data into the specified table, so unless you specify otherwise, this won't result in any content being output within the page itself.<br />
<br />
However, WikiDB provides an optional <code>template</code> attribute which can be used to output the contents of the tag directly into the page at the point the tag appears. This attribute can be set to one of the following values:<br />
* <code>"none"</code> means the data is not displayed - this is the default, and never needs to be explicitly specified.<br />
* <code>"default"</code> means the data is output in a standard tabular format provided by WikiDB.<br />
* Any other value is treated as the name of a template that has been defined on the wiki. This template will be expanded once per row of data. It works the same as for standard templates, and each of the fields is passed to the template as a named parameter.<br />
<br />
For example, if you define data like this:<br />
&lt;data table="People" fields="Name,Age" template="People"><br />
John, 42<br />
Kate, 37<br />
&lt;/data><br />
<br />
then as well as adding the data to the 'People' table, you would get output equivalent to the following wiki code:<br />
<br />
<pre><br />
[[Template:People|Name=John|Age=42]]<br />
[[Template:People|Name=Kate|Age=37]]<br />
</pre><br />
<br />
== Defining data using templates ==<br />
<br />
As well as using templates to display data defined in a <code>&lt;data&gt;</code> tag, it is also possible to do this the other way round, and define data using templates.<br />
<br />
Imagine you have a template called <code><nowiki>[[Template:People]]</nowiki></code> which is defined as follows:<br />
<pre><br />
* {{{Name}}} is {{{Age|an unknown number of}}} years old.<br />
</pre><br />
<br />
which you include in your wiki articles in the standard way, like this:<br />
<pre><br />
{{Name|John|42}}<br />
{{Name|Kate|37}}<br />
</pre><br />
<br />
By simply updating your template, as follows, this data will now also be added to a queryable table on your wiki:<br />
<pre><br />
* {{{Name}}} is {{{Age|an unknown number of}}} years old. <data table="People" fields="Name,Age">{{{Name}}},{{{Age}}}</data><br />
</pre></div>HappyDog