How to export activities of the ticket

Luigi Scungio
Tera Contributor

Hi all,

how can i export all activities of the ticket ?
I want a list of tickets that have the activity field.

Help me please!!!

1 ACCEPTED SOLUTION

Alikutty A
Tera Sage

Hello,

Please create a database view between incident and sys_journal_field tables. This would allow you to access details like incident number, short description etc.

Note: You may face some performance issues in running it due to the large amount of data in it.

View solution in original post

7 REPLIES 7

Rohit Kaintura
Mega Guru

Goto this table sys_journal_field for all entries.

Ho Rohit,

i have already seen sys_journal_field but there is only the sys_id of the task.

It's complicated match with a list of ticket number...is it possible that the unique solution is build a script that write in a custom field the corresponding ticket ?

Thank you for your time.

Thank you Rohit,

it's the solution that i wanted.