Tenders can be expired automatically after a certain number of days by setting up a default expiry for them.
This default will be already set to 30days however should you wish to change it please follow the below steps;
- Find the id of the validation entry to be updated;
Select * from tblValidationEntries
where sgDisplay like 'ClickHome.Tenders.DefaultExpiry'
- Run the below update script using the id from the above in place of XXX and the no of days as a number;
set sgText1 = noofdays
where idValidationEntry = XXX
set sgText1 = 10
where idValidationEntry = 256