Template:Item query: Difference between revisions

From Chinese Religious Text Authority
No edit summary
mNo edit summary
Line 9: Line 9:
tables=Item_infobox, Item_infobox__creator_list
tables=Item_infobox, Item_infobox__creator_list
|join on=Item_infobox._ID=Item_infobox__creator_list._rowID
|join on=Item_infobox._ID=Item_infobox__creator_list._rowID
|fields=_pageName=title,Item_infobox__creator_list__full
|fields=_pageName=title
|where=Item_infobox__creator_list.__value= '%{{{creator|}}}%'
|format=ol
|intro=Results so far
|where=title HOLDS '%{{{title|}}}%' AND UPPER(pinyin_title) HOLDS ('%{{{pinyin_title|}}}%') AND creator_list HOLDS '%{{{creator|}}}%'
|default=No Results
|group by=Item_infobox._pageName
|format=ul
}}
}}
</includeonly>
</includeonly>

Revision as of 14:13, 1 June 2020

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