Query : Threads Sequence Column
I ran a test report using a single incident id in threads table which have threads.seq column. The flow of incident was
- Incident created by EU from AAQ
- Rule send auto response
- Rule also add a private note
- Agent edited the ticket with a private note
- Agent responded to incident
However in my report the seq column values appear as 1,2,3,12 & 17.
While 1,2,3 rightly maps with above steps, am not sure how 12 & 17 came. Can anyone tell me how is the seq value generated? Shouldn't it be 4 & 5 ?