Hi.
I have a question.
Do appointment have "modified date" field?
If appointment have modified date field,
Can I get it?
Thanks&Regards
Do appointment have "modified date" field?
-
- Ambassador
- Posts: 4558
- Joined: Fri Sep 12, 2014 9:52 pm
Do appointment have "modified date" field?
I think the server stores this but we don't expose it in the web client.
Do appointment have "modified date" field?
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.
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.
-
- Ambassador
- Posts: 4558
- Joined: Fri Sep 12, 2014 9:52 pm
Do appointment have "modified date" field?
In that case it's likely we don't store that field anywhere.
Do appointment have "modified date" field?
[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.
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.
Do appointment have "modified date" field?
[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.
-
- Posts: 1
- Joined: Sat Sep 13, 2014 2:26 am
Do appointment have "modified date" field?
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"
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"