Show demands that where the note have not been updated.

[tomhamill]

Hi, I would like to build a report that shows demands where there has been no Journal Entries in 14 days.   I tried to base the report on the sys_journal_field table but that table does not display as an option.  Thank You

[Ankur Bawiskar]

@tomhamill 

that's a system table and hence not showing in report

update this property and include this table, then it starts showing in the report creation

glide.ui.permitted_tables

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Mark Manders]

Check the system property for allowed tables. Probably the 'sys_journal_field' table isn't there. But I also think that it won't really help in your requirement. Reporting on something that isn't there, isn't easy (maybe you can check on journal entries over 14 days old, but what if they aren't updated at all?). 

However, there is a way to report on them. You can create a script include that returns the demands if there is no journal entry or if the latest one was 14 days ago by following this KB: https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0832058

[Dr Atul G- LNG]

Hi @tomhamill 

You need to add entry in this property

https://INSTANCENAME.service-now.com/now/nav/ui/classic/params/target/system_properties_ui.do%3Fsysp...