Article Text in Search tool or Reports

[graychev]

Hello,

Please for advise.

I am using OTRS 6. Long story short. Agents are creating phone tickets, so other agents are taking them for completing.
Upon creation agent puts some text with basic info about the problem and model of device.

I need option how to show only the first article on reports or when using the Search tool.

Thank you in advance.

Regards,
Georgi

[skullz]

not available within standard report function..
however you can use the Admin > SQL box to achieve this via SQL query.

take a look a table ticket, article and article_data_mime (OTRS 6,LTS)

good luck

[graychev]

Thanks skullz.

I will try it out.

BR,
G