Template:Item query: Difference between revisions

From Chinese Religious Text Authority
No edit summary
mNo edit summary
 
(161 intermediate revisions by 2 users not shown)
Line 7: Line 7:


{{#cargo_query:
{{#cargo_query:
tables=Item_infobox, Item_infobox__creator_list
tables=Item_infobox
|join on=Item_infobox._ID=Item_infobox__creator_list._rowID
 
|fields=_pageName=Page,title=title,pinyin_title=pinyin title,title_list__full=title list,publication_places__full=publication places,format=format,creator_list__full=creator list,date=date,date_start=date start,date_end=date end,publishers__full=publishers
|fields=_pageName=Entry, pinyin_title=Library Pinyin Title, 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 UPPER(pinyin_title) LIKE '%{{{pinyin_title|}}}%' AND creator_list HOLDS LIKE '%{{{creator|}}}%'
 
|order by="_pageName", "year", "year_start", "publication_places__full"
|where=IF("{{{title|}}}" = "", TRUE, title LIKE '%{{{title|}}}%' OR title_list HOLDS LIKE '%{{{title|}}}%') AND
|limit=3000
      IF("{{{pinyin|}}}" = "", TRUE, pinyin_title LIKE '%{{{pinyin|}}}%') AND
      IF("{{{publication_place|}}}" = "", TRUE, publication_places HOLDS LIKE '%{{{publication_place|}}}%') AND
      IF("{{{format|}}}" = "", TRUE, format = '{{{format|}}}') AND
      IF("{{{creators|}}}" = "", TRUE, creator_list HOLDS LIKE '%{{{creators|}}}%') AND
      IF("{{{publisher|}}}" = "", TRUE, publishers HOLDS LIKE '%{{{publisher|}}}%') AND
      IF("{{{year_exact|}}}" = "", TRUE, YEAR(date) = "{{{year_exact|}}}" OR (YEAR(date_start) <= "{{{year_exact|}}}" AND YEAR(date_end) >= "{{{year_exact|}}}")) AND
      IF("{{{year_min|}}}" = "", TRUE, YEAR(date) >= "{{{year_min|}}}" OR YEAR(date_start) >= "{{{year_min|}}}") AND
      IF("{{{year_max|}}}" = "", TRUE, YEAR(date) <= "{{{year_max|}}}" OR YEAR(date_end) <= "{{{year_max|}}}")
 
|group by=Item_infobox._ID
 
|order by=-COALESCE(date, date_start) DESC
 
|format=dynamic table
|rows per page=50
|limit=10000
}}
}}
</includeonly>
</includeonly>

Latest revision as of 08:24, 28 June 2023

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


Retrieved from "https://crta.info/index.php?title=Template:Item_query&oldid=11687"