- 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-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-07-2018 04:52 AM
Perfect,
thank you Alikutty.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-07-2018 05:12 AM
You are welcome. Please be careful if you are planning to open this view for users as it can be bad in performance.