Template:Item query: Difference between revisions
From Chinese Religious Text Authority
No edit summary |
(Added pinyin keyword search) |
||
| 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 HOLDS 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:21, 28 June 2023
This is the 'Item query' template. It should be called via the Form:Item query form.
