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__publication_places._rowID
|join on=Item_infobox._ID=Item_infobox__publication_places._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__full HOLDS LIKE '%{{{creators|}}}%'
|where=title LIKE '%{{{title|}}}%' AND publication_places HOLDS LIKE '%{{{publication_place|}}}%' AND format LIKE '%{{{format|}}}%' AND creator_list HOLDS LIKE '%{{{creators|}}}%'
|group by=Item_infobox._ID
|group by=Item_infobox._ID
|order by="date", "date_start"
|order by="date", "date_start"

Revision as of 10:55, 9 April 2021

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