Hi,
I need a psql query to display the team calendar name , with last updated event ?
Is there any way to get this?
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)
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.