Report on the wok notes of the Incident field

[dhineshkumar]

Hi Team 

There is Worknotes field on the Incident table. I want to generate the report on the particular condition as Worknotes contains " Problem. Task, etc " How generate the report on particular condition.

Thanks in advance.

[JenniferRah]

Unfortunately, the work notes are stored in the sys_journal_field table, which isn't reportable. You could possibly create a view on that table with a filter similar to this: 

name=incident^element=work_notes^valueLIKEProblem

[Mark Manders]

By default, journal fields aren't reportable, although they can be made reportable. You do need to ask yourself what you are looking for. What is the requirement? What is the use of a report on that table, especially with such generic words.

"I'll pick it up, no problem" is just one sentence that will also turn up on your report. As well as any word with 'task' or 'problem' in it. "It will take some multitasking, but it will be done in time" will also show up.

What is it you are really looking for to achieve. Knowing the 'why' behind a report will help a lot in getting to a working solution (especially because there is no reportable link between the sys_journal_field table and any task table). You can't say 'incident xyz had such a worknote' through a report.

[AndersBGS]

Hi @dhineshkumar ,

 this is not best practice, hence I wouldn’t recommend it. What is your m business requirement?