Do appointment have "modified date" field?

Kenji · Post by **Kenji** » Tue Jul 11, 2006 12:32 am

Hi.

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

Can I get it?
Thanks&Regards

14319KevinH · Post by **14319KevinH** » Thu Jul 13, 2006 2:47 pm

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

Kenji · Post by **Kenji** » Thu Jul 13, 2006 7:08 pm

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.

14319KevinH · Post by **14319KevinH** » Sun Jul 16, 2006 7:52 pm

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

dkarp · Post by **dkarp** » Mon Jul 17, 2006 1:38 am

[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.

dkarp · Post by **dkarp** » Mon Jul 17, 2006 1:47 pm

[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.

rahulsingh · Post by **rahulsingh** » Mon Jan 30, 2012 9:02 pm

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"