目的

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