{31} Scrum Database Views (PostgreSQL) (1 match)

Show all database views. To see how a specific view works (e.g. 'aggregated_user_stories'), create a report like

SELECT * FROM aggregated_user_stories
Viewname
Description
story_rd
 SELECT t.id,
    t.milestone,
        CASE
            WHEN ((rd.value IS NULL) OR (NOT isnumeric(rd.value))) THEN 0
            ELSE (rd.value)::integer
        END AS rdp
   FROM (ticket t
     LEFT JOIN ticket_custom rd ON (((t.id = rd.ticket) AND (rd.name = 'rd_points'::text))))
  WHERE (t.type = 'story'::text);

Note: See TracReports for help on using and creating reports.

1.3.15 © 2008-2016 Agilo Software all rights reserved (this page was served in: 0.17032 sec.)