hi all,
just need to check if it is possible or if there is a API to perform the below?
I am using Architech to create a entry into a Data Table for certain customers who calls in [Key = ANI; Date = date and time of call]
what i am looking for is, due to Data Table limitation "The number of data rows allowed in a single table is 5000.", is to delete all entries where date is => 2 days.
This will be used to identify repeat callers, so if the caller calls back for a second time and the ANI exist within the Data Table, i can then delete that entry.
the issue is that if a caller does not call in a second time in a certain timeframe, i need to delete the entries => 2 days old to ensure i don't exceed the 5000 limitation.
so basically i am looking for something similar to SQL script:
Delete *
Where X => Y
#ArchitectureandDesign------------------------------
Reginald Sheraton
------------------------------