Casesummary-table: Difference between revisions
No edit summary |
No edit summary |
||
| (36 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
<includeonly>{{# | <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. | ||
{|class="cargoTable" | |||
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" | |||
! width=80% | Case and summary | ! width=80% | Case and summary | ||
! width=10% |Date added | ! width=10% |Date added | ||
! width=10% | Categories | ! width=10% | Categories | ||
|- | |- | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=_pageData | tables=_pageData, Cases | ||
|fields=_pageTitle=Casename, _creationDate=Created, _categories__full=Categories | |join on=_pageData._pageName = Cases._pageName | ||
|where= | |fields=_pageData._pageTitle=Casename, _pageData._creationDate=Created, _pageData._categories__full=Categories | ||
|group by=_pageData._pageTitle, _pageData._creationDate, _pageData._categories__full, _pageData._creationDate__precision | |||
|where=Cases.Subject HOLDS '{{{c}}}' OR _categories HOLDS '{{{c}}}' | |||
|limit={{#if:{{{limit|}}} | {{{limit|}}} | 200}} | |limit={{#if:{{{limit|}}} | {{{limit|}}} | 200}} | ||
|order by= _creationDate DESC | |order by= _pageData._creationDate DESC | ||
|format= template | |format= template | ||
|template=Casesummary-table-row | |template=Casesummary-table-row | ||
|named args=yes | |named args=yes | ||
|more results text= | |||
}} | }} | ||
|}</includeonly> | |||
|} | |||
</includeonly> | |||