Zimbra Forums

Hi.

I have a question.
Do appointment have "modified date" field?
If appointment have modified date field,

Can I get it?
Thanks&Regards

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

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.

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

[quote user="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?[/QUOTE]

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.

[quote user="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.[/QUOTE]

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.

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.
I don't think so, go through this https://wiki.mozilla.org/Bugzilla:REST_API:Objects#User

before making some thinking...
to find last modified date/time --either use "delta_ts" or "changeddate"