Results 1 to 7 of 7

Thread: Do appointment have "modified date" field?

  1. #1
    Kenji is offline Intermediate Member
    Join Date
    Jun 2006
    Posts
    17
    Rep Power
    8

    Default Do appointment have "modified date" field?

    Hi.
    I have a question.

    Do appointment have "modified date" field?

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

    Thanks&Regards

  2. #2
    KevinH's Avatar
    KevinH is offline Expert Member
    Join Date
    Aug 2005
    Location
    San Mateo, CA
    Posts
    4,789
    Rep Power
    18

    Default

    I think the server stores this but we don't expose it in the web client.
    Looking for new beta users -> Co-Founder of Acompli. Previously worked at Zimbra (and Yahoo! & VMware) since 2005.

  3. #3
    Kenji is offline Intermediate Member
    Join Date
    Jun 2006
    Posts
    17
    Rep Power
    8

    Default

    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.

  4. #4
    KevinH's Avatar
    KevinH is offline Expert Member
    Join Date
    Aug 2005
    Location
    San Mateo, CA
    Posts
    4,789
    Rep Power
    18

    Default

    In that case it's likely we don't store that field anywhere.
    Looking for new beta users -> Co-Founder of Acompli. Previously worked at Zimbra (and Yahoo! & VMware) since 2005.

  5. #5
    dkarp is offline Zimbra Employee
    Join Date
    Aug 2005
    Posts
    1,433
    Rep Power
    11

    Default In the MAIL_ITEM table.

    Quote 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.
    Bugzilla - Wiki - Downloads - Before posting... Search!

  6. #6
    dkarp is offline Zimbra Employee
    Join Date
    Aug 2005
    Posts
    1,433
    Rep Power
    11

    Default MAIL_ITEM.DATE vs MAIL_ITEM.CHANGE_DATE

    Quote 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.
    Bugzilla - Wiki - Downloads - Before posting... Search!

  7. #7
    rahulsingh is offline Starter Member
    Join Date
    Jan 2012
    Posts
    1
    Rep Power
    3

    Thumbs up API Objects

    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"

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 05-08-2009, 08:26 AM
  2. Sub-folder under Sent, no To: field.
    By xtrac in forum Users
    Replies: 4
    Last Post: 06-29-2007, 08:44 AM
  3. Replies: 1
    Last Post: 03-27-2007, 10:50 PM
  4. oops, where did my appointment go?
    By StefanD in forum Users
    Replies: 13
    Last Post: 02-22-2006, 05:04 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •