Creating a report in ServiceNow with the Notes that are added to a Time Card help.

[Danielle10]

Great day, smart people of ServiceNow!

Would you happen to know if a report is able be created in ServiceNow that shows the Notes that are added to a Time Card?

I want to be able to create a report that shows me the Time Cards that have added notes on them. Here is a picture of where I see that you can add notes to a Time Card in the Time Sheet Portal.

Thank you for your help!!! I need it! 

[Riya Verma]

Hi @Danielle10 ,

Hope you are doing great.

To achieve this, we can utilize ServiceNow's reporting capabilities and leverage the relevant tables and fields associated with Time Cards and Notes. Here's an approach you can follow:

1. Identify the Tables and Relationships:

   • Time Cards are typically stored in the "time_card" table, while Notes are stored in the "sys_journal_field" table.
   • The "sys_journal_field" table has a field called "element_id" that links it to the associated record, which in this case is the Time Card.

2. Build a Report:

   •  create a new report.
   • Choose the "time_card" table as the base table for the report.
   • Add the desired fields from the "time_card" table that you want to include in the report.
   • Next, configure a related table query to include the Notes associated with each Time Card.
   • In the related table query, specify the "sys_journal_field" table and set the condition to match the "element_id" field with the "sys_id" field of the Time Card record.
   • Add the "value" field from the "sys_journal_field" table to display the actual Note content in the report.
   • Customize other report settings such as sorting, filtering, and formatting as per your requirements.

3. Save and Run the Report.

[Danielle10]

Great day, Riya! Thank you for your help!

From your details below, would you be able to send me screenshots of how you did this? I am not following the directions... Please and thank you!!!

More questions for you:

1. • Add the desired fields from the "time_card" table that you want to include in the report.
   • Next, configure a related table query to include the Notes associated with each Time Card.
   • In the related table query, specify the "sys_journal_field" table and set the condition to match the "element_id" field with the "sys_id" field of the Time Card record.
   • Add the "value" field from the "sys_journal_field" table to display the actual Note content in the report.
   • Customize other report settings such as sorting, filtering, and formatting as per your requirements.

2. Save and Run the Report.

[Danielle10]

I am not sure how you find the sys_journal_field.

Also, what type of report should this be? You never put that information. List type? Bar type? 

[Danielle10]

Good day, this report is not able to be created with the information that you gave.