- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-15-2025 04:02 PM
Hi Community,
I need to create a quick message for the P1/P2 incidents to show all the work notes have been added to this incident so far. In the quick message, I use ${work_notes} to pull the variable but the maximum work notes number that listed in the quick message is 3. It always shows the latest 3 work notes of this incident. How to show all the work notes in the quick message?
Thanks
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-15-2025 06:17 PM
Hi @ShuRiseUp2023 ,
1. you can set the system property value to -1
glide.email.journal.lines
note: this would be reflecting in all over the system
2. else follow this approach
create a Before insert update BR on the sys_email and sys_email_draft table
with script
(function executeRule(current, previous /*null when async*/ ) {
// Add your code here
var targetRecord = new global.GlideRecordUtil().getGR(current.getValue('target_table'), current.getValue('target_record'));
if (targetRecord.isValidRecord()) {
current.setValue('body', current.getValue('body').replaceAll('{placeHolderWorknotes}', targetRecord.work_notes.getJournalEntry(-1)).replaceAll('\n','<br/>'));
}
})(current, previous);
add the key Word {placeHolderWorknotes} in whichever the quick message you want
The BR parses it and replaces it with the worknotes
Please mark my answer as helpful/correct if it resolves your query.
Regards,
Chaitanya
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-15-2025 08:12 PM
Hi @ShuRiseUp2023 ,
yes, it's instance for sys_email and target_record for the sys_email_draft table
1 and 2 are two approaches you can follow
I forgot to mention that
either you can set the property to -1
or
you can go with the BR approach
Please mark my answer as helpful/correct if it resolves your query.
Regards,
Chaitanya
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-15-2025 08:23 PM
I used the 2nd approach and created business rule on sys_email table. Thanks a lot for your help!
Don't know what to do with email draft table. there's no records in email draft table.