Template:Item query: Difference between revisions
From Chinese Religious Text Authority
(Added pinyin keyword search) |
mNo edit summary |
||
Line 12: | Line 12: | ||
|where=IF("{{{title|}}}" = "", TRUE, title LIKE '%{{{title|}}}%' OR title_list HOLDS LIKE '%{{{title|}}}%') AND | |where=IF("{{{title|}}}" = "", TRUE, title LIKE '%{{{title|}}}%' OR title_list HOLDS LIKE '%{{{title|}}}%') AND | ||
IF("{{{pinyin_title|}}}" = "", TRUE, pinyin | IF("{{{pinyin_title|}}}" = "", TRUE, pinyin LIKE '%{{{pinyin_title|}}}%') AND | ||
IF("{{{publication_place|}}}" = "", TRUE, publication_places HOLDS LIKE '%{{{publication_place|}}}%') AND | IF("{{{publication_place|}}}" = "", TRUE, publication_places HOLDS LIKE '%{{{publication_place|}}}%') AND | ||
IF("{{{format|}}}" = "", TRUE, format = '{{{format|}}}') AND | IF("{{{format|}}}" = "", TRUE, format = '{{{format|}}}') AND |
Revision as of 08:22, 28 June 2023
This is the 'Item query' template. It should be called via the Form:Item query form.