Template:Item query: Difference between revisions
From Chinese Religious Text Authority
No edit summary |
No edit summary |
||
| Line 7: | Line 7: | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=Item_infobox, Item_infobox__creator_list, | tables=Item_infobox, Item_infobox__creator_list, creator_list | ||
|join on=Item_infobox._ID=Item_infobox||creator_list._rowID | |join on=Item_infobox._ID=Item_infobox||creator_list._rowID,Item_infobox__creator_list._value=creator_list._pageName | ||
|fields=_pageName=title | |fields=_pageName=title | ||
|format=ol | |format=ol | ||
| Line 14: | Line 14: | ||
AND UPPER(pinyin_title) LIKE UPPER('%{{{pinyin_title|}}}%') | AND UPPER(pinyin_title) LIKE UPPER('%{{{pinyin_title|}}}%') | ||
AND creator_list HOLDS LIKE '%{{{creator|}}}%' | AND creator_list HOLDS LIKE '%{{{creator|}}}%' | ||
|group by=Item_infobox._pageName | |group by=Item_infobox._pageName | ||
}} | }} | ||
</includeonly> | </includeonly> | ||
Revision as of 12:19, 20 May 2020
This is the 'Item query' template. It should be called via the Form:Item query form.
