Do appointment have "modified date" field?

[Kenji]

Hi.
I have a question.

Do appointment have "modified date" field?

If appointment have modified date field,
Can I get it?

Thanks&Regards

[KevinH]

I think the server stores this but we don't expose it in the web client.

[Kenji]

I saw appointment table of mailboxX.

appointment table have u_id, item_id, start_time and end_time field.
modified date field is not in appointment table.

Where do modified date field be stored?

Thanks.

[KevinH]

In that case it's likely we don't store that field anywhere.

[dkarp]

Originally Posted by Kenji

I saw appointment table of mailboxX.

appointment table have u_id, item_id, start_time and end_time field.
modified date field is not in appointment table.

Where do modified date field be stored?

There's a foreign key mapping the ITEM_ID column in the APPOINTMENT table to the ID column in the MAIL_ITEM table. The "last modified time" is stored in the CHANGE_DATE column of the corresponding row of the MAIL_ITEM table.

[dkarp]

Originally Posted by dkarp

There's a foreign key mapping the ITEM_ID column in the APPOINTMENT table to the ID column in the MAIL_ITEM table. The "last modified time" is stored in the CHANGE_DATE column of the corresponding row of the MAIL_ITEM table.

The other value you might be interested in is MAIL_ITEM.DATE. MAIL_ITEM.CHANGE_DATE is the last time anything about the appointment changed (including its folder, whether it's flagged/tagged, etc.). MAIL_ITEM.DATE is the last time the appointment itself was modified.