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 12: / Line 12: @@
 Mood contains "{{{Mood|}}}):
-{{#cargo_query:table=Repertoire
+{{#cargo_query:
-|fields=Composer, Title, Catalog, _pageName = LinkToPage
+tables=Repertoire
-|where=Level = {{{Level|}}} AND
+|fields=_pageName=Repertoire, Level, _pageID
-   Tonic = "{{{Tonic|}}}"| AND
+|where=
-   Mode = "{{{Mode|}}}"| AND
+{{#if:
-  Tempo = "{{{Tempo|}}}"| AND
+   {{{Level|}}}
-  Period LIKE "%{{{Period|}}}%"| AND
+   |Level = '{{{Level|}}}' AND
-  Mood = "{{{Mood|}}}"
-|format = dynamic table
 }}
+{{#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>