Login
    Contents x
    DeleteOldRecordsInTable
    • 03 Nov 2020
    • 1 Minute to read
    • Contributors
    • Print
    • Dark
      Light
    Contents

    DeleteOldRecordsInTable

    • Updated on 03 Nov 2020
    • 1 Minute to read
    • Contributors
    • Print
    • Dark
      Light
    Article summary

    This util removes old records in the tables listed as parameters in the scheduled job. The scheduled job requires a property in SiteDef.xml called "old.db.record.limit" to define how many days a record can live before it is removed. The default value of 90 days is used if the property is not found.

    Project

    com.corzia.comflow.utils

    List of methods

    execute

    The job checks any column of type CreateDate and ChangeDate to see which is the most recent and removes the record if it is older than the property "old.db.record.limit".

    ArgumentScheduled job parameter
    "Param_db_#" where # is an index and the value is the name of the table.
    Example: Param_db_1 = CACORE.ApplicationErrorLog
    ReturnsN/A


    Was this article helpful?
    What's Next
    Change password!
    Changing your password will log you out immediately. Use the new password to log back in.
    Change profile
    Success!
    First name must have atleast 2 characters. Numbers and special characters are not allowed.
    Last name must have atleast 1 characters. Numbers and special characters are not allowed.
    Enter a valid email
    Enter a valid password
    Your profile has been successfully updated.
    Logout