Difference between revisions of "Template:RepQ1"

Revision as of 19:41, 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 LIKE "{{{Tonic|}}}"| AND
+|where=
-   Mode LIKE "{{{Mode|}}}"| AND
+{{#if:
-   Tempo LIKE "{{{Tempo|}}}"| AND
+   {{{LevelLo|}}}
-  Period LIKE "%{{{Period|}}}%"| AND
+   |Level > '{{{LevelLo|}}}' AND
-  Mood LIKE "{{{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>