"Work notes" and "Additional comments" on report

[sr_surendra]

Dear all,

I wanted to extract report where I can add "Worknotes" and "Additional Comments" along with other fields in "incident" or "Requested Item"

Can someone please let me know which table I have to choose or join which all tables etc.

Regards,

Surendra

[Service Manager]

Did anyone were able to resolve this issue?

Thanks

[HarshTimes]

Hi Surrendra and All

OOB it is not possible to setup a report on the worknotes or additional comment fields.These are journal fields. But you can setup a report in two ways.

1. Create a table and it should have a reference field , referencing to requested item table or any other required table. And anther string fields for work notes and additional comments. Write a after insert/update business rule on request item table or any required table . This script will add/update a record on the new table whenever a work-notes/additional comment is added on required table. NOw you can report on the new table to get the desired report.

2. Setup a database view between request item table and journal table(sys_journal_field). Then you can report on this database view. The drawback for this is you will see multiple records for a single request item record.(Number of records based on the number of comment and additional work notes). I have attached the screenshot of the database view . you can try that.

I hope this will resolve your query or at least give you a starting point for your requirement.

-Harsh

[Service Manager]

Hi Hash,

Would you mind sharing the BR details and script ?

Thanks

[HarshTimes]

HI

If you are looking script for the point 2(database view), You do not need any scripts or business rule. I have attached the screenshot of the database view .You can create a similar database view.

search the database view in application navigator and setup according to the screenshot

-Harsh

[Service Manager]

I created the database view for change request and sys_journal_field 

that worked!

Thanks