Template:Item query: Difference between revisions
From Chinese Religious Text Authority
No edit summary |
No edit summary |
||
| Line 9: | Line 9: | ||
tables=Item_infobox=Infobox, Item_infobox__title_list=TitleList, Item_infobox__publication_places=PublicationPlaces | tables=Item_infobox=Infobox, Item_infobox__title_list=TitleList, Item_infobox__publication_places=PublicationPlaces | ||
|join on= | |join on=Infobox._ID=Item_infobox__publication_places._rowID, Item_infobox__publication_places._rowID=Item_infobox__title_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 | ||
| Line 15: | Line 15: | ||
|where=title LIKE '%{{{title|}}}%' AND title_list HOLDS LIKE '%{{{title|}}}%' AND publication_places HOLDS LIKE '%{{{publication_place|}}}%' AND format LIKE '%{{{format|}}}%' | |where=title LIKE '%{{{title|}}}%' AND title_list HOLDS LIKE '%{{{title|}}}%' AND publication_places HOLDS LIKE '%{{{publication_place|}}}%' AND format LIKE '%{{{format|}}}%' | ||
|group by= | |group by=Infobox._ID | ||
|order by="date", "date_start" | |order by="date", "date_start" | ||
Revision as of 12:01, 12 April 2021
This is the 'Item query' template. It should be called via the Form:Item query form.
