In version 11 I want to export helpdesk ticket data along with all mail.message data , I've exported all data except some mail message logs, I've exported comment and email type message but in mail.message database table notification type messages are not visible, How can I export all notification message visible under help desk ticket.
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project management
- MRP
This question has been flagged
Hi Vivek,
The message type is visible (and exportable) right from the mail.message tree view. You can first create a filter to only get messages for the model "helpdesk.ticket":
Then select all items in the treeview for export and be sure to export the fields "Type" and "Subtype". After exporting them you will see all messages related to helpdesk tickets with their type and subtype:
Regards,
Yenthe
Hi Yenthe, I tried this and yes it export all messages, but in some messages (type notification) content(body) is not visible when export. message content is visible under document(helpdesk.tickt in my case) so I checked the entries in mail.message table but content also not stored in database. how it is visible under the document while its not visible in table, is it stored in any other table ?
Here's the table view.
select message_type,subtype_id,body from mail_message where res_id=18809;
message_type | subtype_id | body
--------------+------------+----------------------------------------
comment | 2 | <p>Again just testing logs</p>
comment | 2 | <p>Hello testing logs</p>
notification | 2 |
notification | 17 |
notification | 2 |
comment | 1 | <p>109591 Mark Omo ticket created.</p>
notification | 18 |
Noida 201301
https://www.avyaan.com
Hi Vivek,
I can't get it reproduced on runbot. Do you get the same behaviour when you export them from the messages menu though? Not by exporting from the helpdesk tickets?