Do appointment have "modified date" field?

Interested in talking about Mash-up's? This is the place.
Kenji
Posts: 17
Joined: Fri Sep 12, 2014 10:12 pm

Do appointment have "modified date" field?

Postby 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
Ambassador
Ambassador
Posts: 4558
Joined: Fri Sep 12, 2014 9:52 pm

Do appointment have "modified date" field?

Postby 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
Posts: 17
Joined: Fri Sep 12, 2014 10:12 pm

Do appointment have "modified date" field?

Postby 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
Ambassador
Ambassador
Posts: 4558
Joined: Fri Sep 12, 2014 9:52 pm

Do appointment have "modified date" field?

Postby 14319KevinH » Sun Jul 16, 2006 7:52 pm

In that case it's likely we don't store that field anywhere.
dkarp
Elite member
Elite member
Posts: 1410
Joined: Fri Sep 12, 2014 9:52 pm

Do appointment have "modified date" field?

Postby 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
Elite member
Elite member
Posts: 1410
Joined: Fri Sep 12, 2014 9:52 pm

Do appointment have "modified date" field?

Postby 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
Posts: 1
Joined: Sat Sep 13, 2014 2:26 am

Do appointment have "modified date" field?

Postby 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"

Return to “Zimlets”

Who is online

Users browsing this forum: No registered users and 2 guests