- You want to delete Transactions from the patron, but you want to keep the statistics
If OCLC hosts you, you would need to give us the parameters you want to set, and we take care of making this happen. You need to either call us at 800-848-5800 or Email us.
If you are self-hosted, you need to break the link for the Transactions from the Users to a New User. Because you want to keep the statistics in ILLiad, you create a user with a username like brokenusername. You want to do a query such as any transaction older than three years will be removed from the user and then assigned to brokenusername. So an example query might be:
Select TransactionNumber from Transactions
Where CreationDate < '3/21/2016'
This query gives you the list of Transaction Numbers you can put in the script, or you could add this query as part of the script. You would have to work with your SQL Admin about the best way to get your request done.
In the Documentation, this process is "Breaking the Link" under the Database Manager. Here is the information about The ILLiad Database Manager. Here is the information for Breaking the User Link in the ILLiad Database.