Template:Item query: Difference between revisions

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