Determining Sprint Status from the Database

お困りですか?

アトラシアン コミュニティをご利用ください。

コミュニティに質問

目的

Sprint states (Active, Completed, Future) aren't stored directly in the database. Read on for a method to calculate the state based on the values of two columns in the AO_60DB71_SPRINT table.

ソリューション

  • You can determine the sprint status by evaluating the values of the CLOSED and STARTED columns of the AO_60DB71_SPRINT table.
    • When STARTED is t and CLOSED is f, that's indicative of an active sprint
    • When CLOSED is t, that's indicative of a completed sprint
    • When STARTED is f, that's indicative of a future sprint

  • As a practical example:

    select * from "AO_60DB71_SPRINT";
     CLOSED | COMPLETE_DATE |   END_DATE    | GOAL | ID |      NAME       | RAPID_VIEW_ID | SEQUENCE | STARTED |  START_DATE
    --------+---------------+---------------+------+----+-----------------+---------------+----------+---------+---------------
     f      |               | 1532407100657 |      |  1 | Sample Sprint 2 |             1 |          | t       | 1531196300657
     t      | 1531187301433 | 1531192101433 |      |  2 | Sample Sprint 1 |             1 |          | t       | 1529982501433
     f      |               |               |      |  3 | Sample Sprint 3 |             1 |          | f       |
    (3 rows)


    • Using the criteria outlined above, Sample Sprint 1 is a completed sprint, Sample Sprint 2 is an active sprint, and Sample Sprint 3 is a future sprint.


最終更新日 2018 年 8 月 9 日

この内容はお役に立ちましたか?

はい
いいえ
この記事についてのフィードバックを送信する
Powered by Confluence and Scroll Viewport.