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__publication_places
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
Line 13: Line 13:
|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|}}}%'
|where=title LIKE '%{{{title|}}}%' AND creator_list HOLDS LIKE '%{{{creators}}}%' AND publication_places HOLDS LIKE '%{{{publication_place|}}}%' AND format LIKE '%{{{format|}}}%'


|group by=Item_infobox._ID
|group by=Item_infobox._ID

Revision as of 12:22, 12 April 2021

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