Template:Topic: Difference between revisions

From Discourse DB
Jump to navigation Jump to search
m (Reverted edits by Yaron Koren (Talk); changed back to last version by Nick Grandy)
(Changed to use "Start date", "End date" types)
 
(40 intermediate revisions by the same user not shown)
Line 1: Line 1:
<includeonly>
<noinclude>This template holds information on a political topic. It should be called in the following format:
This is a [[is of type::Type:Topic|topic]], with start date [[Start date:={{{start date|unknown}}}]] and end date [[End date:={{{end date|unknown}}}]]. [http://digg.com/submit?phase=2&url={{fullurl:{{SUBJECTPAGENAMEE}}}}&title={{PAGENAMEE}}&bodytext=Political%20Opinion%20Roundup&topic=political_opinion Submit to Digg]
<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.


Add an item to this topic:<inputbox>
The order of the fields is not relevant.
type=create
{{#cargo_declare:_table=Topics|Start_date=Start date|End_date=End date|Themes=List (,) of String (allowed values=Africa, Asia, International relations, Middle East, Terrorism, United Kingdom domestic politics, United States domestic politics, War)}}
buttonlabel=Create
</noinclude><includeonly>{{#cargo_store:_table=Topics|Start_date={{{start date|}}}|End_date={{{end date|}}}|Themes={{{Themes|}}} }}
preload=Help:NewItemText
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}}.
break=no
</inputbox>


<ask query="TopicSummary"> [[Addresses topic::{{PAGENAME}}]][[Category:Positions]] </ask>
Its theme(s) are {{#arraymap:{{{Themes|}}}|,|x|[[x]]}}.


==Summary of positions for this topic==
{{#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
}}


<font size="+1">All items that address this topic (<ask count> [[Addresses topic::{{PAGENAME}}]][[Category:Items]] </ask> total)</font>
==Full listing==
<hr>
''Click on position names to view quotes from each listed item.''
<ask mainlabel="Title" sort="Published on" order="descending"> [[Category:Items]] [[Was written by::*]] [[Published by::*]] [[Published on:=*]] [[Published on:=+]] [[Addresses topic::{{PAGENAME}}]] </ask>
 
{{#cargo_query:tables=Items,Opinions
|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
}}
 
==All items that address this topic ({{#cargo_query:tables=Items,Opinions
|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]]
[[Category:Topics]]
</includeonly>
</includeonly>

Latest revision as of 18:39, August 18, 2021

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.