Results 1 to 7 of 7

Thread: Do appointment have "modified date" field?

  1. #1
    Join Date
    Jun 2006
    Posts
    17
    Rep Power
    9

    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
    Join Date
    Aug 2005
    Location
    San Mateo, CA
    Posts
    4,789
    Rep Power
    19

    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
    Join Date
    Jun 2006
    Posts
    17
    Rep Power
    9

    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
    Join Date
    Aug 2005
    Location
    San Mateo, CA
    Posts
    4,789
    Rep Power
    19

    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
    Join Date
    Aug 2005
    Posts
    1,433
    Rep Power
    12

    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
    Join Date
    Aug 2005
    Posts
    1,433
    Rep Power
    12

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

Similar Threads

  1. Replies: 3
    Last Post: 05-08-2009, 09:26 AM
  2. Sub-folder under Sent, no To: field.
    By xtrac in forum Users
    Replies: 4
    Last Post: 06-29-2007, 09:44 AM
  3. Replies: 1
    Last Post: 03-27-2007, 11: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
  •