How to find all events related to a custom event type in Team Calendars

お困りですか?

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

コミュニティに質問

目的

Team Calendars does not have options to generate a report of all events in a custom event type

ソリューション

  1. Identify the name of your custom event type in your desired calendar
  2. Run the following query, replacing the "Title" with the correct title:

    SELECT * FROM "AO_950DC3_TC_EVENTS" WHERE "SUB_CALENDAR_ID"=(SELECT "ID" FROM "AO_950DC3_TC_SUBCALS" WHERE "USING_CUSTOM_EVENT_TYPE_ID"=(SELECT "ID" FROM "AO_950DC3_TC_CUSTOM_EV_TYPES" WHERE "TITLE"='<EVENT TYPE TITLE>')); 


    1. For Example if your custom calendar was titled "Vacation" you would run the following:

      SELECT * FROM "AO_950DC3_TC_EVENTS" WHERE "SUB_CALENDAR_ID"=(SELECT "ID" FROM "AO_950DC3_TC_SUBCALS" WHERE "USING_CUSTOM_EVENT_TYPE_ID"=(SELECT "ID" FROM "AO_950DC3_TC_CUSTOM_EV_TYPES" WHERE "TITLE"='<Vacation>')); 
  3. If you'd like to identify the creator of the calendar event you can review our: How to find the Creator of a Calendar in Team Calendars for Confluence

最終更新日 2018 年 8 月 5 日

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

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