EUSwiki

Create and Query Tables: Difference between revisions

← Older edit
VisualWikitext
No edit summary
No edit summary
 
(10 intermediate revisions by the same user not shown)
Line 1: Line 1:
<data table="E-Week 2019" fields="Start,End,Event,Location,Points,Rank/Tier,DoubleSub,Description,ASA,BUSS,BREE,CEUS,CHESS,CMEUS,ECSESS,MAME,MEUS,OLD">
<data table="E-Week 2019" fields="Event,Read,Description,Location,Start,End,DoubleSub,RankTier,Scale,Points,ASAscore,BUSSscore,BREEscore,CEUSscore,CHESSscore,CMEUSscore,ECSESSscore,MAMEscore,MEUSscore,OLDscore,ASAplace,BUSSplace,BREEplace,CEUSeach,CEUSplace,CHESSplace,CMEUSplace,ECSESSeach,ECSESSplace,MAMEeach,MAMEplace,MEUSplace,OLDplace,DamnThing,ASAdt,BUSSdt,BREEdt,CEUSdt,CHESSdt,CMEUSdt,ECSESSdt,MAMEdt,MEUSdt,OLDdt">
201811271700,101811271830,Captain's Challenge,[[Blues Pub]],0,N/A,No,The captain's go on a hunt for clues!,10,20,30,40,50,60,70,80,90,100
{{E-Wiki 2019}}</data>
201811271930,201811280230,Bus Trip to Nowhere,Nowhere,400,Ranked,No,TripleBogieNoDescription,1,2,3,4,5,6,7,8,9,10
201811280900,201811281000,Breakfast,Common Room,150,Tiered,No,This is where you eat food， points for participation,100,200,300,400,500,600,700,800,900,10000
201811281030,201811281430,Sports,Lower West Field,500,Ranked,Yes,You play the sports here,1000,2000,3000,4000,5000,6000,7000,8000,9000,10000
</data>
Preyansh, this might be way more complicated than you had in mind, so forgive me. I think it could be more automated, but if you'd rather another way it's ALL YOURS! This was fun for me, so if you want another way that's all good.
Preyansh, this might be way more complicated than you had in mind, so forgive me. I think it could be more automated, but if you'd rather another way it's ALL YOURS! This was fun for me, so if you want another way that's all good.


Line 21: Line 17:
==The Data==
==The Data==
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. Below is a full table of what is contained in that table, and will auto update as the information above is altered. It does not store anything, so if the above text is removed the table would have no information.
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. Below is a full table of what is contained in that table, and will auto update as the information above is altered. It does not store anything, so if the above text is removed the table would have no information.
<repeat table="E-Week 2019"></repeat>
<tab collapsed><repeat table="E-Week 2019"></repeat></tab>


==Output Examples==
==Output Examples==
Line 41: Line 37:
|-
|-
</header>
</header>
{{#ifexpr:{{{Start}}}<201811271900
{{#ifexpr:{{{Start|0}}}>201811271900|{{Test3|1={{{Event}}}|2={{{Location}}}|3={{#time:H:iA|{{{End}}} }} }}|
|{{Test3|1={{{Event}}}|2={{{Location}}}|3={{#time:H:iA|{{{End}}} }} }}
}}
}}
<footer>
<footer>
Line 48: Line 43:
</footer>
</footer>
</repeat>
</repeat>
===Bulleted===
===Bulleted===
;Criteria  
;Criteria  
Retrieved from "https://euswiki.mcgilleus.ca/Create_and_Query_Tables"