- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-06-2018 03:57 AM
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!!!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-07-2018 02:55 AM
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-06-2018 04:48 AM
Goto this table sys_journal_field for all entries.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-07-2018 02:50 AM
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-07-2018 04:36 AM
You can create a database view.
Goto this link how to create a database view.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-07-2018 04:56 AM
Thank you Rohit,
it's the solution that i wanted.