Template:Item query: Difference between revisions
From Chinese Religious Text Authority
No edit summary |
No edit summary |
||
| Line 10: | Line 10: | ||
|join on=Item_infobox._ID=Item_infobox__creator_list._rowID | |join on=Item_infobox._ID=Item_infobox__creator_list._rowID | ||
|fields=_pageName=Page,pinyin_title=pinyin title,title_list__full=title list,publication_places__full=publication places,format=format,creator_list__full=creator list,date=date,date_start=date start,date_end=date end,publishers__full=publishers | |fields=_pageName=Page,pinyin_title=pinyin title,title_list__full=title list,publication_places__full=publication places,format=format,creator_list__full=creator list,date=date,date_start=date start,date_end=date end,publishers__full=publishers | ||
|where=title LIKE '%{{{title|}}}%' AND UPPER(pinyin_title) LIKE '%{{{pinyin_title|}}}%' AND creator_list HOLDS LIKE '%{{{creator|}}}%' | |where=title LIKE '%{{{title|}}}%' AND UPPER(pinyin_title) LIKE '%{{{pinyin_title|}}}%' AND creator_list HOLDS LIKE '%{{{creator|}}}%' AND publishers__full HOLDS LIKE '%{{{publication_place|}}}%' | ||
|group by=Item_infobox._ID | |group by=Item_infobox._ID | ||
|order by="date", "date_start", "_pageName", "publication_places__full" | |order by="date", "date_start", "_pageName", "publication_places__full" | ||
Revision as of 12:00, 8 April 2021
This is the 'Item query' template. It should be called via the Form:Item query form.
