Template:Topic: Difference between revisions

From Discourse DB
Jump to navigation Jump to search
(Improving formatting)
No edit summary
(111 intermediate revisions by 3 users not shown)
Line 1: Line 1:
This is a [[is of type::Type:Topic]]
<noinclude>This template holds information on a political topic. It should be called in the following format:
<pre>
{{Topic
|Start date=The date at which the topic started, if there was one
|End date=The date at which the topic ended, if there was one
|Themes=The theme(s) of this topic, separated by commas if there's more than one
}}
</pre>
An example of start and end date would be, if the topic is a bill, the date the bill was introduced in Congress, and the date it was signed into law, respectively.


Event date: [[event date:={{{date|unknown}}}]]
The order of the fields is not relevant.
{{#cargo_declare:_table=Topics|Start_date=Date|End_date=Date|Themes=List (,) of String (allowed values=Africa, Asia, International relations, Middle East, Terrorism, United Kingdom domestic politics, United States domestic politics, War)}}
</noinclude><includeonly>{{#cargo_store:_table=Topics|Start_date={{{start date|}}}|End_date={{{end date|}}}|Themes={{{Themes|}}} }}
This is a [[:Category:Topics|topic]], with {{#if:{{{start date|}}}|start date {{{start date}}}|unknown start date}} and {{#if:{{{end date|}}}|end date {{{end date}}}|unknown end date}}.


Event end date: [[event end date:={{{date|unknown}}}]]
Its theme(s) are {{#arraymap:{{{Themes|}}}|,|x|[[x]]}}.


All opinions that address this topic:
==Summary of positions for this topic==
<ask> [[Addresses topic::{{PAGENAME}}]] </ask>
{{#cargo_query:tables=Items,Opinions
|join on=Items._pageName=Opinions._pageName
|fields=concat(Opinions.Position_link, ' (', count(*), ' items)')
|group by=Opinions.Position
|where=Opinions.Topic="{{PAGENAME}}"
|order by=Items.Date
|format=ul
}}


'''Positive opinions on this topic''':
==Full listing==
<ask format="OpinionQuery">[[Addresses topic::{{PAGENAME}}]][[Takes position:=For]][[Was written by::*]][[Published by::*]][[Published on:=*]][[Url:=*]][[Quote:=*]]</ask>
''Click on position names to view quotes from each listed item.''


'''Negative opinions on this topic''':
{{#cargo_query:tables=Items,Opinions
<ask format="OpinionQuery">[[Addresses topic::{{PAGENAME}}]][[Takes position:=Against]][[Was written by::*]][[Published by::*]][[Published on:=*]][[Url:=*]][[Quote:=*]]</ask>
|join on=Items._pageName=Opinions._pageName
|fields=Items.Summary,Opinions.Position_link,Opinions.Stance
|where=Opinions.Topic="{{PAGENAME}}"
|format=ddb outline
|outline fields=Position_link,Stance
|order by=CONCAT(CASE Stance
        WHEN 'for' THEN 1
        WHEN 'against' THEN 2
        WHEN 'mixed' THEN 3
        END), Date DESC
}}


'''Mixed opinions on this topic''':
==All items that address this topic ({{#cargo_query:tables=Items,Opinions
<ask format="OpinionQuery">[[Addresses topic::{{PAGENAME}}]][[Takes position:=Mixed]][[Was written by::*]][[Published by::*]][[Published on:=*]][[Url:=*]][[Quote:=*]]</ask>
|join on=Items._pageName=Opinions._pageName
|fields=count(DISTINCT Items._pageName)
|where=Opinions.Topic="{{PAGENAME}}"
}} total)==
 
{{#cargo_query:tables=Items,Opinions
|join on=Items._pageName=Opinions._pageName
|fields=Items._pageName=Title,Items.Author,Items.Source,Items.Date
|where=Opinions.Topic="{{PAGENAME}}"
|order by=Items.Date
|group by=Items._pageName
}}
 
 
{{#cargo_query:tables=Items,Opinions
|join on=Items._pageName=Opinions._pageName
|fields=Items._pageName,Items.Author,Items.Source,Items.Date
|where=Opinions.Topic="{{PAGENAME}}"
|group by=Items._pageName
|format=timeline
|height=400px
}}
[[Category:Topics]]
</includeonly>

Revision as of 03:37, August 8, 2019

This template holds information on a political topic. It should be called in the following format:

{{Topic
|Start date=The date at which the topic started, if there was one
|End date=The date at which the topic ended, if there was one
|Themes=The theme(s) of this topic, separated by commas if there's more than one
}}

An example of start and end date would be, if the topic is a bill, the date the bill was introduced in Congress, and the date it was signed into law, respectively.

The order of the fields is not relevant. This template defines the table "Topics". View table.