--issue_statuses view, get all status changes of issues
CREATE OR REPLACE VIEW issue_statuses AS
  SELECT *
  FROM dblink('host=localhost dbname=redmine user=root password=123456',
  '
SELECT
  i.id AS issue_id,
  s1.name AS old_status,
  s2.name AS new_status,
  j.created_on AS created_on
FROM journal_details AS jd
INNER JOIN journals AS j ON j.id = jd.journal_id AND jd.property = ''attr'' AND jd.prop_key = ''status_id''
INNER JOIN issues AS i ON i.id = j.journalized_id AND ''Issue'' = j.journalized_type
INNER JOIN issue_statuses AS s1 ON s1.id = jd.old_value::integer
INNER JOIN issue_statuses AS s2 ON s2.id = jd.value::integer
ORDER BY j.created_on ASC
  ')
  AS t1(issue_id INTEGER, old_status VARCHAR, new_status VARCHAR, created_on TIMESTAMP);