Template:Item query: Difference between revisions

Revision as of 12:13, 12 April 2021

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

@@ Line 7: / Line 7: @@
 {{#cargo_query:
-tables=Item_infobox=Infobox, Item_infobox.title_list__full=TitleList
+tables=Item_infobox, Item_infobox__publication_places
-|join on=Infobox.title_list__full=TitleList._ID
+|join on=Item_infobox._ID=Item_infobox__publication_places._rowID
-|fields=_pageName=Entry, title_list__full=Title List, 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=Infobox.title LIKE '%{{{title|}}}%' AND TitleList HOLDS LIKE '%{{{title|}}}%' AND Infobox.format LIKE '%{{{format|}}}%'
+|where=title LIKE '%{{{title|}}}%' AND publication_places HOLDS LIKE '%{{{publication_place|}}}%' AND format LIKE '%{{{format|}}}%'
-|group by=Infobox._ID
+|group by=Item_infobox._ID
 |order by="date", "date_start"