Difference between revisions of "CompanyHistory"

Revision as of 16:53, 5 January 2020

Template to list a company's softography. It's a bit crude.

e.g. Sega, 32X:

{{CompanyHistory|Sega|format=32X|role=Publisher}}

{{CompanyHistory|Sega|Sega CS|format=32X|role=Developer}}

{{CompanyHistory|Sega|format=32X|role=Licensor}}

@@ Line 3: / Line 3: @@
 | {{#vardefine:nameList|{{#var:nameList}},{{#var:value}}}}{{#ifexpr:{{#var:n}} > 1|{{#vardefine:command|{{#var:command}} OR companies.company="{{#var:value}}"}}|}}
 }}</span>{{#vardefine:results|{{#var:results}}{{#cargo_query:
-table=companies,releases
+table=companies,releases,codeformat
-|fields=companies.name=companiesname,releases.name=releasesname,releases.date,companies.company,companies.format,companies.role,companies.credited
+|fields=companies.name=companiesname,releases.name=releasesname,releases.date,companies.company,companies.format,companies.role,companies.credited,codeformat.code=test,codeformat.format=test2
-|join on=companies.name=releases.name
+|join on=companies.name=releases.name,releases.console=codeformat.code
 |group by=releases.name
+|order by=releases.date,releases.name
 |where=({{#var:command}}) {{#if:{{{role|}}}|and (companies.role LIKE "{{{role|}}}%")}} {{#if:{{{format|}}}|and (companies.format="{{{format|}}}")}}
-|order by=releases.date,releases.name
 |format=template
 |limit=1000