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= Level>= {{{LevelLow}}} AND
+|where=
+{{#if:
+  {{{LevelLow|}}}
+  |Level >= '{{{LevelLow|}}}' AND
+}}
+{{#if:
+   {{{LevelHi|}}}
+   |Level <= '{{{LevelHi|}}}' AND
+}}
+{{#if:
+   {{{Tonic|}}}
+   |Tonic= '{{{Tonic|}}}' AND
+}}
+{{#if:
+   {{{Mode|}}}
+   |Mode= '{{{Mode|}}}' AND
+}}
+{{#if:
+   {{{Tempo|}}}
+   |Tempo= '{{{Tempo|}}}' AND
+}}
+{{#if:
+   {{{Period|}}}
+   |Period = '{{{Period|}}}' AND
+}}
+{{#if:
+   {{{Mood|}}}
+   |Mood= '{{{Mood|}}}' AND
+}}
 _pageID > 0
-|format=dynamic table
+|format=table
 }}
 </includeonly>