How to create a report on sys_journal_field table

____39
Tera Contributor

‎06-20-2022 11:30 PM

How to create a report on sys_journal_field table

0 Helpfuls
  • 2,200 Views
3 REPLIES 3

Harish KM
Kilo Patron
Kilo Patron

‎06-20-2022 11:34 PM

Hi sys_journal_field is not reportable.  Go thru the below links 

https://community.servicenow.com/community?id=community_question&sys_id=814465e4db396700107d5583ca961919

https://community.servicenow.com/community?id=community_question&sys_id=df0f8fa1dbdcdbc01dcaf3231f961913

Regards
Harish
0 Helpfuls

____39
Tera Contributor
In response to Harish KM

‎06-20-2022 11:41 PM

Hi, thank you for responsing, I can not visit this site, Is there a document about database view?

http://wiki.servicenow.com/index.php?title=Database_Views

0 Helpfuls

Jaspal Singh
Mega Patron
Mega Patron

‎06-20-2022 11:53 PM

Hi,

Can you confirm your exact Business need?

You might want to create a database view required table (incident, change, etc.) & sys_journal_field that holds sys_id of record in Element field.

You can check on existing Incident SLA database view by navigating to System Definition >>Database Views  

0 Helpfuls