Alpha Video Training
Results 1 to 7 of 7

Thread: Tracking Changes to Records

  1. #1
    Member
    Real Name
    Terry Morgan
    Join Date
    Nov 2014
    Location
    Essex, England
    Posts
    249

    Default Tracking Changes to Records

    I have found "Tracking Changes to Table Fields" in Alpha Help but cannot find The same for "Tracking Changes to Records" I would like to track any changes to a record (when saved on a form) to either a table or written to a txt file.
    Does anyone have a code for this.
    Thanks
    Terry

  2. #2
    Member
    Real Name
    Jeremy Scrime
    Join Date
    Sep 2015
    Posts
    91

    Default Re: Tracking Changes to Records

    I believe the newer "Audit" features will accomplish this. They can be enabled in the Project Properties. They only track changes made via Grids, List Controls, UX controls, etc. If you make a change via a stored procedure or another method outside the "Alpha" framework your changes will not be logged.

    However, if the Audit trail does what you need it seems to work very well for me. Information captured contains the operation type (Insert, Update, Delete), what user performed the operation, when it was performed, a JSON string of the data (fields in the record that were changed) both old and new values, as well as some other useful information.

    HTH,
    Jeremy

  3. #3
    Member
    Real Name
    Jon P Moody
    Join Date
    Nov 2016
    Posts
    151

    Default Re: Tracking Changes to Records

    Terry, have a look at https://documentation.alphasoftware....%20Feature.xml . It may help.

  4. #4
    Member
    Real Name
    Terry Morgan
    Join Date
    Nov 2014
    Location
    Essex, England
    Posts
    249

    Default Re: Tracking Changes to Records

    Thanks for your quick response bu I have an entirely desktop application. So it’s changes on a desktop form.
    Terry

  5. #5
    "Certified" Alphaholic Ted Giles's Avatar
    Real Name
    Ted Giles
    Join Date
    Aug 2000
    Location
    In the Wolds, Louth, Lincolnshire, UK
    Posts
    4,325

    Default Re: Tracking Changes to Records

    Yes Terry, there is a complete audit trail for DT.

    a5_audit_trail
    You need alpha security set so whoever did the changes can be identified.
    Saves before and after details by field.

    There is also a similar process for deleted stuff.
    Ted Giles
    Example Consulting - UK
    .

    http://ec12.example-software.com//
    See our site for Alpha Support, Conversion and Upgrade.

  6. #6
    "Certified" Alphaholic
    Real Name
    Gregg Schmidt
    Join Date
    Mar 2001
    Location
    Milwaukee
    Posts
    1,351

    Default Re: Tracking Changes to Records

    The desktop gets maligned again.
    You can use grids and ux's within your desktop app.
    You can use api_getusername() and api_getmachinename() to keep track of who made the changes as well as what machine they made the changes from.
    Finally, assuming you're using some version of sql, it should be relatively simple to create an afterUpdate trigger to copy the old values to a change log table.

  7. #7
    "Certified" Alphaholic Ted Giles's Avatar
    Real Name
    Ted Giles
    Join Date
    Aug 2000
    Location
    In the Wolds, Louth, Lincolnshire, UK
    Posts
    4,325

    Default Re: Tracking Changes to Records

    The CSV which the Audit Trail function creates can be imported into a table and used to present a detailed report if you wanted to.
    Ted Giles
    Example Consulting - UK
    .

    http://ec12.example-software.com//
    See our site for Alpha Support, Conversion and Upgrade.

Similar Threads

  1. Tracking individual records as unsynced
    By Hank_the_Cowdog in forum Mobile & Browser Applications
    Replies: 5
    Last Post: 03-26-2019, 11:41 AM
  2. Tracking down errors
    By PhilM1965 in forum Application Server Version 11 - Web/Browser Applications
    Replies: 0
    Last Post: 09-23-2012, 07:24 AM
  3. Tracking values
    By cello78 in forum Alpha Five Version 7
    Replies: 0
    Last Post: 05-09-2006, 04:50 AM
  4. Tracking changes to records
    By Gerard Lynn in forum Alpha Five Version 5
    Replies: 4
    Last Post: 06-10-2004, 08:12 AM
  5. Tracking changes
    By JayMoskovitz in forum Alpha Five Version 4
    Replies: 3
    Last Post: 11-30-2001, 01:38 AM

Bookmarks

Posting Permissions

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