Difference between revisions of "Template:Topic"

From Discourse DB
Jump to navigation Jump to search
m
 
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
 
}}
 
}}
  

Latest 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.