Raju Koyagura
Tera Guru

Use case:

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.

 

Version history
Last update:
‎06-29-2020 09:52 PM
Updated by: