Create and Query Tables: Difference between revisions

Line 1:

Tuesday,201811271700,101811271830,5:00PM,6:30PM,Captain's Challenge,[[Blues Pub]],0,N/A,No,The captain's go on a hunt for clues!

Tuesday,201811271930,201811280230,7:30PM,2:30AM,Bus Trip to Nowhere,400,Ranked,No,TripleBogieNoDescription

Tuesday,201811271930,201811280230,7:30PM,2:30AM,Bus Trip to Nowhere,Nowhere,400,Ranked,No,TripleBogieNoDescription

Wednesday,201811280900,201811281000,9:00AM,10:00AM,Breakfast,150,Tiered,No,This is where you eat food\, points for participation

Wednesday,201811280900,201811281000,9:00AM,10:00AM,Breakfast,Common Room,150,Tiered,No,This is where you eat food\, points for participation

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

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

</data>

==Full Data==

Line 9:

===Table===

;Criteria

:Start Time > 201811271900 ''({{#time:Y-m-d H:i|201811271900}})''

:Start Time < 201811271900 ''({{#time:Y-m-d H:i|201811271900}})''

Line 24:

</repeat>

===Other===

<repeat table="E-Week 2019">{{#ifexpr:{{{startnum}}}<201811271900

;Criteria

:Start Time > 201811271900 ''({{#time:Y-m-d H:i|201811271900}})''

----

<repeat table="E-Week 2019">{{#ifexpr:{{{startnum}}}>201811271900

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

}}</repeat>

@@ Line 1: / Line 1: @@
 <data table="E-Week 2019" fields="Day,startnum,endnum,Start,End,Event,Location,Points,Type,Double,Description">
 Tuesday,201811271700,101811271830,5:00PM,6:30PM,Captain's Challenge,[[Blues Pub]],0,N/A,No,The captain's go on a hunt for clues!
-Tuesday,201811271930,201811280230,7:30PM,2:30AM,Bus Trip to Nowhere,400,Ranked,No,TripleBogieNoDescription
+Tuesday,201811271930,201811280230,7:30PM,2:30AM,Bus Trip to Nowhere,Nowhere,400,Ranked,No,TripleBogieNoDescription
-Wednesday,201811280900,201811281000,9:00AM,10:00AM,Breakfast,150,Tiered,No,This is where you eat food\, points for participation
+Wednesday,201811280900,201811281000,9:00AM,10:00AM,Breakfast,Common Room,150,Tiered,No,This is where you eat food\, points for participation
-Wednesday,201811281030,201811281430,10:30AM,2:30PM,Sports,500,Ranked,Yes,You play the sports here
+Wednesday,201811281030,201811281430,10:30AM,2:30PM,Sports,Lower West Field,500,Ranked,Yes,You play the sports here
 </data>
 ==Full Data==
@@ Line 9: / Line 9: @@
 ===Table===
 ;Criteria
-:Start Time > 201811271900 ''<small>({{#time:Y-m-d H:i|201811271900}})</small>''
+:Start Time < 201811271900 ''<small>({{#time:Y-m-d H:i|201811271900}})</small>''
 <repeat table="E-Week 2019">
 <header>
@@ Line 24: / Line 24: @@
 </repeat>
 ===Other===
-<repeat table="E-Week 2019">{{#ifexpr:{{{startnum}}}<201811271900
+;Criteria
+:Start Time > 201811271900 ''<small>({{#time:Y-m-d H:i|201811271900}})</small>''
+----
+<repeat table="E-Week 2019">{{#ifexpr:{{{startnum}}}>201811271900
 |{{Test4|1={{{Event}}}|2={{{Location}}}}}
 }}</repeat>