comment_snippet.sql
No One
Actions

Authored By

	epriestley
	Oct 28 2015, 1:57 PM

Size

483 B

Referenced Files

None

Subscribers

None

comment_snippet.sql
View Options

	SELECT
	u.username author,
	FROM_UNIXTIME(x.dateCreated) created,
	IF(c.changesetID, CONCAT(h.filename, ':', c.lineNumber), null) locus,
	c.content comment
	FROM differential_revision r
	JOIN differential_transaction x ON x.objectPHID = r.phid
	JOIN differential_transaction_comment c ON x.commentPHID = c.phid
	JOIN phabricator_user.user u ON x.authorPHID = u.phid
	LEFT JOIN differential_changeset h ON c.changesetID = h.id
	WHERE r.id = <ID>
	ORDER BY x.id ASC;