Sep 272021

This is the first of a series of posts which provide sample queries. Sometimes you need a starting point. This particular query will be used for showing the recent commits on a branch.

WITH branch_commits AS (
  SELECT distinct, CL.commit_DATE
    FROM commit_log CL
    JOIN commit_log_ports CLP on = CLP.commit_log_id
    JOIN commit_log_branches CLB ON CLP.commit_log_id = CLB.commit_log_id
    JOIN system_branch        SB ON = CLB.branch_id AND SB.branch_name = '2021Q3'
    LIMIT 100
SELECT, CL.commit_date, CL.message_id
  FROM branch_commits BC JOIN commit_log CL ON =
  ORDER BY CL.commit_date DESC;
Website Pin Facebook Twitter Myspace Friendfeed Technorati Digg Google StumbleUpon Premium Responsive