Auto notes date_added and date_updated

Discuss and learn how to use TableTracker for table selection and NoteTracker for taking automated notes.

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Auto notes date_added and date_updated

Postby BillGatesIII » Wed Apr 20, 2016 9:36 am

    I have Auto Notes records with a date_added earlier than date_updated and records with a date_added later than date_updated. How does this work? When does date_added change and when does date_updated change?

    Here are some examples.

    Auto Notes date_added and date_updated.png

    The blue lines are the ones with a date_updated before the date_added.
    BillGatesIII
     
    Posts: 740
    Joined: Fri Dec 16, 2011 6:50 pm

    Re: Auto notes date_added and date_updated

    Postby kraada » Wed Apr 20, 2016 9:52 am

    I'll ask to be certain, but I would have thought one of these (date_added after date_updated) would have been invalid so I'm not sure what's going on.
    kraada
    Moderator
     
    Posts: 54431
    Joined: Wed Mar 05, 2008 2:32 am
    Location: NY

    Re: Auto notes date_added and date_updated

    Postby BillGatesIII » Thu Apr 28, 2016 3:43 pm

      I uncovered it. The date_added field is populated with the date_played of the first hand that is processed. The date_updated field is populated with the date_played of the last hand that is processed. When Auto Notes are purged and the NoteTracker process is started, it will process hands in descending date_played order.
      BillGatesIII
       
      Posts: 740
      Joined: Fri Dec 16, 2011 6:50 pm

      Re: Auto notes date_added and date_updated

      Postby kraada » Thu Apr 28, 2016 3:52 pm

      Ah yes that makes sense - thanks for following up.
      kraada
      Moderator
       
      Posts: 54431
      Joined: Wed Mar 05, 2008 2:32 am
      Location: NY


      Return to TableTracker & NoteTracker

      Who is online

      Users browsing this forum: No registered users and 20 guests

      cron