Test cargo: Difference between revisions

Latest revision as of 10:42, 24 October 2021

2705

@@ Line 1: / Line 1: @@
-==Added model references==
+{{#count:
-To be posted soon (AK: October 22, 2021)<br>
+{{
-Testing:
+#cargo_query:tables=BibEntryCargo,_pageData
-<small>
-{| style="width:65%;
-| '''Year'''
-|align="left"| '''Total references in database & ''(added per calendar year)'''''
-|-
-| 2021
-|{{#cargo_query:tables=BibEntryCargo,_pageData
 |join on=BibEntryCargo._pageName = _pageData._pageName
 |fields=BibEntryCargo._pageName= _pageData._creationDate,COUNT(*)
-|where=  _pageData._creationDate LIKE '%2021%' OR _pageData._creationDate LIKE '%2020%' OR _pageData._creationDate LIKE '%2019%' OR _pageData._creationDate LIKE '%2018%' OR _pageData._creationDate LIKE '%2017%' OR _pageData._creationDate LIKE '%2016%' OR _pageData._creationDate LIKE '%2015%' OR _pageData._creationDate LIKE'%2014%' OR _pageData._creationDate LIKE'%2013%'
-|format=template|template=CountingCARGO}} ''({{#cargo_query:tables=BibEntryCargo,_pageData
+|limit=5000
-|join on=BibEntryCargo._pageName = _pageData._pageName
-|fields=BibEntryCargo._pageName= _pageData._creationDate,COUNT(*)
+|where=  _pageData._creationDate LIKE '%2021%'  GROUP BY BibEntryCargo._pageName
-|where=  _pageData._creationDate LIKE '%2021%'
+|format=template|template=CountingCARGO
-|format=template|template=CountingCARGO}})''
+}}
-|-
-|}</small>
+|1}}