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
ソリューション
- Identify the name of your custom event type in your desired calendar
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>'));
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>'));
- 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.