Template:Item query: Difference between revisions

From Chinese Religious Text Authority
mNo edit summary
mNo edit summary
Line 9: Line 9:
|fields=_pageName=title
|fields=_pageName=title
|format=ul
|format=ul
|where=title LIKE '%{{{title|}}}%' AND UPPER(pinyin_title) LIKE UPPER('%{{{pinyin_title|}}}%') AND publication_places HOLDS LIKE '%{{{publication_place|}}}%' AND date >= '{{{year_min|}}}-01-01' AND date <= '{{{year_max|}}}-01-01'
|where=title LIKE '%{{{title|}}}%' AND UPPER(pinyin_title) LIKE UPPER('%{{{pinyin_title|}}}%') AND publication_places HOLDS LIKE '%{{{publication_place|}}}%' AND date >= 'CAST({{{year_min|}}} AS DATE)'
}}
}}
</includeonly>
</includeonly>

Revision as of 13:30, 18 May 2020

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