Create and Query Tables: Difference between revisions

Line 5:

Wednesday,201811281030,201811281430,10:30AM,2:30PM,Sports,Lower West Field,500,Ranked,Yes,You play the sports here

</data>

Preyansh, this might be way more complicated than you had in mind, so forgive me. It just has less room for human error, proooobably?

So in short here's what's going on. If the coords have a table that has the data laid out as below, where '''startnum''' and '''endnum''' are the YmdHi (concatenated timestamp sans seconds), we can insert that as comma separated syntax (see [[#The Data|the data]]) and then have it output in a table or other sort of fashion. This allows us to have all the event information accessible and reformattable from one location, as opposed to having to update say three locations at once.

I've not yet gone over with you what these alternative databases are.... In short, it's like mySQL but accessible to queries inside of the wiki. So when we input the information below, it creates and inserts information into a table called '''[[Table:E-Week 2019]]''' into the different fields we specify. Now that it's all neat and tidy in one place, you can query it (with some limitations...)

==The Input==

<pre>

Line 25:

Line 30:

{| class="wikitable"

! Event !! Location

! Event !! Location !!Time End

|-

</header>

{{#ifexpr:{{{startnum}}}<201811271900

|{{Test3|1={{{Event}}}|2={{{Location}}}}}

|{{Test3|1={{{Event}}}|2={{{Location}}}|3={{#time:H:iA|{{{endnum}}} }} }}

}}

@@ Line 5: / Line 5: @@
 Wednesday,201811281030,201811281430,10:30AM,2:30PM,Sports,Lower West Field,500,Ranked,Yes,You play the sports here
 </data>
+Preyansh, this might be way more complicated than you had in mind, so forgive me. It just has less room for human error, proooobably?
+So in short here's what's going on. If the coords have a table that has the data laid out as below, where '''startnum''' and '''endnum''' are the YmdHi (concatenated timestamp sans seconds), we can insert that as comma separated syntax (see [[#The Data|the data]]) and then have it output in a table or other sort of fashion. This allows us to have all the event information accessible and reformattable from one location, as opposed to having to update say three locations at once.
+I've not yet gone over with you what these alternative databases are.... In short, it's like mySQL but accessible to queries inside of the wiki. So when we input the information below, it creates and inserts information into a table called '''[[Table:E-Week 2019]]''' into the different fields we specify. Now that it's all neat and tidy in one place, you can query it (with some limitations...)
 ==The Input==
 <pre>
@@ Line 25: / Line 30: @@
 <header>
 {| class="wikitable"
-! Event !! Location
+! Event !! Location !!Time End
 |-
 </header>
 {{#ifexpr:{{{startnum}}}<201811271900
-|{{Test3|1={{{Event}}}|2={{{Location}}}}}
+|{{Test3|1={{{Event}}}|2={{{Location}}}|3={{#time:H:iA|{{{endnum}}} }} }}
 }}
 <footer>