Difference between revisions of "Template:RepQ1"

Latest revision as of 19:42, 17 March 2022

This is the 'RepQ1' template. It should be called via the Form:RepQ1 form.

@@ Line 6: / Line 6: @@
 Repertoire that that match this query
 (Level contains "{{{Level|}}}",
-Period contains "{{{Period|}}}"):
+Tonic contains "{{{Tonic|}}},
+Mode contains "{{{Mode|}}},
+Tempo contains "{{{Tempo|}}},
+Period contains "{{{Period|}}}",
+Mood contains "{{{Mood|}}}):
-{{#cargo_query:table=Repertoire
+{{#cargo_query:
-|fields=Composer, Title, Catalog, _pageName = LinkToPage
+tables=Repertoire
-|where=Level = {{{Level|}}} AND Period LIKE "%{{{Period|}}}%"|
+|fields=_pageName=Repertoire, Level, _pageID
-format = dynamic table
+|where=
+{{#if:
+  {{{Level|}}}
+  |Level = '{{{Level|}}}' AND
 }}
+{{#if:
+   {{{LevelHi|}}}
+   |Level < '{{{LevelHi|}}}' AND
+}}
+{{#if:
+   {{{Period|}}}
+   |Period = '{{{Period|}}}' AND
+}}
+{{#if:
+   {{{Mode|}}}
+   |Mode = '{{{Mode|}}}' AND
+}}
+{{#if:
+   {{{Tempo|}}}
+   |Tempo = '{{{Tempo|}}}' AND
+}}
+_pageID > '0'
+|format=dynamic table
+}}
 </includeonly>