Flag of England.gif

Template

Casesummary-table: Difference between revisions

No edit summary
No edit summary
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
<includeonly>{{#ifeq:{{{noheader|}}} |true| |<br/>The old category structure used on this page is comprehensive as it contains every relevant case. The new database structure was introduced in 2019. It is more potentially useful than the old categorisation system: it includes all cases since January 2018, but only a minority of older cases: see [[Special:Drilldown/Cases]]. The pages below are initially ordered according to the dates on which they were added to the site (most recent first). The order can be changed by clicking on the symbol beside a column heading: click on the symbol beside "Page and summary" for alphabetical order; click beside "Categories" for the order in which the cases were reported. Click on the arrow symbol again to reverse the order. Click on a page name to view the relevant page. Asterisks mark those cases which have been added to the new database structure.}}
<includeonly>{{#ifeq:{{{noheader|}}} |true| |<br/>The old category structure used on this page is comprehensive as it contains every relevant case. The new database structure was introduced in 2019, and is more potentially useful than the old categorisation system: it includes all cases since January 2016 (browse at [[Special:Drilldown/Cases]]) but only a minority of older cases. Asterisks below mark those cases which have been added to the new database structure.
 
The pages below are initially ordered according to the dates on which they were added to the site (most recent first). The order can be changed by clicking on the symbol beside a column heading: click on the symbol beside "Page and summary" for alphabetical order; click beside "Categories" for the order in which the cases were reported. Click on the arrow symbol again to reverse the order. Click on a page name to view the relevant page. }}
{|class="cargoTable noMerge sortable jquery-tablesorter"  
{|class="cargoTable noMerge sortable jquery-tablesorter"  
! width=80% | Case and summary
! width=80% | Case and summary
Line 10: Line 12:
|fields=_pageData._pageTitle=Casename,    _pageData._creationDate=Created,    _pageData._categories__full=Categories
|fields=_pageData._pageTitle=Casename,    _pageData._creationDate=Created,    _pageData._categories__full=Categories
|group by=_pageData._pageTitle, _pageData._creationDate, _pageData._categories__full, _pageData._creationDate__precision
|group by=_pageData._pageTitle, _pageData._creationDate, _pageData._categories__full, _pageData._creationDate__precision
|where=Cases.Subject HOLDS '{{{c}}}' OR _categories HOLDS '{{#replace:{{{c}}}| |_}}'  
|where=Cases.Subject HOLDS '{{{c}}}' OR _categories HOLDS '{{{c}}}'  
|limit={{#if:{{{limit|}}} | {{{limit|}}} | 200}}
|limit={{#if:{{{limit|}}} | {{{limit|}}} | 200}}
|order by= _pageData._creationDate DESC
|order by= _pageData._creationDate DESC

Latest revision as of 11:53, 2 April 2025