Template:Item query: Difference between revisions
From Chinese Religious Text Authority
No edit summary |
No edit summary |
||
Line 17: | Line 17: | ||
IF("{{{publisher|}}}" = "", TRUE, publishers HOLDS LIKE '%{{{publisher|}}}%') AND | IF("{{{publisher|}}}" = "", TRUE, publishers HOLDS LIKE '%{{{publisher|}}}%') AND | ||
IF("{{{year_exact|}}}" = "", TRUE, YEAR(date) = "{{{year_exact|}}}" OR (YEAR(date_start) <= "{{{year_exact|}}}" AND YEAR(date_end) >= "{{{year_exact|}}}")) AND | IF("{{{year_exact|}}}" = "", TRUE, YEAR(date) = "{{{year_exact|}}}" OR (YEAR(date_start) <= "{{{year_exact|}}}" AND YEAR(date_end) >= "{{{year_exact|}}}")) AND | ||
IF("{{{year_min|}}}" = "", TRUE, YEAR(date) > "{{{year_min|}}}" OR YEAR(date_start) > "{{{year_min|}}}") AND | |||
IF("{{{year_max|}}}" = "", TRUE, YEAR(date) < "{{{year_max|}}}" OR YEAR(date_end) < "{{{year_max|}}}") | IF("{{{year_max|}}}" = "", TRUE, YEAR(date) < "{{{year_max|}}}" OR YEAR(date_end) < "{{{year_max|}}}") | ||
Revision as of 18:33, 26 May 2021
This is the 'Item query' template. It should be called via the Form:Item query form.