Reporting on Task Work Notes

[vcaracci75]

We have a need to be able to search the Work Notes and Additional Comments fields for all our tasks. Is there a way to report on these fields?

[Steven Parker]

One way to do it without reporting....is add the column "Comments and Work Notes" to your Task list (task table - task.list in navigator).  If needed, change the filter to "ALL" if you want to see everything.  

Then filter the Number column by *SCTASK

Then filter the Comment and Work Notes column by *whatever you need to search

You can then save this as a favorite and just change the "Comments and Work Notes" search criteria for whatever you need to search for.  I typically search this way because it's simple and quick.

[Ankur Bawiskar · Accepted solution]

Hi,

you can create report on sys_journal_field which stores journal entries data

Apply filter as this

1) element - work_notes

2) name - your table name

Regards
Ankur

[Steven Parker]

Currently, you can't report on the journal table because it's a system table correct?

[Ankur Bawiskar]

Hi,

If not possible then you can update this system property to allow reporting on it

glide.ui.permitted_tables

Regards
Ankur