somogyi
Oct '24

Hi

How i can purge all deleted events in database? Is it possible from the UI?

Thank you for your help.

BR.,
Z

  • created

    Oct '24

  • last reply

    Oct '24
  • 1

    reply

  • 144

    views

  • 2

    users

  • 2

    likes

RalfBeckerEGroupware GmbH
Oct '24
DELETE FROM egw_cal_repeats WHERE cal_id IN (SELECT cal_id FROM egw_cal WHERE cal_deleted IS NOT NULL)
DELETE FROM egw_cal_extra WHERE cal_id IN (SELECT cal_id FROM egw_cal WHERE cal_deleted IS NOT NULL)
DELETE FROM egw_cal_dates WHERE cal_id IN (SELECT cal_id FROM egw_cal WHERE cal_deleted IS NOT NULL)
DELETE FROM egw_cal_user WHERE cal_id IN (SELECT cal_id FROM egw_cal WHERE cal_deleted IS NOT NULL)
DELETE FROM egw_cal WHERE cal_deleted IS NOT NULL

Ralf