How to get only first mail of sender

[PriteshP23]

Hello,
I would like to get only first mail of the Sender. In article table, there is a full history of all mail exchanges. Instead of getting it full, i want to get only the content of first mail. I hope i am clear.

Any idea?

THANKS in advanced.

[PriteshP23]

OTRS save all mails in same table.. ? My problem is there is by default auto reply. Tickets before two months are wiith communication. So, there is a lot of text. I need to get only First part.

Help !

[jojo]

it might be possible via SQL but very tricky

[PriteshP23]

it might be possible via SQL but very tricky

Yes, it is next to impossible. Because it is too long text. In addition, there is common words in each article and salutation. So, I can't use neither split nor substring.

We can find All history of exchange emails in article table only ?

Thanks !