logo

NJP

Are you wondering why work notes/additional comments data not showing in activity filter?

Import · Jun 30, 2020 · article

Some times we may need to create custom table(s) extending from already available tables which has work notes/additional comments field on it. Assume all the ACL's were in place.

Ex: Create a custom table (Demo CR) extending from Change Request table and set the ACL's with itil role.

Issue:

When user (with proper roles) access one of the record from newly created custom table and trying to add some comments in work notes/additional comments field, those can't be visible on activity filter.

Ex: Login as admin/itil role user, to access the custom table (Demo CR). Create a new record with some random values and open the same record. Try to enter work notes and see those changes captured in activity filter?

Solution (Fix):

The reason behind this issue is journal fields store the data in activity filter only if the table Audit is enabled. We can fix this in two ways...

1. Enable Audit through collection record:

  • Navigate to Collection record of the Custom table

Dictionary Entries Search Table All>Tablecontainsdem0>Table=u demo cr G) Table A —u demo ct u demo cr Column name Search Search Search Collection Search (empty)

  • Enable the Audit check box.

![* Table Type Demo CR u_demo_crl Collection Application Function field Read only Audit Global

2. Remove and add back Activities (filtered) from the form layout:

  • Open the form layout and remove the Activities (filtered) and save it.

Available urgency User input Variables->Task Visual Task Board Card->Task l- begin_split -l l- split -l l- end_split-l • Annotation • Chart Activities (filtered) Attached Knowledge Change Variable Editor Checklist Conflict Checker Progress Contextual Search Results Parent Breadcrumbs l- begin_split -l Watch list l- split-I Work notes list l- end_split -l Additional comments Work notes Cancel

  • Again open the form layout of the same table and add back Activities (filtered) to the right section and right position.

Available Time worked Time Worked->Task Transfer Order Line Subtask->Parent Transfer Order Line Task->Parent Type unauthorized updated updated by updates upon approval upon reject urgency user input Variables->Task Visual Task Board Card->Task begin_split -l l- begin_split -l Watch list l- split-I Work notes list l- end_split -l Additional comments Work notes Activities (filtered) > Cancel

  • System automatically enables the "Audit" check box and below message can be displayed on the form.

Demo CR CHG0030002 @ Auditing has been turned on for this table.

View original source

https://www.servicenow.com/community/now-platform-articles/are-you-wondering-why-work-notes-additional-comments-data-not/ta-p/2305853