CompanyHistory

From Sega Retro

Clock.svg
This task is unfinished
This is a wiki task that requires more thought or peer review. An important issue that needs to be solved, which will appear at the top of Sega Retro:Todo until this message is removed.

The join/group by is incorrect, which is why the dates are wrong.

name date company format console role credited
Virtua Striker 1995-05 Sega AM2 PlayStation 3 MOD2 Developer Yes
Hatsune Miku: Project DIVA Dreamy Theater 2010-06-24 Sega AM2 PlayStation 3 PS3 Developer Yes
Virtua Tennis 4 2011 Sega AM2 PlayStation 3 RE Developer Yes
Hatsune Miku: Project DIVA Dreamy Theater 2nd 2011-08-04 Sega AM2 PlayStation 3 PS3 Developer Yes
Hatsune Miku: Project DIVA Dreamy Theater extend 2012-09-13 Sega AM2 PlayStation 3 PS3 Developer Yes
Dead or Alive 5 2012-09-27 Sega AM2 PlayStation 3 360 Developer Yes
Hatsune Miku: Project DIVA F 2013-03-07 Sega AM2 PlayStation 3 PS3 Developer Yes
Dead or Alive 5+ & Dead or Alive 5 2013-03-20 Sega AM2 PlayStation 3 PS3 Developer Yes
Dead or Alive 5 Ultimate 2013-12-24 Sega AM2 PlayStation 3 RE2 Developer Yes
Dead or Alive 5 Last Round 2015-02-17 Sega AM2 PlayStation 3 RE2 Developer Yes

This could be solved if I could join "PS3" onto "PlayStation 3". I don't know how to do that without making another table (to replicate template:Code2Format). Is there another way?

-Black Squirrel (talk) 11:39, 5 January 2020 (EST)

So the problem is that "companies" uses the full console names and "releases" uses codes? I don't really understand the cargo syntax you've used here, so all I can suggest is creating an additional template that fetches the date, instead of trying to get the date in CompanyHistory. The template would be called from Template:CompanyHistory/Cargo and would need to contain a reverse Template:Code2Format. - Hivebrain (talk) 15:02, 5 January 2020 (EST)
Alright no worries - I thought there might have been a shortcut.
I've cheated and made Special:CargoTables/codeformat, which means we can join the tables in a better way. I think the results are correct now - missing games are hopefully the fault of individual pages. -Black Squirrel (talk) 16:07, 5 January 2020 (EST)

Note to self

template isn't pulling out games that have ampersands or single quotes in their names. SQL thing maybe. Will check at some point -Black Squirrel (talk) 16:26, 8 January 2020 (EST)