Template:Topic: Difference between revisions

From Discourse DB
Jump to navigation Jump to search
No edit summary
(Changed to use "Start date", "End date" types)
 
(5 intermediate revisions by the same user not shown)
Line 10: Line 10:


The order of the fields is not relevant.
The order of the fields is not relevant.
{{#cargo_declare:_table=Topics|Start_date=Date|End_date=Date|Themes=List (,) of Text (allowed values=Africa, Asia, International relations, Middle East, Terrorism, United Kingdom domestic politics, United States domestic politics, War)}}
{{#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)}}
</noinclude><includeonly>{{#cargo_store:_table=Topics|Start_date={{{start date|}}}|End_date={{{end date|}}}|Themes={{{Themes|}}} }}
</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 [[Has start date::{{{start date}}}]]|unknown start date}} and {{#if:{{{end date|}}}|end date [[Has end date::{{{end date}}}]]|unknown end date}}.
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}}.


Its theme(s) are {{#arraymap:{{{Themes|}}}|,|x|[[Has theme::x]]}}.
Its theme(s) are {{#arraymap:{{{Themes|}}}|,|x|[[x]]}}.


==Summary of positions for this topic==
==Summary of positions for this topic==
Line 35: Line 35:
|format=ddb outline
|format=ddb outline
|outline fields=Position_link,Stance
|outline fields=Position_link,Stance
|order by=CASE Stance
|order by=CONCAT(CASE Stance
         WHEN 'for' THEN 1
         WHEN 'for' THEN 1
         WHEN 'against' THEN 2
         WHEN 'against' THEN 2
         WHEN 'mixed' THEN 3
         WHEN 'mixed' THEN 3
         END, Date DESC
         END), Date DESC
}}
}}


Line 56: Line 56:
}}
}}


{{#ask:[[Category:Items]][[Addresses topic::{{PAGENAME}}]]|? Was written by=Author|? Was published by=Source|? Was published on=Date|format=timeline|timelinebands=DAY,MONTH|timelineposition=end|timelinesize=400px}}
 
{{#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.