I have a very simple question: how to properly use ES_FOLDER_API.SET_FOLDER_EXPIRY() ?
This is how i use it and it does not work (i am logged as the ES_MAIL user):
select folder_id,DAYS_KEPT from es_folder where upper(folder_name) like upper('%/mailadmin2/inbox%')
, it returns 1081 and 1 (DAYS_KEPT is set by me manually)
which changes nothing because when i use the select again i get the same result: 1081 and 1 .
What is the problem?
I want to create a trigger on the ES_FOLDER table so that it sets DAYS_KEPT to a number of days automatically but i'm afraid that if i set it myself and not with an API i might left something out from the update process.(the API might set some other attributes or something like it).