Can we Report on HR Case and Journal table database view in PRODUCTION

PriyaVella
Tera Contributor

‎02-27-2025 09:10 AM

Hi, so we are trying to fetch list report of rejected cases. We need historic data, with rejected time as well. So we have created database view (sn_hr_core_case) and (sys_journal_field) tables, and a filter in report (values starts with 'Reason for rejection') text as its a prefix which gets added whenever a case is rejected by user  in comments. We did get the report as expected. But our concern is will this cause an impact in prod as journal table is huge.

Thanks

0 Helpfuls
  • 249 Views
1 REPLY 1

Dr Atul G- LNG
Tera Patron
Tera Patron

‎02-27-2025 11:23 AM

Hi @PriyaVella 

Yes, you can create the DB view, but it will impact performance. As you rightly said, the audit table is huge, and the query might get stuck at the WHERE clause.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************