Exporting incidents to Excel gives limited Work Notes data

GranadaDude
Kilo Contributor

Hello,

 

For reporting purposes, I have a list of incidents, where I need to be able to filter based on certain entries in the work notes.

 

Why should I need this ? Because in the work notes there are system updates where the short description gets another prefix. This prefix I then use temporary to be able to filter on content of my short description.

 

What is then the exact problem ? In Snow, I can clearly see system notes. When exporting this incident, these system notes are not present in the export.

 

Is this a general setting ? Or is this a restriction ?

 

Example : 

 

In export I see the latest update as (I put in the real username as Username due to privacy reasons): 

 

2023-04-17 14:25:21 - [Username] (Work notes)
Cher utilisateur,

 

When I compare with Snow : the latest info is that the issue was closed. But these entries I don't see in Snow.

 

GranadaDude_0-1686908156700.png

 

 

Any tips or advise would be extremely helpful

1 REPLY 1

Ravi Chandra_K
Kilo Patron
Kilo Patron

Hi @GranadaDude  worknotes and additional comments are stored in Journal Entries[sys_journal_field] table.

The Element ID holds the sys_id of the incident. Can you pls check with that table and see if you can export the required data.

 

Regards,

Ravi Chandra.