Template:Item query: Difference between revisions

From Chinese Religious Text Authority
No edit summary
mNo edit summary
 
(5 intermediate revisions by the same user not shown)
Line 9: Line 9:
tables=Item_infobox
tables=Item_infobox


|fields=_pageName=Entry, creator_list__full=List of Creators, format=Format, publication_places__full=Publication place(s), publishers__full=Publisher(s), date=Date, date_start=Start Date, date_end=End Date
|fields=_pageName=Entry, pinyin_title=Library Pinyin Title, creator_list__full=List of Creators, format=Format, publication_places__full=Publication Place(s), publishers__full=Publisher(s), date=Date, date_start=Start Date, date_end=End Date


|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|}}}" = "", TRUE, pinyin_title LIKE '%{{{pinyin|}}}%') 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

Latest revision as of 08:24, 28 June 2023

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