Difference between revisions of "Template:RepQ2"

From PianoPedaWiki
Jump to navigation Jump to search
 
(12 intermediate revisions by the same user not shown)
Line 7: Line 7:
</noinclude>
</noinclude>
<includeonly>
<includeonly>
{| class="wikitable"
 
! LevelLow
| {{{LevelLow|}}}
|-
! LevelHi
| {{{LevelHi|}}}
|-
! Tonic
| {{{Tonic|}}}
|-
! Mode
| {{{Mode|}}}
|-
! Tempo
| {{{Tempo|}}}
|-
! Period
| {{{Period|}}}
|-
! Mood
| {{{Mood|}}}
|}


{{#cargo_query:
{{#cargo_query:
tables=Repertoire
tables=Repertoire
|fields=_pageName=RepertoirePage, Level, _pageID
|fields= Title, Composer,Level,_pageName=RepertoirePage
|where=
|where=  
{{#if:
{{#if:
   {{{LevelLow|}}}
   {{{LevelLow|}}}
   |Level > '{{{LevelLow|}}}' AND
   |Level >= '{{{LevelLow|}}}' AND
}}
}}
{{#if:
{{#if:
   {{{LevelHi|}}}
   {{{LevelHi|}}}
   |Level < '{{{LevelHi|}}}' AND
   |Level <= '{{{LevelHi|}}}' AND
}}
}}
{{#if:
{{#if:
   {{{Period|}}}
   {{{Tonic|}}}
   |Period = '{{{Period|}}}' AND
   |Tonic= '{{{Tonic|}}}' AND
}}
}}
{{#if:
{{#if:
   {{{Mode|}}}
   {{{Mode|}}}
   |Mode = '{{{Mode|}}}' AND
   |Mode= '{{{Mode|}}}' AND
}}
}}
{{#if:
{{#if:
   {{{Tempo|}}}
   {{{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>
</includeonly>

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.