I was working on my custom module and one of my use case is to get all expired rows based upon context_expiry column from dialog_sessions table
The thing is context_expiry as well as session_expiry column data gets updated everytime, Its always in the future, doesn’t matter if user is talking to bot or not.
Where we can check when was the first time user session gets expired or is expired or how can I get all the rows where context has been expired?
Lets say in this scenario the context_expiry (highlighted in the image) will get updated again at that time.
Do you save this info anywhere in the database, the first time when context was expired ?