Difference between revisions of "Template:RepQ2"

Latest revision as of 20:30, 23 March 2022

This is the Repertoire Query, attempt 2 at a query form. Form:RepQ2 to call in RunQuery This is the "RepQ2" template.

It should be called in the following format:

{{RepQ2
|LevelLow=
|LevelHi=
|Tonic=
|Mode=
|Tempo=
|Period=
|Mood=
}}

Edit the page to see the template text.

@@ Line 7: / Line 7: @@
 </noinclude>
 <includeonly>
-{| class="wikitable"
-! LevelLow
-| {{{LevelLow|}}}
-|-
-! LevelHi
-| {{{LevelHi|}}}
-|-
-! Tonic
-| {{{Tonic|}}}
-|-
-! Mode
-| {{{Mode|}}}
-|-
-! Tempo
-| {{{Tempo|}}}
-|-
-! Period
-| {{{Period|}}}
-|-
-! Mood
-| {{{Mood|}}}
-|}
 {{#cargo_query:
 tables=Repertoire
-|fields=_pageName=RepertoirePage, Level, _pageID
+|fields= Title, Composer,Level,_pageName=RepertoirePage
 |where=
 {{#if:
    {{{LevelLow|}}}
-   |Level > '{{{LevelLow|}}}' AND
+   |Level >= '{{{LevelLow|}}}' AND
 }}
 {{#if:
     {{{LevelHi|}}}
-    |Level < '{{{LevelHi|}}}' AND
+    |Level <= '{{{LevelHi|}}}' AND
 }}
 {{#if:
-    {{{Period|}}}
+    {{{Tonic|}}}
-    |Period = '{{{Period|}}}' AND
+    |Tonic= '{{{Tonic|}}}' AND
 }}
 {{#if:
     {{{Mode|}}}
-    |Mode = '{{{Mode|}}}' AND
+    |Mode= '{{{Mode|}}}' AND
 }}
 {{#if:
     {{{Tempo|}}}
-    |Tempo = '{{{Tempo|}}}' AND
+    |Tempo= '{{{Tempo|}}}' AND
+}}
+{{#if:
+   {{{Period|}}}
+   |Period = '{{{Period|}}}' AND
+}}
+{{#if:
+   {{{Mood|}}}
+   |Mood= '{{{Mood|}}}' AND
 }}
-_pageID > '0'
+_pageID > 0
-|format=dynamic table
+|format=table
 }}
+</includeonly>