when i changed my incident status from work in progress to resolved.then status had changed but the resolve date was not updated.
i will try to update my incident from database.
its update in database but not in ca service desk application.
When you change something directly in database, then you have to force Service Desk to refresh content of cache. Use command
pdm_cache_refresh -t <your table name>
It will load everything that was in the cache again from DB. Be careful with this command especially when you are trying to update multiple tables. It is poorly designed.
could you check Resolved status settings? You can find it in Admin tab -> Service Desk -> Req/Inc/Prb -> Status.
Make Resolved flag should be set as Yes.
I will strongly discourage you to update any data directly to the database.
This is bad practice to bypass the object layer of the application and may result in long terms problem that you may not discover immediately.
Simple reference table may be a little safer but will still discourage for the reason above but the CR object (call_req table) is the last table you would like to touch this way an more specially on status as there is a lot in the backend going on when touching status like cancelling event removing them from animator and many other etc..
I have pass many of my time of resolving such problem and data integrity on client side due to those (bad) practic.
Having such practice will only cause trouble and performance issue over the time.
My 2 cents
Retrieving data ...