Template:Item query: Difference between revisions
From Chinese Religious Text Authority
No edit summary |
No edit summary |
||
Line 8: | Line 8: | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=Item_infobox, Item_infobox__publication_places, Item_infobox__creator_list | tables=Item_infobox, Item_infobox__publication_places, Item_infobox__creator_list | ||
|join on=Item_infobox._ID=Item_infobox__publication_places._rowID | |join on=Item_infobox._ID=Item_infobox__publication_places._rowID, Item_infobox._ID=Item_infobox__creator_list._rowID | ||
|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,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=title LIKE '%{{{title|}}}%' AND publication_places HOLDS LIKE '%{{{publication_place|}}}%' AND format LIKE '%{{{format|}}}%' AND creator_list HOLDS LIKE '%{{{creators|}}}%' | |where=title LIKE '%{{{title|}}}%' AND publication_places HOLDS LIKE '%{{{publication_place|}}}%' AND format LIKE '%{{{format|}}}%' AND creator_list HOLDS LIKE '%{{{creators|}}}%' |
Revision as of 10:58, 9 April 2021
This is the 'Item query' template. It should be called via the Form:Item query form.