Page Comparison

Versions Compared

Key

This line was added.
This line was removed.
Formatting was changed.

MySQL / PostgreSQL

Code Block

language	sql

-- Find Jira Issue
SELECT CONCAT(p.pkey,'-',ji.issuenum) AS "issuekey", ji.summary, ji.description, ji.assignee, ji.creator, ji.created, ji.updated 
FROM jiraissue ji JOIN project p ON ji.project = p.id;

...