psql query to fetch team calendar last updated even

Question

Hi,

I need a psql query to display the team calendar name , with last updated event ?

Is there any way to get this?

Krithica_Gowrisankar-ext · Answer

This query did not work, in our DB we dont have these 2 tables calaendar_event, calendar_calendar.

Calendar info i am getting from "AO_950DC3_TC_SUBCALS" table.

Not able to find the event table to get the last updated event.

Kindly help.

Albert Manuel · Answer

SELECT c.name AS calendar_name, e.end_date AS last_updated_event
FROM calendar_calendar c
JOIN calendar_event e ON c.id = e.calendar_id
WHERE e.end_date = (SELECT MAX(end_date) FROM calendar_event WHERE calendar_id = c.id)