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

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.

Perfect,

thank you Alikutty.

You are welcome. Please be careful if you are planning to open this view for users as it can be bad in performance.