...
| Code Block | ||
|---|---|---|
| ||
DELETE FROM appointment; DELETE FROM appointment_reminders; DELETE FROM appointment_resource; DELETE FROM instance_properties WHERE instance_id=4; DELETE FROM tlstatus WHERE instance_id=4; DELETE FROM instance_properties_attachments where addin_id=4; |
Nach E-Mail-Import aus Outlook die E-Mail-Datumfelder korrigieren
| Code Block | ||
|---|---|---|
| ||
UPDATE
email_messages
INNER JOIN instance_properties ON instance_properties.instance_id = 3 AND instance_properties.object_id = email_messages.id
AND instance_properties.direction = 2
SET instance_properties.object_date = email_messages.delivery_date WHERE instance_properties.created_by_userid = 2 --das ist die ID des Admins |
| Code Block | ||
|---|---|---|
| ||
SELECT * FROM
tlstatus
INNER JOIN instance_properties ON
instance_properties.instance_id = tlstatus.instance_id and
tlstatus.instance_id=3 AND
instance_properties.object_id = tlstatus.object_id AND
instance_properties.direction = 2 AND
tlstatus.is_resubmission=0 AND -- nicht wiedervorlegt
tlstatus.resubmission_date is null AND -- keine wiedervorlage eingerichtet
tlstatus.is_globalize=0 AND -- nicht geteilt
instance_properties.chatsession_id=0 |