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.

[Viraj Hudlikar]

@dhineshkumar  - Not a good idea to generate report on worknotes field. As per your statement if need to see problem is present over incident record use filter as problem is not empty and active is true.

Also, what is your usecase to perform such search?

If my response has helped you hit helpful button and if your concern is solved do mark my response as correct.

Thanks & Regards
Viraj Hudlikar.

[dhineshkumar]

Hi @Viraj Hudlikar 

I want generate the report on the work notes. 
Example : If I have 10 Incidents tickets which is have the worknotes "corner" "problem" "sunny" I want filter those Incident tickets on my report. 

Thanks In advance

[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.

Why not just use tagging? You can even automate it (add a tag when a work note is added with 'x', 'y' or 'z'? But still: it doesn't really make sense to do this. It will show you things you don't want or need to see, because you are searching for 'contains' which is just searching for a random string and adds no value to your report (at least, not from the information you shared, because you aren't telling us the 'why').

[Viraj Hudlikar]

Hello @dhineshkumar 

What is reason for creating report on worknotes? It's not advisable to create report unless its really critical thing needed. Also, the keywords you looking will get huge data and it will impact system. 

As suggested by Mark first identify what is your usecase? What is need? Try to explain more over community about your usecase then we can advise best.

If my response has helped you hit helpful button and if your concern is solved do mark my response as correct.

Thanks & Regards
Viraj Hudlikar.