Template:Item query: Difference between revisions

Revision as of 12:48, 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, Item_infobox__creator_list
+tables=Item_infobox, Item_infobox__publication_places
-|join on=Item_infobox._ID=Item_infobox__creator_list._rowID
-|fields=_pageName=title,Item_infobox__creator_list__full
+|join on=Item_infobox._ID=Item_infobox__publication_places._rowID
-|where=Item_infobox__creator_list.__value= '%{{{creator|}}}%'
-|intro=Results so far
+|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
-|default=No Results
-|format=ul
+|where=title LIKE '%{{{title|}}}%' AND publication_places HOLDS LIKE '%{{{publication_place|}}}%' AND format LIKE '%{{{format|}}}%'
+|group by=Item_infobox._ID
+|order by="date", "date_start"
+|format=dynamic table
+|rows per page=50
+|limit=10000
 }}
 </includeonly>